[SiteMinder][ODBC]One of the Policy Server throwing error - Failed preparing audit log insert: Internal Error

book

Article ID: 209533

calendar_today

Updated On:

Products

SITEMINDER

Issue/Introduction

Frequently seeing the below error and which has impacted the customer login to the application.

[2512/1876][Mon Feb 08 2021 10:01:17][SmReportsODBCLog.cpp:636][ERROR][sm-Server-04560] Failed preparing audit log insert: Internal Error: Null connection pointer. Error code -4003. Code: -4003. DB Code: 0 
[2512/1876][Mon Feb 08 2021 10:01:18][SmReportsODBCLog.cpp:636][ERROR][sm-Server-04560] Failed preparing audit log insert: Internal Error: Null connection pointer. Error code -4003. Code: -4003. DB Code: 0 
[2512/1876][Mon Feb 08 2021 10:01:18][SmReportsODBCLog.cpp:1260][ERROR][sm-Server-07037] Policy Server is shutting down. Issues with Audit Database connectivity will cause the loss of 588 audit records. 
[2512/1876][Mon Feb 08 2021 10:01:18][SmReportsODBCLog.cpp:1301][ERROR][sm-Server-02700] Failed to write audit log record. Record dropped. 
[2512/1876][Mon Feb 08 2021 10:01:18][SmReports.cpp:529][ERROR][sm-Server-02700] Failed to write audit log record. Record dropped. 

 

Due to Synchronous Auditing(Business Requirement), users are unable to login when this error occurs.

Restart of policy server resolves the issue temporarily but gets into same condition soon.

Cause

Some of the Connections to the Audit store are taking long time hence threads are moving to wait state, on connection timeout the threads are not coming out of the wait state properly.

Environment

Release : 12.8.03

Component : SITEMINDER - Policy Server

Resolution

ODBC_win_12803.zip has been provided for R12.8 SP3.

This corrected the odbc layer such that threads will handle the timeout properly.

 

This fix is included in R12.8 SP5 so an upgrade should resolve the problem.

Attachments

1614651845877__ODBC_win_12803.zip get_app