{}

Our Brands

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

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
How to Identify Orphan Report Subscriptions
Issue
Orphaned report subscriptions are generating  "unable to render report" error messages within the EEM system log.
These are being reported from the ION EEM Subscription Monitor service.

Product
ION EEM

Environment
ION EEM 3.95 SP1
ION EEM 4.0, 4.0 R2
ION EEM 5.0

Cause
A report subscription attempting to run a report which no longer exists.

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

Execute the following query to determine if a configured report subscription is missing the report that it is intended to run.
If the ReportID in RPT_Report Table column contains NULL, then it is an orphaned report subscription.

   USE ION_EEMData  
 
SELECT rs.SubscriptionId AS [SubscriptionID in RPT_Subscriptions Table]  
         ,rs.ReportID AS [ReportID in RPT_Subscriptions Table]  
         ,r.ReportID AS [ReportID in RPT_Report Table]  
         ,r.DisplayName AS [Report Display Name in RPT_Report Table]  
    FROM RPT_Subscriptions rs  
    LEFT JOIN RPT_Report r ON rs.ReportID = r.ReportID  
    ORDER BY r.ReportID 


To remove the orphaned subscription record(s) from the RPT_Subscriptions table, execute the following query,
replacing x with the rs.SubscriptionId of the identified orphaned subscription in the preceding query:

   USE ION_EEMData  
 
DELETE FROM RPT_Subscriptions rs
     WHERE rs.SubscriptionId = x


** see attachment containing the SQL script text

Schneider Electric Canada

Attachment(s)
DELETE Model.pdf [49.06 KB]
Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: