search cancel

audit probe is not able to insert data anymore in the database

book

Article ID: 202558

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

It seems the audit probe is not able to insert data anymore in the database:

Oct 14 11:23:53:262 [17188] audit: [audit] InsertAuditEvent - 2 errors 
Oct 14 11:23:53:262 [17188] audit: (1) InsertAuditEvent [Microsoft OLE DB Provider for SQL Server] Arithmetic overflow error converting IDENTITY to data type int. 
Oct 14 11:23:53:262 [17188] audit: (2) InsertAuditEvent [Microsoft OLE DB Provider for SQL Server] Arithmetic overflow occurred. 
Oct 14 11:23:53:262 [17188] audit: AnalyzeAuditRecord error, id == 0 
Oct 14 11:23:53:364 [17188] audit: [audit] InsertAuditEvent - 2 errors 
Oct 14 11:23:53:364 [17188] audit: (1) InsertAuditEvent [Microsoft OLE DB Provider for SQL Server] Arithmetic overflow error converting IDENTITY to data type int. 
Oct 14 11:23:53:364 [17188] audit: (2) InsertAuditEvent [Microsoft OLE DB Provider for SQL Server] Arithmetic overflow occurred.

Environment

Release : 20.1

Component : UIM - AUDIT

Environment:
SQL Server: SQL Server 2012
OS: Windows 2012R2
DX Infrastructure Manager: DXIM version 20.1

audit probe versions higher than 1.73 including 9.03 and 9.04.

Cause

- audit table data type

Resolution

DBCC CHECKIDENT (audit_event, RESEED, 0);
DBCC CHECKIDENT (audit_config_change, RESEED, 0);

Repaired the audit tables.