Posted on : 04-12-2009 | By : Elisabeta Olteanu | In : 1 PeopleSoft Table per day
PS_ARUNCONTROL – is used to record temporary information on PeopleSoft running processes that are restart enabled. When a processes ended in success the corresponding record in PS_AERUNCONTROL is deleted.Actually, this table stores temprorary references only to the processes that have the option “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 “No Success” or “Error” status. When such a process is enabled to restart but completes in error the part when its corresponding recored is removed from PS_AERUNCONTROL may not run, therefore causing the reruning of the process to fail again, because this table only stores unique records of a specific process instance.
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 temporary table instances and it fails repeatedly with ABnormal END(ABEND). In this situation 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 for xxxxxxx_TAO – using base table ” one may consider using the Delete option on the Manage Abends page for the affected process or issuing the following commands 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 consideration increasing the number of instances of the associated temporary tables.