Why am I getting the "Cannot set a Credential Source" message ?

Article Id: 103782

Status: Published

Updated On: 29-06-2018 04:48

Products:

CA Privileged Access Manager - Cloakware Password Authority (PA) , PAM SAFENET LUNA HSM , CA Privileged Access Manager (PAM) , CA Privileged Access Manager (PAM)

Issue/Introduction:

I have a device group defined to which I am attaching a credential source. Saving it works- apparently and there is no error, but when I reopen the device the credential manager just added is gone.

In the session logs I can see

PAM-CM-0539: A database error occurred. com.cloakware.cspm.server.app.ApplicationException: CODE=1052 MSG=Column 'targetserverid' in where clause is ambiguous,0, --,,0

but nothing else. I have verified there are no duplicate target servers or devices. What may be happening ?

Environment:

CA PAM 3.X Cluster

Resolution:

The DB on the primary node of the cluster was locked and this prevented the group from being updated properly. Restarting the cluster brought the databases in sync and this solved the problem