PAMonitor Database Error

PWCSITServices 1
Viewed 0

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)

sqlexecdirect database
1 Answers

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.

Quinn2713
Related