Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Extension of a data provider class

Posted on by 8,201

Just wondering if anyone has faced this issue so far: you have to create an extension for a SSRS report's provider class and add a new table that will be send to the report using the SRSReportDataSetAttribute. All sound good and like it will work, until I get this error "An error occurred during report data sets execution".

The event viewer has only a "An exception occured during Ax Report Provider execution." message.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Extension of a data provider class

    Hi, Iulian Cordobin

    Can you show me how you insert data to the new tmp table that you created?

  • Suggested answer
    VinodKumarKJ Profile Picture
    VinodKumarKJ 5 on at
    RE: Extension of a data provider class

    Hi,

    The issue was with dataset referring to a table where some field was missing.

    It is resolved.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Extension of a data provider class

    I am having same issue. Trying to add new parameter to VendAgingReport.  Extended DP class, Contract class. New field appears on a dialog box but at report execution time i am getting same error " An error occurred during report data sets execution"

  • RE: Extension of a data provider class

    Hi Iulian,

    did you found a solution for this issue?

    I am facing the exact problem, but I don' t how to solve it.

    I am extending the report data provider class fr the wmspickinglist report, I am adding a new dataset. The build goes ok, but when I run the report, I am having the error "An exception occured during Ax Report Provider execution."

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Extension of a data provider class

    Is the method returning the data called successfully? It's called later than processReport().

    The best thing would be sharing all details about the error, especially its type and call stack.

  • Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at
    RE: Extension of a data provider class

    I would have loved to see this work (it is quite a cool way to extend the DP classes / SSRS reports), but so far seems it either a bug, or maybe a not supported case? (OR maybe I'm missing something...).

  • Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at
    RE: Extension of a data provider class

    Hi Martin,

    The error is displayed when the report (and by this I mean standard ssrs implementation code) is already running and passed the populate code in the DP. Debugging it shows that the augmented class is called properly in order to populate (method m1)  the new table (a Regular table with a SetConnection on it); the call to m1 is done in the (base class) ProcessReport method via a delegate / handler subscribed. Looking at the table I see the record (with nolock).

    I wonder, is anywhere in the SSRS execution when the processing engine fails to actually see the DataSetAttribute in the augmented class (reflection failing)?

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Extension of a data provider class

    When do you get the error? Did you try to debug it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans