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.
When attempting to modify an existing Report Subscription in the StruxureWare Power Monitoring Web client, the Subscription does not show under the list for the particular report. The Subscription still works but we are unable to view or configure it.
StruxureWare Power Monitoring 7.0.x
SPM Web Application
If the Report Subscription was created by a user account that has since been removed from the User Manager the Subscription will continue to run, however it will no longer show in the Web client and therefore be un-editable.
Every Report Subscription in the dbo.RPT_Subscription table, is tagged with an Owner ID. This Owner ID corresponds to the UserID from the dbo.Users table, and indicates which user created the Subscription. The stored procedure that retrieves the Subscription list for the Web client, also queries the dbo.Users table in order to retrieve the actual Username of the subscription owner. Since the user account no longer exists in the dbo.Users table, the stored procedure returns no subscriptions even though the subscription clearly exists in the dbo.RPT_Subscription table.
*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. Open SQL Server Management Studio
2. Expand out the ION_Network database and then expand Tables.
3. There should be a table named "dbo.Owners". Right-click on the table and select "Edit Top 200 Rows"
5. Find a valid UserID and copy it to be pasted later.
6. Next go to the table "dbo.RPT_Subscriptions" and right-click on that table and select "Edit Top 200 Rows"
7. Paste the previously copied UserID into the Owner column for the report subscription that was previously missing.