|
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'}); |
|
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 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. |
|
Please 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. |