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

asked 12 Nov '13, 10:22

jmosley's gravatar image

jmosley
1111
accept rate: 0%


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.

link

answered 12 Nov '13, 12:18

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

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

link

answered 12 Nov '13, 16:18

jmosley's gravatar image

jmosley
1111
accept rate: 0%

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

link

answered 13 Nov '13, 09:36

jmosley's gravatar image

jmosley
1111
accept rate: 0%

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.

link

answered 13 Nov '13, 12:56

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

Thanks Quinn, That did it.

link

answered 13 Nov '13, 12:58

jmosley's gravatar image

jmosley
1111
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×16
×7

Asked: 12 Nov '13, 10:22

Seen: 10,941 times

Last updated: 13 Nov '13, 12:58