AX 2012R3 Management Reporter Datamart Reset

(0) Share

Report

Posted on by Community Member

Hello,

I tried to reset data mart on an AX 2012 R3 cluster following the instructions on this page:

- http://www.everythingdynamicsaxbi.com/2016/02/01/management-reporter-rebuilding-your-data-mart/

The problem is that after removing the old DM database and at configuring the Management Reporter (step 10) I am getting the following errors:

- An unexpected error occurred while querying the Metadata service. Check that all credentials are correct. See the deployment log for details.

- You have tried to create a channel to a service that does not support .Net Framing. It is possible that you are encountering an HTTP endpoint.

The first error (credentials) is strange, because the accounts I use are SQL sysadmin. Maybe it is caused by the second error.

Any idea about the second error, .Net Framing? How can I pass this?

And finally, is there more detailed documentation or an alternative (easier/safer) procedure for AX data mart reset?

I really need to Reset Data Mart for Dynamics AX, and I am currently left without the original data mart database either.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Yiannis,

What is the MR version that you operate?

(You can check that here: docs.microsoft.com/.../management-reporter-feature-and-version-number-summary)

If you operate a very old MR version then I would recommend considering upgrading to the latest possible one or having a look at LCS to ensure that this is not caused by a bug.

Some more recent posts on how to reset the datamart can be found here:

community.dynamics.com/.../management-reporter-rebuilding-your-data-mart

stoneridgesoftware.com/.../

If nothing of that helps, I would recommend that you open a support call with MS to get this fixed quickly.

Best regards,

Ludwig

Was this reply helpful? Yes No
Andre Ghazaleh 870 on at

Like (0)

Report

Hi Yiannis,

1)When entering the database server, Try to use "Servername" instead of "Servername\SqlInstanceName"

2)Make sure that you are using the right AOS services port

Best regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I think I am using all correct parameters, and I run the MR Configuration Console from the Reporting VM.

Here is the Deployment log I am getting.

Any clue out of them?

10/4/2020 9:22:23 PM - The user 'DOMAIN\axadmin' already exists on the server 'AX2012-DB'.

Machine: AX2012-REPORT

10/4/2020 9:22:23 PM - Checking whether database AX2012LIVE exists

Machine: AX2012-REPORT

10/4/2020 9:22:23 PM - Checking if the user is SA.

Machine: AX2012-REPORT

10/4/2020 9:22:23 PM - Adding 'db_datareader' permissions to 'DOMAIN\axadmin' for 'AX2012LIVE' database.

Machine: AX2012-REPORT

10/4/2020 9:22:23 PM - Checking if the 'AX2012LIVE' database exists.

Machine: AX2012-REPORT

10/4/2020 9:22:23 PM - Checking if the user 'DOMAIN\axadmin' has 'db_datareader' permissions.

Machine: AX2012-REPORT

10/4/2020 9:22:23 PM - User 'DOMAIN\axadmin' has permissions: 'False'

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - The login 'DOMAIN\axadmin' already has an account.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - The login 'DOMAIN\axadmin' was created and granted 'db_datareader' permissions: 'True'

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Checking whether database AX2012LIVE_model exists

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Checking if the user is SA.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Adding 'db_datareader' permissions to 'DOMAIN\axadmin' for 'AX2012LIVE_model' database.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Checking if the 'AX2012LIVE_model' database exists.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Checking if the user 'DOMAIN\axadmin' has 'db_datareader' permissions.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - User 'DOMAIN\axadmin' has permissions: 'False'

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - The login 'DOMAIN\axadmin' already has an account.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - The login 'DOMAIN\axadmin' was created and granted 'db_datareader' permissions: 'True'

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Verifying provided credentials for change tracking...

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Credentials for user were successfully verified.

Machine: AX2012-REPORT

10/4/2020 9:22:24 PM - Querying metadata service for table names.

Machine: AX2012-REPORT

Received the following exception when contacting the AX Metadata Service possibly due to expired token. Attempted to retry the operation 10 times with no success. You have tried to create a channel to a service that does not support .Net Framing. It is possible that you are encountering an HTTP endpoint.

Machine: AX2012-REPORT

System service communication error The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.

Machine: AX2012-REPORT

10/4/2020 9:24:48 PM - An unexpected error occurred while querying the Metadata service. Check that all credentials are correct. See the deployment log for details. An unexpected error occurred while querying the Metadata service. Check that all credentials are correct. See the deployment log for details.

Machine: AX2012-REPORT

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Yannis,

Can you try to "Refresh configuration" from AX 2012 client configuration (on the system you are trying to install MR)? Please check if that completes without errors.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

The solution was to not use the AOS Wsdl Port (8101) but the AOS Services Endpoint Port (8201) documented here.

This port is not shown anywhere in the configuration utilities but in Ax32Serv.exe.config AOS configuration file, and should not change after setup (according to documentation).

<?xml version="1.0" encoding="utf-8"?>
<configuration>
      <appSettings>
          <add key="ODataQueryPageSize" value="1000" />
          <add key="ServicePort" value="8201" />
          <add key="WsdlPort" value="8101" />
      </appSettings>

So, I now have created a brand new Data-mart database, using port 8201 instead of 8101.

I also increased the dataContractSerializer maxItemsInObjectGraph from 524288 to 5242880, as described in Cristopher Francis answer here, so that might helped as well.

Was this reply helpful? Yes No