No error message when Agent Key Rollover is executed.

Products

• CA Single Sign On Secure Proxy Server (SiteMinder)
• CA Single Sign On SOA Security Manager (SiteMinder)
• CA Single Sign-On

Issue/Introduction

When customer construct PostgreSQL key store replication, he executed Agent Key rollover in AdminUI to read-only key store.

Because this store is read-only, Agent Key are not rollovered.

But, any error messages (as below) are not output in policy server log (smps.log, smtracedefault.log..)

 

[ERROR][sm-Server-03090] Policy store failed operation 'Save'  for object type 'AgentKey' . Internal Error: Database error.  

Code is -4007 (DBMSG: <<<State = 42000 Internal Code = 229 - 

[DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The UPDATE permission was denied on the object 'smagentkey4', database 'smdb', schema 'dbo'.>>>)

[SmObjServerCommand.cpp:1021][ERROR][sm-Server-03180] Failed to save new persistent agent key '1b-c6a6a0a8-42da-4f3f-bcb0-5ac24aa662c6'

 

Environment

Release:
Component: SMPLC

Cause

This is product issue.

Resolution

This issue will be fixed in 12.52 SP1 CR07.