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?

Document ID : KB000051587
Last Modified Date : 14/02/2018
Show Technical Document Details

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

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:

UNIX:
https://support.ca.com/irj/portal/kbtech?docid=477982
Windows:
https://support.ca.com/irj/portal/kbtech?docid=491497

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.