Problem:
You get error message when config MR 2012:
"An unexpected error occurred while querying the Metadata service"
System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012MetadataService.MetadataFault]:
An exception of type MetdataException has occurred while performing the
operation. (Fault Detail is equal to
Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012MetadataService.BatchFault).
Cause:
You add custom fields to table which is used as Financial Dimension.
e.g. You add custom fields to InventLocation, and use the table as Custom as Financial Dimension.
Solution:
Add relations to fields on the table.
Every additional fields on the table which is used to Financial Dimension must have relations.
Reference:
a. How to add table to be use on Financial Dimension:
https://dynamicsaxinsight.wordpress.com/2014/07/14/ax-2012-add-financial-dimension-for-your-table/
b. Another same problem
https://community.dynamics.com/ax/f/33/t/123925
Thank's to David Orr
Hi, I encountered the same issue. May I know if there are any ways to find out the problematic tables?
ReplyDeleteIn my experience.
DeleteYou should check your customized table manually.
Check your customized field, make sure you have already create the Relation on the table for the fields.
Extremely, In my test, I remove all customization for all the table that used as Customized Financial Dimension.
Then, try all the origin table to be configured to Management Reporter.
If no problem is found, then you could add the Customization table by table.
If you found the problem is occurred on particular table, the you could add the customization field by field, until you found the problem.
You should perform the test one by one, which mean, for one customized table and field you have imported, you should test the configuration.
Hopefully help.
Might be you find someone who find better solution.
Sorry for my bad English. :)