Technical FAQs

Ask a Question

ENM 7.0 Hot Standby WebUI DB exception when Importing Settings onto Secondary Machine

Goals and Symptoms

After Importing ENM Hot Standby Settings onto Secondary Machine, and pressing "Apply Changes" in the Hot Standby tool, WebUI DB exceptions continue to appear in ENM Diagnostic Log

HandlingInstanceID: 441ca05d-6192-4280-b50b-af5ad96c248b An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught. ----------------------------------------------------------------------------------
09/09/2013 11:45:56 Type : System.Data.SqlClient.SqlException, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089

Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UI_WEB_USER_PREFERENCES_UI_WEB_USERS". The conflict occurred in database "PLES_AEHistory", table "dbo.UI_WEB_USERS", column 'User_ID'. The statement has been terminated.

Source: .Net SqlClient Data Provider Help link : Errors : System.Data.SqlClient.SqlErrorCollection Class : 16 LineNumber : 22 Number : 547 Procedure : usp_UI_Web_Set_User_Preferences Server : ENMSUS6SEC State : 0 ErrorCode : -2146232060 Data : System.Collections.ListDictionaryInternal TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean) Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlC

Causes and Fixes

This issue is caused by the ENM UI being open while changes are made to the database by the Hot Standby Tool.

If exceptions are already occurring, exit out of Internet Browser (close all windows) and reopen. Exceptions will cease to be generated. If the Import task must be performed again, close all open Internet browser windows before applying changes in Hot Standby.

Note: The attachment shows a screen shot of the error.


(Removed File URL: 212537_DF32/importbug.png)(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/5946b122e49a72d4c1257bc3001195e0/fl_block_5/0.E2?OpenElement&FieldElemFormat=gif)importbug.png

Legacy KB System (APS) Data: RESL212537 V1.0, Originally authored by MiZe on 09/19/2013, Last Edited by MiZe on 09/19/2013
Related ranges: Paging Module
Was this helpful?
What can we do to improve the information ?