Microsoft Dynamics AX (Archived)

Management Reporter 2012 out of sync issue

(0) Share

Report

Posted on by Community Member

Hi all

We've got an R3 CU9 installation with the Management Reporter application.

This seems to sync every 45 seconds to the separate SSAS db.

However, frequently the cubes' data get skewed for some reason (more data in AX than MR database).

Some things i've noticed that cause this:

-Maintenance/release (AOS goes down and MR seems to connect to AOS to get the data)

-Network downtime/issues

-Credential issues

Resetting the datamart (see url below) fixes this. However, it doesnt look like im the only one having this.

Is there an automated way of resetting the datamart (powershell script anyone?)?

Is there a way to prevent these out of sync errors? Newer version perhaps?

Thanks in advance

stoneridgesoftware.com/management-reporter-2012-reset-data-mart-for-dynamics-ax

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

In case it helps. The version we have:

2.12.13002.1 which should be MR2012

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Tim,

What you describe about the maintenance, downtimes, etc. is right. To reduce those issues you can possibly inform all your colleagues who deal with the AOS, network, etc. about this so that they put a special eye on that when they do for example some maintenance jobs.

From your version number I can see that you run MR2012 CU13.

(Please see: blogs.msdn.microsoft.com/.../management-reporter-feature-and-version-number-summary)

I would recommend that you upgrade to CU15 as there is a powershell command available with CU15. How this can be realized is described here: blogs.msdn.microsoft.com/.../resetting-the-management-reporter-data-mart

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

Thanks for the info. managed to upgrade to CU16 and used the powershell script in combination with task scheduler. Works OK.

The script didnt re-enable the integration state automatically though so i tried to use the -KeepIntegrationEnabledState which seems to work at first sight.

After a while i did start to notice that it does not reliably re-enable the integration.. the job runs at 1AM and when i check in the morning, the integration is disabled. Although, when i run the script ad-hoc, the integration gets enabled though.

Any idea?

This is my cmd:

Reset-DatamartIntegration -Reason BADDATA -KeepIntegrationEnabledState -ReasonDetail "Automatic restore" -DatamartDatabaseServer bedcdbs01\AX2012 -DatamartDatabaseName MRDM_ACCEPT -DatamartDatabaseUserName user -DatamartDatabaseUserPassword (ConvertTo-SecureString pass -AsPlainText -Force) -MRDatabaseServer bedcdbs01\AX2012 -MRDatabaseName MR_ACCEPT -MRDatabaseUserName user -MRDatabaseUserPassword (ConvertTo-SecureString pass -AsPlainText -Force) -Confirm -Force -SuppressWarnings

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi all

I was just looking at the code of the DLL of the CmdLet with ILSpy.. and it does seem that it disables and enabled integration. Basically it's executing a very large SQL script. The integration seems to be DB triggers (being maintenance tasks apparantly).

And after running the script the state is indeed enabled.

Could it have something to do with that it still needs to do a full integration?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For future readers out there, i have reverse engineered the code and the -KeepIntegrationEnabledState does:

save current integration state, reset datamart, restore the "current" integration state

Not using this paramater just disables and enables all DB triggers (and thus integrations).

Seems better for my use case.

Was this reply helpful? Yes No