You’re offline. This is a read only version of the page.
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.
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.
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.
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
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
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
If nothing of that helps, I would recommend that you open a support call with MS to get this fixed quickly.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (