System Error Detected: Database errors. See service log.

jmosley 7
Viewed 0

Excerpt from log file:

COMMIT TRAN; 11-12-2013, 10:15:25.242, TID:01548, PID:02020, SetCoreStatus: 2, id= 11-12-2013, 10:15:25.242, TID:01548, PID:02020, 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 (4723, 1, {ts N'2013-11-12 15:15:25'});

system database-error
5 Answers

Hi jmosley,

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
Quinn

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.

Quinn2713

Thanks Quinn, This was corrected by updating to 5.2 for us.

jmosley7

Correction the update to 5.2 did NOT correct the issue. Running the suggested query above now.

jmosley7

Please run this command on the database:

ALTER TABLE StatData ALTER COLUMN rowid bigint;

Thanks
Quinn

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.

Quinn2713

Thanks Quinn, That did it.

jmosley7
Related