Browse FAQs

PME upgrade times out at 'Create Database' step, fails at 'Verify Databases' step

Published date: 14 June 2020

Issue
When upgrading to PME from an earlier version, the 'Create Database' step times out, causing the 'Verify Databases' step to fail.



Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020

Environment
Software Upgrade

Cause
The default timeout for the 'Create Database' step is 20 minutes for PME 9.0 and 30 minutes for PME 2020. If the databases are large, it can sometimes take longer than 30 minutes to finish upgrading the databases, resulting in this step timing out. Since the database upgrade doesn't complete, the installer does not pass the 'Verify Databases' step.

Resolution
*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).
  1. Click Exit and close out of the installer
  2. The installation media cannot normally be edited, so either copy the install disc to the hard drive or download and extract the PME installer .iso using a .iso file extractor (e.g. 7-Zip)
  3. Navigate to setup\ BrokerFragments
  4. Right-click > Edit the Database.Core.broker.xml file
Note: The example below using the values from PME 9.0. The timeout is 1800000 ms for PME 2020.

If Windows Authentication was used during Database Software step:
  1. Locate the following line, where the current 'TimeOut' is set to 1200000 ms, or 20 minutes: 
<Request Name="CreateIONDatabasesWindowsAuth" EstTime="500" TimeOut="1200000" UIName="#CreateDatabase" ActionOnFail="Stop">
  1. Change the 'TimeOut' parameter to 12000000 ms, or 200 minutes: 
<Request Name="CreateIONDatabasesWindowsAuth" EstTime="500" TimeOut="12000000" UIName="#CreateDatabase" ActionOnFail="Stop">
 
  1. Save the Database.Core.broker.xml file
  2. Navigate back to the root directory of the extracted installation media, then right-click MainSetup.exe > Run as Administrator to re-run the installer with the new timeout setting
If SQL Authentication was used during Database Software step:
  1. Locate the following line, where the current 'TimeOut' is set to 1200000 ms, or 20 minutes: 
<Request Name="CreateIONDatabasesSqlAuth" EstTime="500" TimeOut="1200000" UIName="#CreateDatabase" ActionOnFail="Stop">
  1. Change the 'TimeOut' parameter to 12000000 ms, or 200 minutes: 
<Request Name="CreateIONDatabasesSqlAuth" EstTime="500" TimeOut="12000000" UIName="#CreateDatabase" ActionOnFail="Stop">
 
  1. Save the Database.Core.broker.xml file
  2. Navigate back to the root directory of the extracted installation media, then right-click MainSetup.exe > Run as Administrator to re-run the installer with the new timeout setting

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.