Issue
After upgrading from ION Enterprise 6.0 to Power Monitoring Expert 8.0, no historical data is available in Reports, Dashboards, Diagrams, etc.
Looking in SQL Server Management Studio, the DataLog and DataLogStamp tables are still present in the ION_Data database, which should have been dropped during the upgrade. A row count of the DataLog and DataLog2 tables shows no data in DataLog2.
Product Line
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x, 8.x
Environment
SQL Databases
ION_Data
Cause
This issue is the result of the database upgrade having failed. During the upgrade, the historical data in DataLog and DataLogStamp is converted and loaded into the DataLog2 table. This causes a significant growth in the database.
One possible cause for this task to fail is if autogrowth has been restricted on the ION_Data database
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.*
1) Open SQL management Studio
2) Expand Databases, right click on ION_Data and select properties
3) Under the Files page, click the three dot button under autogrowth and ensure that is is enabled and set for unrestricted growth.
4) Once the autogrowth has been set to unrestricted, re-run the PME 8.0 installer.
Note: Depending on the size of the ION_Data database, this can take several hours to complete the database upgrade.
After upgrading from ION Enterprise 6.0 to Power Monitoring Expert 8.0, no historical data is available in Reports, Dashboards, Diagrams, etc.
Looking in SQL Server Management Studio, the DataLog and DataLogStamp tables are still present in the ION_Data database, which should have been dropped during the upgrade. A row count of the DataLog and DataLog2 tables shows no data in DataLog2.
Product Line
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x, 8.x
Environment
SQL Databases
ION_Data
Cause
This issue is the result of the database upgrade having failed. During the upgrade, the historical data in DataLog and DataLogStamp is converted and loaded into the DataLog2 table. This causes a significant growth in the database.
One possible cause for this task to fail is if autogrowth has been restricted on the ION_Data database
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.*
1) Open SQL management Studio
2) Expand Databases, right click on ION_Data and select properties
3) Under the Files page, click the three dot button under autogrowth and ensure that is is enabled and set for unrestricted growth.
4) Once the autogrowth has been set to unrestricted, re-run the PME 8.0 installer.
Note: Depending on the size of the ION_Data database, this can take several hours to complete the database upgrade.