Versions / Builds AffectedAll versions
Problem SummaryGFI Webmonitor will show no data in the dashboard, report will be blank and Windows events will be flooded with event ID 0
TT / JIRAID1248
How to Identify1. Check the Windows Events - you will find many events like this one:
Log Name: Application
Date: 14.1.2014 14:04:06
Event ID: 0
Task Category: None
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
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 DetailsPSG have script that can correct this problem
Required ActionsCollect Windows events and escalate