Technical FAQs

Ask a Question

How can I check the report subscription queue in PME 7.2/PME 8

Issue
The user would like to check the report subscription queue in order to identify any backed up reports.

Product line
PME 7.2.2, PME8, PME 8.1

Environment
SQL Server management studio

Cause
The RPT_SubscriptionEvent table within the ION_Nework contains a list of report subscriptions that will be dealt with by the Report Subscription Services. Entries should get deleted from the table as soon as they've been processed. If there are multiple rows in this table at one time, it might indicate a backup in servicing subscriptions. If you restart the system and there are records in that table, the Report Subscription Service will start running them all until they're all finished; which might be an undesirable outcome. The report scheduler is responsible for inserting the report subscriptions in the table mentioned earlier. PME uses 2 different type of schedulers depending on the sql server edition installed.  If using SQL Server Standard Edition, Report subscriptions are scheduled by SQL Server Agent jobs and it would be worthwhile checking the sql server event log to troubleshoot report subscriptions. If SQL server express edition is installed, PME's report subscription utilizes the Report subscription's internal scheduler. Below is a screenshot of a report subscription in the subscription queue :

Resolution 

To view the table:

1- Launch SQL Server management studio and connect to PME's database instance. You can either use windows authentication or sql server authentication to login 
2- Click on new query and then write the following query:
Use ION_Network
Select * from RPT_SubscriptionEvent 

3- Execute the query above by clicking on the execute button
4- the table below is screenshot of a report subscription in the subscription queue.


To view the current SQL Jobs and related error logs:

1- In SQL Server Management studio's Object Explorer, click the plus sign to expand SQL Server Agent.
2- To view current Job activities, click the plus sign to expand jobs and then click on Job activity Monitor.
3- To view SQL Server agent error logs, expand the error logs and click on one of the logs as shown below:
 
The SQL Server Agent jobs log can also be found in the windows application event log ( can be accessed from the event viewer).
Was this helpful?
What can we do to improve the information ?