Issue

Under certain circumstances during the upgrade from ION Enterprise 6.0 SP1 → StruxureWare Power Monitoring 7.0, the obsolete database tables DataLog and DataLogStamp are not removed after all data has been migrated to the new DataLog2 table.

This results in:

• A database that is larger than necessary
• Possible confusion for the end user

No errors are generated by the installer, and the user has no indication that the obsolete tables remain.There is no data loss.

Environment

StruxureWare Power Monitoring 7.0

Upgrade scenario from ION Enterprise 6.0 SP1

Microsoft SQL Server

SQL Server Management Studio (SSMS)

Cause

This issue occurs if data was previously deleted incorrectly from the database using direct manipulation in SSMS.

Because there is no foreign key constraint between DataLog and DataLogStamp, it is possible to delete records from DataLogStamp while leaving orphaned records in DataLog that reference the deleted entries.

When the upgrade procedure checks for complete data migration, this orphaned data causes the validation to fail, and the old tables are not removed.

Resolution

To resolve this issue, manually delete the obsolete tables using SQL Server Management Studio or SQL commands.

⚠ Important: Back up your database before making any manual changes.

Option 1: Delete Tables Using SSMS GUI

1. Open SQL Server Management Studio and connect to the PME database instance.
2. Expand Databases → ION_Data → Tables.
3. Locate dbo.DataLog and dbo.DataLogStamp.
4. Right-click each table and select Delete.
   (See screenshot below for reference.)

Option 2: Delete Tables Using SQL Commands

Run the following commands in a new query window:

DROP TABLE DataLog;

DROP TABLE DataLogStamp;