Issue

The following error is shown after navigating to the PME web application's reports tab "Server Error in '/reporter' Application."

"Runtime Error - Description: An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated."

Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
PME Web Applications
IIS Manager (inetmgr)
SQL Server Management Studio (SSMS)

Cause
The PME databases contain configuration information for the web application. There is an entry that specifies the URL for the PME reports tab that was edited, and this could have been due to manual error, a PME reconfiguration, or PME upgrade.

Resolution

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio (SSMS). Databases should be backed up prior to performing this procedure.*

1. Using SQL Server Management Studio (SSMS), run the below query to identify what the reports URL is specified as. (To run the query, select "new query", paste the below text, and press "execute").

   SELECT *
   
   FROM [ION_Network].[dbo].[vCFG_ConfigItems]
   
    WHERE Module='Reporting'
   
   AND Category='General Settings'
   
   AND Item = 'WebServiceUrl'

2. In the results window, observe in the "value" column that the correct URL is displayed. The correct value is https://mysampledomain.com/ionreportdataservice/ReportDataService.asmx. The most likely cause of this error is that the url is missing the text following .com/.
   The correct URL can be preceded with either http or https depending on how your PME is configured. The "sample domain" will be either the PME server's name, or it can be the Fully Qualified Domain Name (FQDM), which also depends on how your PME is configured.
   Overall, The URL that the PME web app is typically accessed at (unless it is 'localhost' -- do not use localhost here -- use the servername) is what should be in the "mysampledomain".
3. If the URL is incorrect, run the below update query but replace the "mysampledomain" with the URL you use to typically access PME:

   SELECT *
     FROM [ION_Network].[dbo].[vCFG_ConfigItems]
     UPDATE [ION_Network].[dbo].[vCFG_ConfigItems]
     SET Value='https://mysampledomain.com/ionreportdataservice/ReportDataService.asmx'
     WHERE Module='Reporting'
   AND Category='General Settings'
   AND Item = 'WebServiceUrl'

4. Refresh the web browser.
5. If no change is observed, you may need to refresh the "ION Application Modules Core Services Host" and refresh the web browser again.
6. If no change is observed, further investigation is needed. The "system log" in the web application's "settings" tab may have error messages related to the issue.

Note: Do not use this article for PME v2024. Instead use this process for configuring PME for server certificate, specifically developed for PME v2024, here: PME Installer - Configuring FQDN

發佈於: 施耐德電機Taiwan