{}

As nossas marcas

Impact-Company-Logo-English Black-01-177x54

Bem-vindo ao website da Schneider Electric

Bem-vindo ao nosso site.
Pesquisar nas perguntas frequentes (FAQ)
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.

Manage Reports

Error


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"

RPT_Subscription

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

EVT_EventWatcherActionSubscription

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

EVT_EventWatcherAction

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.

Schneider Electric Portugal

Explorar mais
Gama:
Artigos que possam ser úteis
Explorar mais
Gama: