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.] Anyone know how to fix this? asked 02 May '15, 12:49 alvinh |
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 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. answered 04 May '15, 12:17 Quinn ♦♦ |
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 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. answered 04 May '15, 15:16 Quinn ♦♦ |