temporary table

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…

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…