I am getting the following error:

System Error Detected: Database error

SQLExecDirect failed with [[ODBC Error: state=23000, nativeErr=547, err=[Microsoft][SQL Server Native Client 10.0][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FKStatDataStatID__0F975522". The conflict occurred in database "poweradmin", table "dbo.Statistic", column 'StatID'.]

[ODBC Error: state=01000, nativeErr=3621, err=[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.]
] for SQL=[SET NOCOUNT ON;
BEGIN TRAN;
INSERT INTO StatData (StatID, Value, Date) VALUES (1355, 15.076154, {ts N'2015-04-17 10:20:06'});
INSERT INTO StatData (StatID, Value, Date) VALUES (1359, 0.000272, {ts N'2015-04-17 10:20:06'});
INSERT INTO StatData (StatID, Value, Date) VALUES (1361, 0.000466, {ts N'2015-04-17 10:20:06'});
INSERT INTO StatData (StatID, Value, Date) VALUES (1358, 340.039094, {ts N'2015-04-17 10:20:06'});
INSERT INTO StatData (StatID, Value, Date) VALUES (1360, 582.079437, {ts N'[Trimmed]]

Anyone know how to fix this?

asked 02 May '15, 12:49

alvinh's gravatar image

alvinh
111
accept rate: 0%


Hi alvinh,

Would you please zip up and send us your Service_Log.txt log file. I'll take a look to see what is causing the error. support@poweradmin.com

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 04 May '15, 12:17

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

Hi alvinh,

In the rare case that this error happens, it seems to happen when Satellites are involved (the statistic IDs get out of sync). Restart any Satellite services you have (you can do this from within the Console -- right-click the Satellite) and that should resolve it.

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 04 May '15, 15:16

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

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:

×38
×22

Asked: 02 May '15, 12:49

Seen: 8,851 times

Last updated: 04 May '15, 15:16