Arithmetic Overflow Occurred error is generated in the AVIcode Intercept Log

Article ID: 2686673 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You receive a message in the Intercept Log on a server hosting an AVIcode SEViewer instance that is similar to the following:

Message: Arithmetic overflow occurred.
Arithmetic overflow error converting IDENTITY to data type int.
Source: Microsoft OLE DB Provider for SQL Server
Target Site: System.Data.OleDb.OleDbDataReader ExecuteReaderInternal(System.Data.CommandBehavior, System.String)

Stack Trace: at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Avicode.AX5.Data.OleDb.OleDb.ExecuteNonQuery(OleDbCommand oleDbCommand)

Message: Arithmetic overflow occurred.

Arithmetic overflow error converting IDENTITY to data type int.

Command text: INSERT INTO PCOUNTER ( VALUE_BASE, VALUE_DATE, VALUE_STRING, ID, PID, UTCDATE, SOURCEID, PCTYPEID, PCPROCESSID, PCMACHINEID, ISSTATE ) SELECT 37790.5251,NULL,NULL,46,NULL,'20120127 21:15:38',NULL,3,NULL, 186, 1 UNION ALL SELECT 6425471.753443,NULL,NULL,39,NULL,'20120127 21:15:38',NULL,34,NULL, 186, 10


CAUSE

This issue can occur when the PCOUNTERID column reaches the value 2,147,483,647. This is due to the limitation of the data type INT being 4 bytes and unable to hold any larger values.

The PCOUNTERID value is incremented each time a new data item is written to the PCOUNTER table and is never reset, so even with regular grooming this issue can occur.


RESOLUTION

To resolve this issue, the PCOUNTERID column must be reseeded. To check the current identity value, run the following SQL command in SQL Management Studio:

DBCC CHECKIDENT (“dbo.PCOUNTER”, noreseed)

If the current identity value is 2147483647, reseed the identity column using the following SQL Command:

DBCC CHECKIDENT (“dbo.PCOUNTER”, reseed)



Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2686673 - Last Review: July 9, 2012 - Revision: 4.0
APPLIES TO
  • AVIcode, Inc.
  • Microsoft System Center 2012 Operations Manager
Keywords: 
kbtshoot KB2686673

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com