|
Just started getting the following error; can anyone please advise 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 (19897, 19.51836, {ts N'2014-07-15 14:54:37'}); INSERT INTO StatData (StatID, Value, Date) VALUES (19870, 3.214874, {ts N'2014-07-15 14:54:37'}); INSERT INTO StatData (StatID, Value, Date) VALUES (19852, 1.33248, {ts N'2014-07-15 14:54:37'}); INSERT INTO StatData (StatID, Value, Date) VALUES (19899, 15.163592, {ts N'2014-07-15 14:54:40'}); INSERT INTO StatData (StatID, Value, Date) VALUES (19869, 0.022553, {ts N'[Trimmed]] |
|
Hi -- Here is link to another support question that has the fix for the issue. 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. |
|
The message "Failed to get an ODBC statement handle." makes it sound like the connection from PA Server Monitor to the SQL Database is no longer there. Make sure that your connection is good. The second error is an error from adding data to the SQLite database. This also points to the fact that your SQL database connection is not working. Tori |
|
System Error Detected: Database error [at 249-MGTHW-02 remote satellite] #### Failed to get an ODBC statement handle. Error=4294967294, , m_hDBC == NULL |
|
more SQL errors.... System Error Detected: Database error [at Bristol - UBHNT403 remote satellite] #### sqlite_exec failed with 13 (database or disk is full ExtErr=13) for SQL=[begin immediate;INSERT OR REPLACE INTO DevProps (Value, Timestamp, CompID, PropID, Item, Source) VALUES ('410854', 1406028150, 5060, 33, '', 6); INSERT OR REPLACE INTO DevProps (Value, Timestamp, CompID, PropID, Item, Source) VALUES ('596201', 1406028151, 5061, 33, '', 6); INSERT OR REPLACE INTO DevProps (Value, Timestamp, CompID, PropID, Item, Source) VALUES ('503047', 1406028151, 5062, 33, '', 6); INSERT OR REPLACE INTO DevProps (Value, Timestamp, CompID, PropID, Item, Source) VALUES ('6[Trimmed]]. Will re-open |
|
Could be co-incidence but im now seeing this error System Error Detected: Database error [at 249-MGTHW-02 remote satellite] #### Failed to get an ODBC statement handle. Error=4294967294, , m_hDBC == NULL from one of the satellite services form the console |
|
Hi Quinn SQL command run successfully. We ran the SQL you advised in the other thread Complete Steps were
I cant upload any screen shots as I don't have enough Karma......?? |
|
There are two tables, a Statistic table that describes a statistic (and has a StatID), and a StatData table, where the actual data is stored (and refers to the StatID in the Statistic table). 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. |
|
Hi Quinn What information does PA mon write to the StatData table? |
|
Please let me know how this turns out and if your steps are good maybe it would be something to pass on to others. 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. |
|
Thanks for the reply Quinn, The log file ballooned by 130GB to 138GB in total when after 10 hours it smashed into the end of the disk which had thicked out. I rebooted the SQL server and the Database is now currently in recovery mode. Fortunately I have a backup taken from before running the command. I may restore once its recovered. I've been talking to our DBA team and we may approach this slightly differently, we are considering adding a new table in as BIGINT and the copying to this. Will see what happens. |