An error occurred during report data sets execution

(2) Share

Report

Posted on by Community Member

Hi,
I'm getting this error "An error occurred during report data sets execution" every time i run my custom RDP report. i restarted all my services and restored the Report's DS. I even ran the debugger but every time the ProcessReport method ends, i get this error, no line nor class is pinpointed by the debugger that might give me a clue as to what is wrong.
Any Suggestions on how to resolve this?

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Sangram Shinde 2,114 on at

Like (0)

Report

RE: An error occurred during report data sets execution

Hi Sami,

It seems there is some minor issue in either data or code, have you checked all the values you are passing to the all method calls in your DP class? may be somewhere it may require some different data and what your code passing is different, or any null value exception.

Thanks,

Sangram

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: An error occurred during report data sets execution

Hi Sangram,

The code is parsed without any error. No exceptions or any stuff like that. It's quite weird. The debugger or Error logger doesn't prompt any error

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report

RE: An error occurred during report data sets execution

Ok, have you tried deleting report design from report server and deploying it again?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: An error occurred during report data sets execution

i made an entirely new design and deleted the old one.

Was this reply helpful? Yes No
Sukrut Parab 71,699 Moderator on at

Like (1)

Report

RE: An error occurred during report data sets execution

This error can come in different situations like if division by zero happens in your data provider or some wrong code . Look at your expressions in the report design as well

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: An error occurred during report data sets execution

I've handled that case in my report. When i run the debugger, It parses the code without any error and then jumps into one of the system classes by the name of "Global.axce.xml" its after parsing through this class i get prompted with that error

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: An error occurred during report data sets execution

UPDATE:

I deleted the temp table and made a new one and it resolved the issue. Thanks

Was this reply helpful? Yes No
Naysh on at

Like (0)

Report

RE: An error occurred during report data sets execution

Which temp table, specifically?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: An error occurred during report data sets execution

In my case it did not. I also created a new temp Table, but it didn't work out. It worked out for you, by just creating a new Table ?

Was this reply helpful? Yes No
Retha 1,455 on at

Like (0)

Report

RE: An error occurred during report data sets execution

I came across this link while searching for a solution:

community.dynamics.com/.../error-an-error-occurred-during-report-data-sets-execution-in-d365-operations

See if it helps. My case in the end was different. Me with sys admin rights were able to run the report but the end-user got the error mentioned in the title.

The problem was that I copied BankAccount field to my new temp-table of type TempDB. One of the properties on this field is: AOS Authorization, and it was set to YES. I changed it to NO same as the other fields on the temp-table and then I was able to run the report as the end-user role without getting the error mentioned

Was this reply helpful? Yes No