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.