Open Forum

 View Only
Expand all | Collapse all

Error on data mart rebuild for Management Reporter

  • 1.  Error on data mart rebuild for Management Reporter

    Posted Oct 30, 2021 11:42 AM
    #Technical #BIandReporting
    I am trying to rebuild the data mart in Management Reporter and bumped into the message in the screen shot.  The database this refers to has been deleted and does not appear in the database list in SSMS.  
    Thanks in advance!
    Shelagh
    ​​

    ------------------------------
    Shelagh Esteb
    NA
    Stafford TX
    ------------------------------


  • 2.  RE: Error on data mart rebuild for Management Reporter

    TOP CONTRIBUTOR
    Posted Nov 01, 2021 11:49 AM
    Edited by Sean Reynolds Nov 01, 2021 11:49 AM
    Hi Shelah - 

    Were you able to get this resolved? 

    ------------------------------
    Sean Reynolds
    Accounting IT Manager & MS Dynamics GP System Administrator
    MIC Global Services
    Plano TX
    ------------------------------



  • 3.  RE: Error on data mart rebuild for Management Reporter

    Posted Nov 01, 2021 11:58 AM
    No I haven't.  Any suggestions? 

    S

    ------------------------------
    Shelagh Esteb
    NA
    Stafford TX
    ------------------------------



  • 4.  RE: Error on data mart rebuild for Management Reporter

    TOP CONTRIBUTOR
    Posted Nov 01, 2021 12:17 PM
    I apologize for asking these, but it's just my troubleshooting mind at work:

    • Is your Management Reporter databases on the same SQL server as your GP database or a separate server?
    • Have you refreshed your SQL instance just to make sure the DM was deleted? 
    • Did you stop/start the services after deleting the DM? 


    ------------------------------
    Sean Reynolds
    Accounting IT Manager & MS Dynamics GP System Administrator
    MIC Global Services
    Plano TX
    ------------------------------



  • 5.  RE: Error on data mart rebuild for Management Reporter

    Posted Nov 01, 2021 12:27 PM