PeopleSoft Component Interface

Component Interface error message while performing a MSS transaction like terminate an employee

Need reason for the attached error message and provide details as to why the WORKFORCE_SYNC is failing.

SQL error. Stmt#:332 Error Position:0 Return: 8604 - [IBM][CLI Driver][DB2] SQL0913N Unsuccess

Regarding Errror -"SQL.Execute: SQL object is not open, or is a open on a select."

Hi,
I am trying to load a set of data files using Application Engine and CI.
I was successfully able to load 1 file with 500 rows and without any issues.
but while loading the 2nd file I encounterd an error:
"SQL.Execute: SQL object is not open, or is a open on a select. (2,295) AF_ACCT_TRAN.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:5107 Statement:71"

Can someone please help?

Following is my code:

/* ===>
This is a dynamically generated PeopleCode template to be used only as a helper
to the application developer.

Instance already exists for a CI

I am loading data from a CSV file into PS database using App engine and CI.Only the first row of data gets loaded ,while loading the 2nd row it gives an error saying Instance already exists for a CI.
So create failed.Can some one please help?
Following is my code:

/* ===>
This is a dynamically generated PeopleCode template to be used only as a helper
to the application developer.
You need to replace all references to '[*]' OR default values with  references to
PeopleCode variables and/or a Rec.Fields. */


Local File &fileLog;
Local ApiObject &oSession, &oAfAcctTransCi;

Peopletools

WHILE INSERTING DATA FROM CI I AM GETTING THIS ERROR-Instance already exists {TM_JOB_CI}....PLZ HELP.. TM_JOB_CI IS MY CI NAME

Getting error 'Unknown key of uninstantiated object {USER_PROFILE.UserID} (91,16)' while saving Component Interface

I am getting the error 'Unknown key of uninstantiated object {USER_PROFILE.UserID} (91,16)' while saving the component interface using the following code:-

SQLExec("Select OPRID from PSOPRALIAS where PERSON_ID = :1", RD_PERSON.PERSON_ID.Value, &lstrOPRID);

If All(&lstrOPRID) Then
try
rem ***** Set the Log File *****;
&fileLog = GetFile("C:\temp\USER_PROFILE.log", "w", "a", %FilePath_Absolute);
&fileLog.WriteLine("Begin");
&oSession = %Session;
&oSession.PSMessagesMode = 3;

Unanswered Forum Posts