Technical FAQs

Ask a Question

Active Pager Module 6.2 OPC Logger Patch: "Out of Sync" exception in the logger service

Goals and Symptoms

Symptoms
Note: This patch is included on the APM 6.2 Installation Disc

This patch fixes the "Out Of Sync" exception in the logger service.
The service may stop logging data under heavy load due to internal
xml files being out of sync.

This patch will also fix SMS alarms that do not appear in the monitoring log.

Additional Information:
------------------------
Sample Exception text in the diagnostics log:

HandlingInstanceID: 9b875ee9-c941-493a-97bd-cb5bbb8f513d
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
04/12/2010 10:36:07
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Out of Sync
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 16
LineNumber : 40
Number : 50000
Procedure : usp_xmlDump
Server : (local)\POWERLOGICES
State : 1
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(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehav

Causes and Fixes

Resolution

Note: This patch is included on the APM 6.2 Installation Disc

Replace the PLOPC.Logger.dll with the included patch file


Patch application

1. Stop the OPC Logger service (PLOPCAELogger)
2. Rename the plopc.logger.dll in the [install location]\Opc Logger\ folder
3. Copy the included dll in the [install location]\Opc Logger\ folder
4. Start the OPC Logger service (PLOPCAELogger)

Was this helpful?
What can we do to improve the information ?