Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Management Reporter Data out of sync due to DB-server crash

Posted on by 2,721

Hi

we had this week the issue that our db server crashed (due to some problems with log files). At this moment a financial transaction was booked in AX2012 R2. The booking AX 2012 R2 was fully closed and consistent, but the data did not come to Mgmt reporter. 

As we didn't find any "force fully sync" we did rebuild the datamart. Looks fine now. 

Here comes my question:

Is there any way to see if datamart is out of sync with AX? 

Log fil? Sql script?

or is there any way to do a "full datamart sync" with out rebuild the datamart?

Need to convince finance team that their loved tool mgmt reporter is trust full ..

thanks

Pirmin

Categories:
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,663 Super User on at
    RE: Management Reporter Data out of sync due to DB-server crash

    Hi Pirmin,

    There is no full rebuild option other than recreating the datamart. I'm not familiar with the MR datamodel to answer the part of your question about consistency. I think it would be possible to create some SQL scripts, but would be quite difficult to create. You could also compare e.g. a trial balance report from AX and MR.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans