Issue
After manually deleting a source and all its data using a script in SSMS, the source still exist throughout Web Application to be selected, even though it has been deleted from the database.
Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Environment
Web Application - Source selection
Cause
The script provided does not tackle the table that Web Application loads the source list from because is not based on the device name.
Resolution
After deleting a given source and all its data, it is important to rebuild the device metadata in the Application Modules database to reflect the change.
*WARNING: This direct modification of the database is potentially harmful to your system and can result in the system being inoperative and/or loss of data if the below instructions are followed improperly. Always use extreme caution before executing such actions and make sure to backup the databases before you start.
1) Stop all ION Application Modules services
2) Run the script ApplicationModules-DeleteAllDeviceMetadata.sql attached
3) From the command prompt, perform an iisreset (run the cmd as administrator)
4) Restart the services stopped at Step 1
Additional Note:
This script is safe to run as the device metadata will be rebuilt with the service restart. It will also not touch the ION_Data and ION_Network database, therefore there is no risk of data loss.
After manually deleting a source and all its data using a script in SSMS, the source still exist throughout Web Application to be selected, even though it has been deleted from the database.
Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Environment
Web Application - Source selection
Cause
The script provided does not tackle the table that Web Application loads the source list from because is not based on the device name.
Resolution
After deleting a given source and all its data, it is important to rebuild the device metadata in the Application Modules database to reflect the change.
*WARNING: This direct modification of the database is potentially harmful to your system and can result in the system being inoperative and/or loss of data if the below instructions are followed improperly. Always use extreme caution before executing such actions and make sure to backup the databases before you start.
1) Stop all ION Application Modules services
2) Run the script ApplicationModules-DeleteAllDeviceMetadata.sql attached
3) From the command prompt, perform an iisreset (run the cmd as administrator)
4) Restart the services stopped at Step 1
Additional Note:
This script is safe to run as the device metadata will be rebuilt with the service restart. It will also not touch the ION_Data and ION_Network database, therefore there is no risk of data loss.
Released for:Schneider Electric India
