release – JBlog

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…