Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the 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
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
A meter was installed into the StruxureWare Power Monitoring (SPM) or Power Monitoring Expert (PME) system and has been logging data, waveforms, and events for any length of time. For whatever the reason, this meter's data is no longer required and it is desired that all traces of this meter be completely removed from the databases.
StruxureWare Power Monitoring 7.0.x (SPM)
Power Monitoring Expert 7.2.x (PME)
Power Monitoring Expert 8.x (PME)
SQL Server Management Studio
A meter was added to the software but is no longer needed. Some reasons may include: data is no longer needed; spelling error; test meter data deletion; etc.
*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. Back up the following databases: ION_Network, ION_Data, ApplicationModules.
2. Stop the ION Log Inserter service. It will also be necessary to stop the Windows services related to the Application Modules features. In SPM 7.0.x, these services start with the name "Schneider Electric"; in PME 7.2.x and PME 8, these services were re-branded and start with "ApplicationModules".
3. Open the Management Console and locate the device in the list. Take note of the full group.name of the device as this information will be needed later to configure a SQL script. NOTE: It is entirely possible the device is not in the Management Console. If this is the case, it is likely the full group.name is already known.
4. Delete the device from the Management Console. If the following prompt appears, select Cancel and then proceed to Step 5:
4a. If PME 8.0, be sure to delete this source from any configured sw alarms, Comms Loss or otherwise. If you do not do this, the Alarming system will recreate the source.
5. If there are logical devices associated with the device to be deleted, the logical devices must first be removed. Take note of each group.name of the logical devices as these will be needed later to configure a SQL script. Once each of the logical devices has been deleted from the Management Console, repeat Step 4 with the original device.
6. Once all devices have been documented by group.name and deleted from the Management Console, the following SQL scripts must be configured to delete each device individually.
For SPM 7.0.x and PME 7.2.x, use SQL Script "SPM7_delete_device_v3.sql"
For PME 8, use SQL Script "PME8_delete_device_v3.sql"
6a. Toward the top of the attached script, there is a code segment that looks like this:
-- will need to put in group and name for device to be deleted - in this example device name is 'test.8600'
SET @oldGroupName = 'test'
SET @oldDeviceName = '8600'
6b. Replace 'test' with the group documented earlier. Be sure to leave the single quote characters.
6c. Replace '8600' with the name documented earlier. Be sure to leave the single quote characters.
7. Save and then execute the SQL script. NOTE: There may be additional cleanup required if the VIP was used to log data from the deleted device. Links to the VIP modules that reference the deleted device will have to be removed manually using Designer. If this is not done, the System Log in the Management Console will being throwing errors.
8. Restart the four services stopped at the beginning of this procedure.
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!