How to Manually Delete Report Subscriptions during an ION Enterprise 6.0.1 to PME 7.2.x or PME 8.x Upgrade

Issue:
When performing a side by side upgrade from ION Enterprise 6.0.1 to Power Monitoring Expert 7.2.x or Power Monitoring Expert 8.x a user may choose to not carry over the existing report subscriptions.

After the upgrade the old report subscriptions will still show up when managing reports and will produce the following error if you attempt to modify them.






Product Line:
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x

Environment:
Web Applications Report Subscriptions

Cause:
The SQL Agent Jobs for the report subscriptions no longer exist but there are still database entries associated with the report subscriptions.


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.*

You will need to remove the references to the old report subscriptions from the ION_Network database.

Create a backup of the ION_Network database before proceeding

Within the ION_Network database you will find references to the old report subscriptions in the following tables

RPT_Subscription
EVT_EventWatcherActionSubscription
EVT_EventWatcherAction

The RPT_Subscription table contains a reference to each report subscription and the associated "SubscriptionID"



The EVT_EventWatcherActionSubscription table contains the association between the "SubscriptionID" and the "EventWatcherActionID"



The EVT_EventWatcherAction table contains the association between the "EventWatcherActionID" and the "EventWatcherID"



In order to fully remove the old report subscriptions you will need to delete the references from the three tables listed above.

In the example above one would need to run the following queries in SQL against the ION_Network database.

Use ION_Network
Delete from RPT_Subscription where SubscriptionID IN(1)
Delete from EVT_EventWatcherActionSubscription where SubscriptionID IN(1)
Delete from EVT_EventWatcherAction where EventWatcherActionID IN(1)

Be sure to only delete entries associated with the old report subscriptions you wish to remove.

Released for:Schneider Electric South Africa