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

book

Article ID: 212480

calendar_today

Updated On:

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.