Application Engine

Application Engine debugging issues – ParseXmlFromURL

By hiojay | August 31, 2011July 19, 2013 by hiojay

I was trying to debug an application engine process in Application Designer, and the following line (in bold) would throw an exception and prevent me from debugging any further

Local XmlDoc &objXMLDoc;
   &objXMLDoc = CreateXmlDoc("");
   &booReturn = &objXMLDoc.ParseXmlFromURL(&sTmplFile);

Local XmlDoc &objXMLDoc;

&objXMLDoc = CreateXmlDoc("");

&booReturn = &objXMLDoc.ParseXmlFromURL(&sTmplFile);

The value of &sTmplFile was:

\files\XMLP\bb4ba112-d394-11e0-bd82-ee802d84f08b\CCCG0005_1_0

1	\files\XMLP\bb4ba112-d394-11e0-bd82-ee802d84f08b\CCCG0005_1_0

I finally discovered that the ParseXmlFromURL method requires a fully qualified path. For example:

c:\files\XMLP\bb4ba112-d394-11e0-bd82-ee802d84f08b\CCCG0005_1_0

1	c:\files\XMLP\bb4ba112-d394-11e0-bd82-ee802d84f08b\CCCG0005_1_0

My environment was not prepending the drive component because it did not have the PS_SERVDIR environment variable defined. Once I set this variable, everything…

Oracle PeopleSoft

Application Engine: Releasing Temporary Tables

By hiojay | August 25, 2011July 19, 2013 by hiojay

I was trying to debug an Application Engine and noticed that the debugger had hung. I restarted Application Designer and re-ran the debugger for the Application Engine. Since there was only one instance assigned to each temporary table, I noticed that the previous failed run had not released the temporary tables. I managed to work around this by deleting from the following tables:

PS_AERUNCONTROL
PS_AETEMPTBLMGR

1 2	PS_AERUNCONTROL PS_AETEMPTBLMGR

The following are the SQL Statements that I used:

DELETE FROM PS_AERUNCONTROL WHERE OPRID = 'PS' AND RUN_CNTL_ID = 'JAY';
DELETE FROM PS_AETEMPTBLMGR WHERE OPRID = 'PS' AND RUN_CNTL_ID = 'JAY';
COMMIT;

DELETE FROM PS_AERUNCONTROL WHERE OPRID = 'PS' AND RUN_CNTL_ID = 'JAY';

DELETE FROM PS_AETEMPTBLMGR WHERE OPRID = 'PS' AND RUN_CNTL_ID = 'JAY';

COMMIT;

If…

Oracle PeopleSoft

Can no longer run Application Engine programs from Application Designer

By hiojay | April 5, 2011June 12, 2016 by hiojay

I wasted a good couple of hours trying to figure out why my application engine programs would no longer run in Application Designer (two-tier). I have concluded that it is due to a PeopleTools bug in Application Designer. Something was causing the App Engine program to run in an infinite loop. I had to manually close the psae.exe process, and observed that the log file couldn’t even execute the first step of MAIN: PeopleTools 8.51.03…

PeopleSoft

Application Engine: Temporary Table instancing

By hiojay | February 2, 2011September 1, 2011 by hiojay

What is temporary table instancing? Instancing in the application engine context is when a process run by the user is assigned a dedicated temporary table. When should it be used? It’s a must when there are multiple users running the same process concurrently, or when the same user is running the same process concurrently (i.e. multiple times in parallel). How does it work? A new table is created in the database with a number suffix…

PeopleSoft

Application Engine: The different types of Do Select

By hiojay | December 2, 2010September 1, 2011 by hiojay

Select/Fetch – Opens the cursor only once and retrieves rows one at a time. Commits inside the step (commits in the Called Section) are ignored if the program is restartable (noticeable in the trace file) and are not ignored if the program is not restartable. Reselect – Opens the cursor and closes the cursor on each iteration of the loop. It will re-select the same row of data. Logic in Actions of this step should be…