ITPAM worflow instances are not starting and CPU load is 100% by PAM's JAVA process

Products

• CA Process Automation Base

Issue/Introduction

Issue:

ITPAM is getting hung and during this noted CPU load is 100% by PAM's java process, the web interface is inaccessible and workflow instances don't start.

Environment

ITPAM 4.4 CP02

Cause

The  PAM Database was imported from one DB server to another DB server and then installed a new ITPAM.

Resolution

-> Importing the PAM database from one DB server to another DB server and installing a new PAM to this new DB server is not recommended and may or may not work depending on the DB state.

-> Reviewed the configuration and corrected the DB to bring the PAM server up and running. Removed the bad entries from the properties table, ServerCnfgProperties, and JGROUPSPING.

The ideal way to Migrate the Database from one server to another server is as follows so that no need to modify the configuration or DB entries:

1. Stop the PAM server

2. Export and Import the Database from one DB server to another DB server

3. Reinstall the PAM (with the same version) with the import database and start to ensure whether it's working or not.

4. Stop and Upgrade PAM if needed to upgrade.