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.