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
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:
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.