Policy Server :: ODBC : 20119 Housekeeping Policy Data Read

Products

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

Issue/Introduction

Description:

I am running a Policy Server with an ODBC Policy Store, and I get this error in the smps.log:

[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:ODBC0012][ERROR] An error occurred when calling "SQLExecute" for "Housekeeping Policy Data Read" query 
[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:ODBC0002][ERROR] 20119:0 [DataDirect][ODBC SQL Server Driver]20119 
[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:ODBC0012][ERROR] An error occurred when calling "SQLExecDirect" for "Delete Tombstones" query 
[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:ODBC0002][ERROR] 20119:0 [DataDirect][ODBC SQL Server Driver]20119 
[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:ODBC0001][ERROR] While calling "SQLEndTran (ROLLBACK)", the following error occurred: 
[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:ODBC0002][ERROR] 20119:0 [DataDirect][ODBC SQL Server Driver]20119 
[15030/29][Wed Feb 29 2012 08:20:58][CA.XPS:XPSIO040][ERROR] Delete of Tombstones failed.

What does this error means?

Solution:

The '20119' code is generated by the SQL Server ODBC Driver when:

"It detects that the communication link to the database has been broken. This should then translate to a SQLState of '08S01' ("Communication Link Failure") if the driver manager can locate the message catalog."

(http://www-01.ibm.com/support/docview.wss?uid=swg21420018)

You need to check the connectivity between the Policy Server and the Database.

Environment

Release:
Component: SMPLC