What is the meaning of the Audit Database "Failed preparing audit log insert: Unexpected error in database interface. . Error code -1063. Code: -1063. DB Code: 0" in the smps.log?

Products

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

Issue/Introduction

Description:

When using an audit database to record events, you may encounter the following error:

"[ERROR] Failed preparing audit log insert: Unexpected error in database interface. . Error code -1063. Code: -1063. DB Code: 0

 

Environment

Release:
Component: SMPLC

Resolution

Solution:

This error is quite generic and we first need to have a look at the DB side if everything is correct

Then we can enable the ODBC tracing to get more information on the error itself, depending on the OS we can read the following technical document:

https://knowledge.broadcom.com/external/article/54489

Usually this occurs when the audit information was too huge and exceeding the defined size limit(4096 bytes).
This requires modifying the SQL file to increase the row length as a workaround.