{"searchBar":{"inputPlaceholder":"Search by keyword or ask a question","searchBtn":"Search","error":"Please enter a keyword to search"}}
{}

Welcome to the Schneider Electric Website

Welcome to our website.

Select your location

Welcome the the Schneider Electric French website. It looks like you are located in the United States, would you like to change your location?

Traduisez en francais
{"support":{"yesButton":"Yes","noButton":"No","feedback":{"title":"What can we do to improve?"},"submitButton":"Submit","successMessage":"Thank you for your feedback","title":"Was this helpful?","feedbackPercentLabel":"of people found this helpful","captcha":{"error":"Please tick the box"}}}
Search FAQs

Why is diagnostic tool failing and showing 'login failed for AMUser' on most steps?

Issue
When running the diagnostic tool in PME, it fails on almost every step and does't generate system report. When looking at the log for the diagnostic tool it shows "login failed for 'AMUser'". The diagnostic tool log can be found under this path: C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Diagnostics Tool\Logs. Below is an example of what the diagnostic tool log would look like. 

[11/1/2016 5:32:18 PM] Executing command: Web Application Module Diagnostics
[11/1/2016 5:32:18 PM] Error while: Web Application Module Diagnostics
[11/1/2016 5:32:18 PM] Exception message: Login failed for user 'AMUser'.
[11/1/2016 5:32:18 PM] Stack Trace:    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at DiagnosticsTool.Utilities.Technologies.SQLBase.ExecuteQuery(String query, String databaseName)
   at DiagnosticsTool.Base.SqlQueryCommand.Execute()
   at DiagnosticsTool.DiagnosticsManager.ExecuteCommand(Object command)


Product Line
PME 8.x
PME 9.0
PME 2020

Environment 
Diagnostic logs

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.*

To correct this problem, first make sure that AMUser is created as a login in SQL server and correctly associated with the ApplicationModules database. The AMUser login should be associated with the AMUser user for the ApplicationModules database, and be part of the AMApplicationRole and public roles. This can be checked by right clicking on the AMUser and going to properties --> User Mapping. 

If the association is correct, was the AMUser password changed after the installation? If so, to fix this problem, please either reset the AMUser password to what it was at the installation time, or update the appropriate configuration files with the new password. The password for AMUser is stored in quite a few configuration files within the PME installation:
  • ...\Applications\bin\Framework.ServiceHost.exe.config
  • ...\Applications\AlarmConfiguration\Web.config
  • ...\Applications\ApplicationFramework\Web.config
  • ...\Applications\Dashboards\Web.config
  • ...\Applications\HierarchyManager\Web.config
  • ...\Applications\RateEditor\Web.config
  • ...\Applications\Slideshow\Web.config
  • ...\Applications\SystemDataService\Web.config
  • ...\Applications\Trends\Web.config
  • ...\Applications\TrendsWebServices\Web.config
  • ...\system\ReportDataService\Web.config
The password that was created at installation time will be in those files - please copy/paste it into SQL server to chagne the password back. This can be done by right clicking on the AMUser and going to properties --> General. 

If the association is not correct, then please run the query below to restore the AMUser to the default roles it was created with. 

Use ApplicationModules
EXEC sp_change_users_login 'auto_fix', 'AMUser'