ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
PeopleSoft Plugin Locking PeopleSoft Tables
Article ID: 187399
Workload Automation Agent
When we restart autosys, AutoSys will put a lock on PeopleSoft tables and it will not release it. It is affecting our PeopleSoft environment by not allowing any batch PeopleSoft jobs to run until we have a DBA kill the offending PeopleSoft process. The two PeopleSoft tables we saw locked were: SYSADM.PSPRCSRQST and SYSADM.PSPRCSQUE
Happening when we apply O/S Patches on Linux machines as well.
This is because when the PeopleSoft Database is restarted, But agent is not restarted, PS tables might get locked.
Release : 11.4
Component : CA Workload Automation Agent for PeopleSoft
1589 LINUX ORA 11.3.6 SP7
- PeopleSoft Agent would not lock up a PS table while the O/S is being patched. - When O/S Patches are applied Broadcom strongly recommends to stop PS Agent. - Everytime PeopleSoft Database is restarted, PeopleSoft Agent also need to be restarted. Because It uses persistent connections to PeopleSoft Database.