Issue:
When bringing up a Data Log Viewer in the Diagrams tab, the query will not run if a custom date range is used. The pre-defined date ranges do work.
Event code: 3001
Event message: The request has been aborted.
Event time: 4/27/2016 1:19:55 PM
Event time (UTC): 4/27/2016 6:19:55 PM
Event ID: c207511df6914d8683ffda333e7ec557
Event sequence: 34734
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/ION-1-131062543838615917
Trust level: Full
Application Virtual Path: /ION
Application Path: C:\Program Files (x86)\Schneider Electric\ION Enterprise\system\WebReach\
Machine name: <machine name>
Process information:
Process ID: 3860
Process name: w3wp.exe
Account name: NT AUTHORITY\SYSTEM
Exception information:
Exception type: HttpException
Exception message: Request timed out.
Environment:
PME Web Applications
Diagrams
Product Line:
Power Monitoring Expert 8.1
Cause:
The issue is the same as FA209340, however the fix for PME 8.0 will not work in PME 8.1. Attempting to apply the 8.0 fix will result in further errors in the Windows Application Log:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/27/2016 10:37:29 AM
Event time (UTC): 4/27/2016 3:37:29 PM
Event ID: 25ddfe666d1248629db7b37f0b9dab9e
Event sequence: 68734
Event occurrence: 3
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/ION-1-131062444156894448
Trust level: Full
Application Virtual Path: /ION
Application Path: C:\Program Files (x86)\Schneider Electric\ION Enterprise\system\WebReach\
Machine name: <machine name>
Process information:
Process ID: 11248
Process name: w3wp.exe
Account name: NT AUTHORITY\SYSTEM
Exception information:
Exception type: FormatException
Exception message: String was not recognized as a valid DateTime.
at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style)
at WebReach.Historical.MapPegQueryToSQL.ConvertWhereClause(String where)
at WebReach.Historical.MapPegQueryToSQL.Execute(Int32 numRecordsToGet, String dgm, String node, String queryIdParam, String isEventLog, String logServerName, String logServerHandleParam, String whereClause)
at WebReach.Historical.MapPegQueryToSQL.Execute(Int32 numRecordsToGet, NameValueCollection args)
at WebReach.Historical.DisplayLogs.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Resolution:
NOTE: The issue is the same as FA209340, however the fix for PME 8.0 will not work in PME 8.1. The hotfix webreach.dll is available to resolve the issue in PME 8.1.
The updated version of webreach.dll is attached along this article which will address this problem in PME 8.1 systems. Please follow the steps below in order to deploy the hotfix.
To deploy:
1. Navigate to [PME root folder]\system\webreach\bin folder and then look for "webreach.dll" file
2. Make a backup copy of existing "webreach.dll" file ** The back up copy of the file cannot simply be renamed. It must be moved to another folder entirely or IIS will still pick it up and load it. **
2. Copy the attached updated "webreach.dll" file into \system\webreach\bin folder.
3. Do an iis reset and clear the browser cache.
