{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
PME 8.0 - No Historical Data After Upgrade From ION Enterprise 6.0
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.

Object Explorer
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.
Database properties
Autogrowth

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.

Schneider Electric Canada

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.