Browse FAQs

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

Published date: 27 September 2019

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



Product Line
Power Monitoring Expert 9.0

Environment
Software Upgrade

Cause
The default timeout for the 'Create Database' step is 20 minutes. If the databases are large, it can sometimes take longer than 20 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_9.0.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
5. 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">
6. Change the 'TimeOut' parameter to 12000000 ms, or 200 minutes: 
<Request Name="CreateIONDatabasesWindowsAuth" EstTime="500" TimeOut="12000000" UIName="#CreateDatabase" ActionOnFail="Stop">



7. Save the Database.Core.broker.xml file
8. Navigate back to the root directory of the 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.