Technical FAQs

Ask a Question

PME 8.1 - Custom Date Range in Diagram Queries Result in Error

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 Appliaction 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:
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
2. Copy the attached updated "webreach.dll" file into \system\webreach\bin folder.
3. Do an iis reset and clear the browser cache.

This should resolve the issue. 

NOTE: The issue is the same as FA209340, however the fix for PME 8.0 will not work in PME 8.1.
Was this helpful?
What can we do to improve the information ?