Issue
The Power Monitoring Expert installer times out on the 'Load Application Resources' step which results in a failed installation.
If you choose to continue, the configuration will be flagged as 'Unsuccessful'
Product Line
Power Monitoring Expert (PME) 7.2, 8.x
Environment
Power Monitoring Expert Installation (Standalone/Distributed) or Upgrade
Cause
One of the steps during the Configuration phase of the PME 8.1 Installation is called 'Load Application Resources'. During this phase, a .sql file called 'ResourceDbLoad.sql' is run to add translated strings to the ApplicationModules database. The installer is trying to load all of the localized strings for Web Applications when the timeout is occurring. The installer is attempting to insert records into the [Internationalization].[LocalizedString] table in the ApplicationModules database during the step that's failing.
The Installer imposes a timeout on this step, and if it takes longer than 15 minutes cause it to fail. At this point, the installer will prompt to proceed.
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.
Executing the query that is associated with the 'Load Application Resources' step from SQL Server Management Studio will bypasses the timeout imposed by the PME installer.
This may be achieved by completing the following steps:
1. Browse to the 'ResourcesDbLoad.sql' file which is located in the PME installation directory. The default location for the PME installation directory is 'C:\Program Files (x86)\Schneider Electric\Power Monitoring Expert\Applications\Resources\ResourceSQL'
2. Open 'ResourcesDbLoad.sql' file in notepad and copy the entire contents of the file.
3. Open up and log into SQL Server Management Studio, expand databases, right click on 'ApplicationModules', select new query.
4. Paste the contents of the 'ResourcesDbLoad.sql' file into the new query window and ensure the ApplicationModules database is selected in the drop down menu.
5. Execute the query. Once the query has completed successfully there is no need for the installer to run the 'Load Application Resources' step again during the Configuration so we will remove this from the installation files.
6. Copy the file contents of the installation disc to a new folder on the server desktop.
7. Create a back up copy on the desktop of the "AppMods.Resx.Broker.xml" file within the setup < BrokerFragments folder on the installation disc.
8. Open the original "AppMods.Resx.Broker.xml" within the \Setup\BrokerFragments\AppModsResx.broker.xml folder, comment the section in bold below, and save the file. When the "Configure" option is run from the disc this will cause it to skip the 'Load Application Resources' step. It may be necessary to restart the server before re-running the installer in the "Configure" mode.
To comment the section below, make the following changes indicated in RED below:
<!-- <InstallResources Library="Internationalization" Class="Installer.InstallTools.Internationalization.ResxDbConfig">
<resourceDirectory>@globalProgramFileFolder/@\Applications\Resources</resourceDirectory >
<connectionString>@globalConnectionString</connectionString>
<database>ApplicationModules</database>
<sqlOutputFileName>@globalProgramFileFolder/@\Applications\Resources\ResourceSQL\ResourceDbLoad.sql</sqlOutputFileName>
<outputToDatabase>true</outputToDatabase>
<outputToSqlFile>true</outputToSqlFile>
</InstallResources> -->
9. Once the Configure completes successfully open each section of PME to verify functionality.
