Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

AX 2012R3 Management Reporter Datamart Reset

Posted on by Microsoft Employee

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.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX 2012R3 Management Reporter Datamart Reset

    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.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: AX 2012R3 Management Reporter Datamart Reset

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX 2012R3 Management Reporter Datamart Reset

    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
  • Andre Ghazaleh Profile Picture
    Andre Ghazaleh 870 on at
    RE: AX 2012R3 Management Reporter Datamart Reset

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX 2012R3 Management Reporter Datamart Reset

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans