Technical FAQs

Ask a Question

Web Applications Log In fails with an error message in SPM/PME

Issue
When logging into the Web Applications the user provides a known correct User name and Password however the login is unsuccessful.

SPM 7.0.x Login Screen with error message "Log on unsuccessful":



PME 7.2.x Login Screen with error message "The user name or password you entered is invalid. Please check and try again.":


 
PME 8.x Login Screen with error message "The user name or password you entered is invalid. Please check and try again.":



Product Line
StruxureWare Power Monitoring 7.0.x (SPM 7.0.x)
Power Monitoring Expert 7.2.x (PME 7.2.x)
Power Monitoring Expert 8.x (PME 8.x)
 
Environment
Web Applications Login
 
Cause
There are several possible causes for the Web Applications failed login attempt. Below are some common causes of the login failure.

The SQL Ionedsd user account does not have the correct permissions.

OR

The WebRealTime.svc may be unable to start due to lack of memory.

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

Resolution 1:
Make sure that the browser version is supported in the PME version that is installed. Check supported browser version in FA211703

Resolution 2:
For the ionedsd user, add the NOM_DSD_Reader role for ION_Network and the ION_DSD_Reader role for ION_Data by opening SQL server Management studio and going to properties on the ionedsd account.




Resolution 3:
Navigate to: http://localhost/Webservices/WebRealTime.svc and verify that there are no errors loading the page. If error contains a message that the service is unable to start due to lack of memory, open the Task Manager and identify the processes that are using high amounts of memory. Identify if there are programs that can be stopped to free up memory. Verify that SQL's memory is limited by following FA213995.

Resolution 4:
Within the ApplicationModules database Views, make sure that the "Configuration.ConfigurationSettings" keys point to the correct locations as shown below in red. The server should be set to the database server for distributed system and the local machine for standalone configurations:

Key - IonDataConnectionString
Value - server=localserver\ION;database=ION_Data;uid=ionedsd;pwd=exw1BStLAmzokMLd4uiXLouELuCl037YUD;MultipleActiveResultSets=True

Key - IonNetworkConnectionString
Value - server=localserver\ION;database=ION_Network;uid=ionedsd;pwd=exw1BStLAmzokMLd4uiXLouELuCl037YUD;MultipleActiveResultSets=True

Resolution 5:
Grant permissions to Connect SQL. To do this, navigate to Microsoft SQL Management Studio. Then go to the security folder. When the security folder is expanded, right click on ionedsd and select the ionedsd properties. When the ionedsd properties pop up window is available select the securables page. From here scroll down under the explicit tab until you find Connect to SQL. Check the box under Grant. Select OK. 



Resolution 6:
The value in the [Signature] field within the [DataSourceBus].[DataSource] table found in the ApplicationModules database needs to be copied to the following file:
C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Applications\bin​\DataServicesHost.config



*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).

The setting within the DataServicesHost.config file as shown below from a test PME system must match the value found in the database.  If it doesn't, you can manually edit DataServicesHost.config to match the signature field value in the database.

<?xml version="1.0"?>
<configuration>
  <appSettings>
    <add key="ServiceHostId" value=""/>
    <add key="Role" value="DataBus,IonEnterpriseDataSourceDriver,Hierarchy"/>
    <add key="DataSourceDriverInstance" value="ION Enterprise-Default" />
    <add key="DataSourceSignature" value="2e7666ed-c948-46ad-9994-6cd9623c276f"/>
  </appSettings>
</configuration>
 
Resolution 7:
If the system requires a fully qualified domain name (ie http://pme.schneider-electric.com/web) to access the webpage, then the following database entries may need to be updated to allow for javascript to be loaded to the webpage and encode the user's password: ApplicationModules > Views > Configuration.ConfigurationSettings and ION_Network > Views > dbo.vCFG_ConfigItems.

To update the aforementioned database entries, perform the following:
  1. Login into SQL Server Management Stuido
  2. Navigate to ApplicationModules > Views
  3. Right-click on Configuration.ConfigurationSettings and select Edit Top 200 Rows
  4. Locate the entry where
    • ItemType = WebFramework
    • Item = Server
    • Key = LocalServerAddress
  5. Update this entry to reflect the fully qualified domain name.
For example, update the entry to be something like http://pme.schneider-electric.com/web.
  1. Navigate to ION_Network > Views
  2. Right-click on dbo.vCFG_ConfigItems and select Edit Top 200 Rows
  3. Locate the entry where
    • Module = Reporting
    • Category = General Settings
    • Item = WebServiceURL
  4. Update this entry to reflect the fully qualified domain name.
For example, update the entry to be something like http://pme.schneider-electric.com/ionreportdataservice/ReportDataService.asmx.
  1. Perform an IISReset and restart the ApplicationModules services
Was this helpful?
What can we do to improve the information ?