ITPAM executed instances got queued up after failover

Products

• CA Process Automation Base

Issue/Introduction

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.

Environment

Release : 4.3

Component : Process Automation

Resolution

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.