PeopleTools Tip — App Engine Restart If you get …



PeopleTools Tip — App Engine Restart

If you get an error message like this, you either need to restart the specific instance that abended, or remove the restart row from the table.

PeopleTools 8.46 – Application Engine Server

Copyright (c) 1988-2006 PeopleSoft, Inc.

All Rights Reserved

PSAESRV started service request at 14.19.05 2006-09-19

All Processing Suspended: Restart OPRID=PS, RUNID=AppEngName, PI=499 (108,503)

PSAESRV completed service request at 14.19.05 2006-09-19

Disable Restart:
You can disable the restart on the properties of the application engine, but that will not help when the Application Engine has already abended. Remember, the disable restart prevents the app engine from writing to the restart table when the program abends; it does not prevent it from checking the table to see if another instance is waiting to restart.

In other words, once an application has abended, disable restart will not allow you to rerun the program without restarting.

AERUNCONTROL Record:
The restart status is stored in the record AERUNCONTROL. If you receive the message requiring you to restart instead of rerun, then there is a row in this table for the program you are running and the run control that you are using.

Fields:
PROCESS_INSTANCE — instance that abended
OPRID — your user name
RUN_CNTL_ID — run control used when it abended
AE_APPLID — Application Engine program name

Fixing the Error:
To fix the error, you either have to delete the row from the table or restart the original process instance that abended.

SELECT * FROM PS_AERUNCONTROL WHERE AE_APPLID = ‘<App Engine Name>

Update:
Ray pointed out that PeopleSoft has provided an online way to fix the problem. You can do it from the page: PeopleTools > Application Engine > Manage Abends

Deleting the Row:

If you are the only one with an abended program, you can just truncate the whole table:

TRUNCATE TABLE PS_AERUNCONTROL

Or, if you want to just affect your program, you can do something more like this:

DELETE FROM PS_AERUNCONTROL WHERE OPIRD = ‘<username>‘ AND RUN_CNTL_ID = ‘<run control>


Share

3 Comments

  1. Steve Kemper says:

    I tried the following, but recieved a message stating “An error was encountered performing the requested operation: Closed Connection Error at line: 37″

    DELETE FROM PS_AERUNCONTROL WHERE OPIRD = ‘SUSER‘ AND RUN_CNTL_ID = ‘MIKELEE‘;
    DELETE FROM PS_AETEMPTBLMGR WHERE OPIRD = ‘SUSER‘ AND RUN_CNTL_ID = ‘MIKELEE‘;

    • Neil says:

      Steve,
      Try restarting your App Desinger, after saving your AE program. This will help for sure. Happened with me also & I got this solution from one of the forums here.

  2. Giridhar says:

    Gud Explanation About All Processing Suspended error
    http://psoftadmirer.blogspot.com/2010/06/peoplesoft-error-all-processing.html

1 Trackbacks

Leave a comment