If you receive the following error when running an SSRS report –
“An exception of type MetdataException has occurred while performing the operation.”
– the issue most likely has to do with the AX datasource metadata. One such possible cause is an incomplete definition of a relationship on a table. For example, we ran into this issue when printing the Project Invoice Journals report. The report was not customized, but it turned out that the datasource table was customized by a previous implementation partner. A table relation was added to the ProjInvoiceJour table, which contained no lines. Fixing this relationship resolves the metadata issue.
Hi, It’s a very good blog, i was facing the same error in Purchase requisition report and when i read this blog I checked all the relations and elements but not succeed to get the exact issue. This problem was existing in Training server only but not in Dev and Production server then I took table’s xpo from production server and compared during import in Training server but didn’t find any discrepancy then I imported the tables into Training and checked error had been resolved.