The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as Facility Hero) app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
Under some circumstances, during the ION_Data database upgrade that takes place during the software upgrade ION Enterprise 6.0 SP1 -> StruxureWare Power Monitoring, the obsoleted database tables, DataLog and DataLogStamp, are not removed after all data has been transferred to the new DataLog2 table. This results in a database that potentially will be much larger than necessary, and possible some 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, however.
Causes and Fixes
This can happen if data has been deleted incorrectly from the database via direct manipulation using SQL Server Management Studio. Because there is no foreign key constraint between DataLog and DataLogStamp, it is possible to delete a range of records from DataLogStamp leaving behind any records in DataLog that reference the deleted records. The proper way to delete data from DataLog and DataLogStamp is to delete from DataLog first, followed by DataLogStamp. Because of these orphaned records, when the upgrade procedure does its check to make sure all data has been migrated, the check will fail, and the old tables will not be deleted.
To resolve this problem, simply use Management Studio to manually drop the tables. This can be done by right clicking on the table to be deleted, and choosing delete:
or alternatively, issuing a DROP Table DataLog, followed by a DROP Table DataLogStamp command in the query window. It would be wise to back up your database prior to making these manual modifications in case a mistake is made.
Document Change History
|Date and Initials||Comments|
|2012-May-22 DRM||* Altered distribution level to public.|
Last Revised: April 2, 2012
All content © 1992-2012 Schneider Electric
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!