Hello, We are using PA Monitor 5.0.3.135 and we are receiving constant "System Error Detected: Database error" as per below. Can anyone explain the error in detail please? Thanks Simon System Error Detected: Database error SQLExecDirect failed with [[ODBC Error: state=22003, nativeErr=8115, err=[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting IDENTITY to data type int.][ODBC Error: state=01000, nativeErr=3606, err=[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow occurred.] ] for SQL=[SET NOCOUNT ON; BEGIN TRAN; INSERT INTO StatData (StatID, Value, Date) VALUES (16058, 1, {ts N'2014-02-20 22:35:44'}); INSERT INTO StatData (StatID, Value, Date) VALUES (16107, 1, {ts N'2014-02-20 22:35:44'}); INSERT INTO StatData (StatID, Value, Date) VALUES (16145, 1, {ts N'2014-02-20 22:35:44'}); INSERT INTO StatData (StatID, Value, Date) VALUES (16174, 1, {ts N'2014-02-20 22:35:44'}); INSERT INTO StatData (StatID, Value, Date) VALUES (16209, 1, {ts N'2014-02-20 22:35:44'}); INSERT INT[Trimmed]] Ver 5.0.3 (Build 135) |
Hi, We originally defined the StatData table to use a 32-bit int for it's column ID, but over time we've found (as you just did) that it's not big enough. Run this command on the database: ALTER TABLE StatData ALTER COLUMN rowid bigint; Thanks Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer. |