Event Viewer showing: Arithmetic overflow error converting IDENTITY to data type smallint

Versions / Builds Affected

All versions

Status

Resolved

Problem Summary

GFI Webmonitor will show no data in the dashboard, report will be blank and Windows events will be flooded with event ID 0

TT / JIRAID

1248

How to Identify

1. Check the Windows Events - you will find many events like this one: Log Name: Application Source: WebMonitor Date: 14.1.2014 14:04:06 Event ID: 0 Task Category: None Level: Error Keywords: Classic User: N/A Computer: PKUTMG01.ipku.pku.cz Description: Error occurred during bulk inserted data processing. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred. 2. Check the dashboard for the present day - no date is displayed 3. Run a report for the day - no data is displayed 4. Open the management studio and run the following query USE [DATABASE_NAME] SELECT count(*) FROM [dbo].[ActivityBulkData] GO This table should only have temporary data - if it has a large number of items it is a sign that the data is not been transfer from this table to the other tables in the database

Workaround / Fix Details

PSG have script that can correct this problem

Required Actions

Collect Windows events and escalate