CA Process Automation 4.3 versions below CA PAM 4.3.03.
CA Process Automation is formerly known as CA IT Process Automation (CA ITPAM).
The root cause is a known issue in versions of CA PAM 4.3 below CA PAM 4.3.03.
The CA PAM Scheduler was not clearing entries from the ActiveMQ table.
This caused a data pile-up, which not only prevented the old CA PAM Processes from Running, but prevented new ones from Running.
1) Upgrade CA PAM to 4.3.03, which contains a Scheduler patch, and reboot system.
2) If necessary, remove old entries from the ActiveMQ table if they are not processed in a timely manner. These processes will be lost.
The recommended way to do this is by "Archiving" these entries via the CA PAM interface.
If there are a lot of queries, this may require multiple passes to get all of the States effectively.
3) ONLY IF you cannot remove the stuck Processes via the CA PAM interface, these can be removed by direct database removal.
CAUTION: As these steps will result in data loss, and need care to exercise, the steps and tables are not being provided in this general purpose knowledge document.
There are related knowledge documents below though that may assist.
If you suspect that you have this issue, please log an issue with CA Support, so that we may assist with the review of the data.
It would also help to rule out similar but different issues, such as some processes are stuck but others run freely.
Please backup your database.
Please log an issue with the following:
A) Confirmation that the system has been upgraded to CA PAM 4.3.03 and rebooted.
NOTE: This is a mandatory step. CA Support cannot assist if this is not completed.
B) Include the CA PAM logs, in particular the c2o.logs, view.logs, and db.logs
Note that these logs may have additional numbers in their names as additional log files are generated, so sort by date and attach the most recent.
Please also include screenshots and a summary to help state the nature of the issue.
C) It will be necessary to arrange a time between your site Database Administrators, your site CA PAM Administrator, CA Support and CA Engineering.
So please allow time for these meetings to be arranged at a mutually overlapping timezones, and for the review of the initial log and summary information.
CAUTION: Direct database manipulation will result in permanent removal - or inadvertent loss or corruption - of data.