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.

ITPAM executed instances got queued up after failover


Article ID: 212480


Updated On:


CA Process Automation Base


CA Process Automation stops working when a SQL Server cluster fails over.

Unable to get managed connection for RuntimeLibDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for RuntimeLibDS)

Caused by: java.sql.SQLException: Unable to access availability database 'PAM_Production_Runtime_SP5' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.


Release : 4.3

Component : Process Automation


This is a problem with the Database cluster configuration; as per the error message the failover SQL node must be marked either primary or secondary, otherwise ITPAM cannot write to it.