PS_AERUNCONTROL

PS_ARUNCONTROL – is used to record temporary information onPeopleSoft running processes that are restart enabled. When a processes endedin success the corresponding record in PS_AERUNCONTROL is deleted.Actually,this table stores temprorary references only to the processes that have theoption “Restart” enabled, otherwise no record will be inserted in this table.
The PS_AERUNCONTROL table is comes very useful when a process fails in a “NoSuccess” or “Error” status. When such a process is enabled to restart butcompletes in error the part when its corresponding recored is removed fromPS_AERUNCONTROL may not run, therefore causing the reruning of the process tofail again, because this table only stores unique records of a specific processinstance.
A custom practice is to delete the corrresponding record of a failed process(enabled to restart) from this table before rerunning it.
The problem becomes more tedious when such a process allocates many temporarytable instances and it fails repeatedly with ABnormal END(ABEND). In thissituation a close monitoring of the page from the menu (PT 8.22)PeopleTools>Application Engine>Manage Abends is recommended.
If the following error appears:” Warning: No dedicated instances available forxxxxxxx_TAO – using base table ” one may consider using the Delete option onthe Manage Abends page for the affected process or issuing the followingcommands on the database:
DELETE FROM PS_AETEMPTBLMGR where PROCESS_INSTANCE=’xxxxxx’;
DELETE FROM PS_AERUNCONTROL where PROCESS_INSTANCE=’xxxxxx’;
DELETE FROM PS_AERUNCONTROLPC where PROCESS_INSTANCE=’xxxxxx’;
Also, before running the process again one should take into considerationincreasing the number of instances of the associated temporary tables.