Discover our Clipsal Smart Home packages as seen on the Block

in location


I'm looking for

  • Wholesalers
    • Uncheck All Check All
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

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

    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

    SQL Server management studio

    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 :


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

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance