SSRS report retrieving field metadata error

[Ventainais]

Hello all!


I have an ssrs report which uses data provider classes and temp tables for data.
In the temporary table I added a new string field, I synchronized the table, compiled the DP classes and it's controller class (additionally used compile forward).

The problem I have is, when I deploy the report through Ax management shell, I get an error:
Publish-AXReport : The AXRDCE extension caught an unexpected exception for repo
rt SalesQuotation.
The error message was:
An exception occurred when retrieving the field metadata for the field Name_LF
in table SalesQuotationDetailsTmp.

The report has more then one design, I use the new added string field in one design and the deploy command finishes without errors, but when I add the same new field in my other design, I get the above mentioned error.

I think I tried everything what I could come up in with, AOS and reporting services restart won't help.

Does anyone else have an idea what I could try?

[sukhanchik]

AX 2012?

For AX 2012:
Let's try the standard actions first.
1. Let's compile all our objects without errors and build a complete CIL (Close Visual Studio)
2. Restart AOS
3. Launch Visual Studio
4. Remove the DP-class from the SSRS-report along with the fields and parameters that were registered there
5. Let's save the SSRS-report and the project in AOT and make sure that the compilation of the report and the project occurs without errors.
6. Let's re-add the DP-class to the report as a data source
7. Let's rewrite the fields in the controls.
8. We'll compile everything and rebuild the full CIL
9. After any assembly of a complete CIL - restart the AOS.

Errors should go away

[Ventainais]

Thank You for the response.

step 4. remove DP class from report.

I understand that if I remove the DP class from the report, then I have to delete the report textboxes in them, because they are referencing the data, do I understand that right?

[sukhanchik]

Цитата:

Сообщение от Ventainais

Thank You for the response.

step 4. remove DP class from report.

I understand that if I remove the DP class from the report, then I have to delete the report textboxes in them, because they are referencing the data, do I understand that right?

There are 2 options.
1. It is enough to delete the class, save and close the report. Then add the DP class again. The report will work.
2. Remove the class, then clear all field references to fields, save and close the report. Then add the DP class and manually re-reference the fields.

The DP class must be removed from the report. It won't work without it. But I usually had enough of option 1

[Ventainais]

Thank You sukhanchick, everything is fine now.