web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2009 SSRS - Query ex...
Microsoft Dynamics AX (Archived)

AX2009 SSRS - Query execution failed for dataset - error only in the browser after deployment ?

(0) ShareShare
ReportReport
Posted on by JFM 660

Im working on a problem with SSRS (reporting tools).

I have a report in SSRS that works well since 1 or 2 years. I made a couple of updates since the first release.

Last week, I made a minor update to this report. Something that I do often (adding 2-3 lines on the report from a table where i added a couple of new fields)

But for a reason that i dont understand, i cannot get the value of my new fields.

I received this error only in the browser (in VS its fine, i see my results) :
"An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'Data'.
Exception has been thrown by the target of an invocation.
Dynamics Record Adapter GetField failed.
Exception of type 'System.ArgumentException' was thrown."


Error occured with the GetField method. After checking closely my code in VS, everything is fine. I reuse many methods that works #1. I dont see any problem with my code. So I start to think about weird problems that can occured with the mix of AX2009, SSRS, adapter.


One of my hypothesis was that the query return too many fields that the connector cant handle. This report works with a table dedicate to this report. Data are build in a batch job each day. So my table is use only for this table, than the query is made with SELECT *. Since some fields are not used anymore, i tried specify each necessary fields in the SELECT instead of the *. Reports that throw error that my query cannot be compile and printed my query. If I copy the query and put the query directly in a job in AX, its works #1. 

2nd hypothesis was that my new fields have a too long name (maybe AX can handle this long name but the the adapter?). I renamed fields, but still get the same error.

3rd hypothesis was that maybe, somewhere, its take the wrong ax instance. So i added all my new fields in all AX instance. Same result. I dont know right now what to do. Im trying to browse the web to find some limitation of AX2009 with reporting extensions. 

I repeat what I said before, its work in VS.


Can you help me ?

*This post is locked for comments

I have the same question (0)
  • Adrian Pascari A Profile Picture
    Adrian Pascari A 1,683 on at

    I had the same problem in Axapta 2009 with container fileds - fields with [].

    To find the field that is returning the error-> modify the query in Visual Studio. Instead of 'Select *' write fileds you need one by one and check it. Run only the DataSet. Fileds in select has to be written by format <TableName>.1.<FieldName>.

  • JFM Profile Picture
    JFM 660 on at

    I think i tried 2-3 fields, I will check if at least one of my new fields works.

    Whats the purpose of "1." in the format ?

    I never wrote fields like that. I put normally only the field name in a AX query.

    Do you did something special to correct your problem ?

  • Adrian Pascari A Profile Picture
    Adrian Pascari A 1,683 on at

    Usually I run the query from the DataMethod:

    In my situation the problem was with Dimension field. I wrote it in my dinamic qury and it worked.

  • Verified answer
    JFM Profile Picture
    JFM 660 on at

    Finally I did something that I should try ealier. I restart the SSRS services.

    Its now working.

    So, the service was not restart after I created the new fields, SSRS didnt see the new fields. Its that normal ?

    For now, im the only one working on SSRS here, so its not a problem to restart the SSRS services when needed on the development server. Could be a problem when we will be more working on SSRS at the same time.

  • venkatesh vadlamani Profile Picture
    venkatesh vadlamani 3,180 on at

    This kind of error are previal in Ax 2012 SSRS also. When the returned record set has different meta data the adapter fails to recognize it . The best thing to do Delete report from Report Manager. Remove entries of the report in SysLastValues.  IF using Ax2012 delete records in SRSReportQuery table also.

    Restart AOS ans Reproting service and redeploy and execute

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans