ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Tridea Partners - A Columbus Company

How to Clear the Management Reporter Report Queue


    Email | Print

    Do you know how to clear the management reporter report queue?

    When the Management Reporter (MR) – Report Queue gets full you will periodically need to clear the queue.

     

    Although within MR you have the ability to review the Queue Status: [Tools >> Report Queue Status]

     

    It does not give you the access to clear or reset the Queue.

     

    To clear the Queue, you will need to log into the SQL Management Studio with administrative privileges.

    1. Open a New Query
    2. Point to the ManagementReporter database
    3. Then in the New Query section type the following query

     

    USE ManagementReporter

     

    DELETE REPOSITORY WHERE StatusType<> ‘0’

    1. Exit SQL Management Studio

     

    Log back into MR and check the Report Queue Status [Tools >> Report Queue Status]

     

    The screen should be clear of all data.

     

    This article was written by Dean Anderson, consultant at Tridea Partners. Tridea Partners is a leading Microsoft Dynamics partner.

    Ask This Expert a Question / Leave a Comment

     

     
     
    Show Buttons
    Hide Buttons