Question

SQL Errors in Audit Trail

Audit Trail

Updated July 5, 2019

asked on January 6, 2017

Hi,

We are seeing some errors in the SQL log for the audit trail database.

(1) Error 2627 occurred 391788 times:

Violation of PRIMARY KEY constraint 'auditevent_pk'. Cannot insert duplicate key in object 'dbo.audit_event'. The duplicate key value is (232814396).

(2) Error 515 occurred 1544 times:

Cannot insert the value NULL into column 'reason_event_type', table 'LFAudit_Intertrust-HK_91.dbo.audit_reason'; column does not allow nulls. INSERT fails.

Is this normal behavior?

Is not affecting the functionality of Audit Trail but I wonder if there is something misconfigured.
We use LF 9.2

Thanks
Gian

0 0

Answer

SELECTED ANSWER

replied on January 6, 2017

Those insertion failures can happen during normal operation. Each audit event is assigned a unique ID by the Laserfiche server and that is used as its PK. Obviously Audit Trail can only successfully insert that event one time, but Audit Trail may attempt multiple times as an event moves through its storage lifecycle, from being in the current log to rolling over into an archived log file.

1 1

Replies

replied on July 5, 2019

Hi Brian,

Do you mean it is known issue with Audit trail as we have seen this behavior even with Laserfiche 10.2.

any idea how to disable these logs as this would be loading event log on server with each activity.

0 0

You are not allowed to follow up in this post.

Question

Question

SQL Errors in Audit Trail

Answer

Replies

Sign in to reply to this post.