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)

asked 20 Feb '14, 17:41

PWCSITServices's gravatar image

PWCSITServices
111
accept rate: 0%


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
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 21 Feb '14, 08:55

Quinn's gravatar image

Quinn ♦♦
14.1k3925
accept rate: 37%

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:

×19
×3

Asked: 20 Feb '14, 17:41

Seen: 2,535 times

Last updated: 21 Feb '14, 08:55