Finance | Project Operations, Human Resources, ...

No report data table with name <TableName> Exists in repot schema for data provider

(0) Share

Report

Posted on by bafrad

I have a dataprovider report with 4 tables, thus 4 datasets pointing to a single data provider class. I actually have 2 other reports that are similar and those work fine.

When executing this report I get an error:

An error occurred during report data sets execution.

Event viewer reveals the error in the subject.

I have:

Restarted IIS
Restarted SSRS
Model build and database sync
Product build
VM Restart
Deleted, and Redeployed the report.
Changed the SRSReportDataSetAttribute declarations from tableStr to just hardcoded strings and vice versa.
Deleted all datasets, and recreated them.
Decreased the size of the name of the tables

I'm not sure what else I can do but the reports do not run. When I debug data is generated successfully in all tables.

I have the same question (0)

All responses (6)

Answers (0)

bafrad 40 on at

Like (0)

Report

I have also removed the 2 datasets (and associated tablix references) that are causing the errors and the report runs. The tables are set up exactly the same as the first 2.

Was this reply helpful? Yes No
TsutomuYanagida on at

Like (0)

Report

Please check https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/troubleshooting-report-definition-issues to see if the issue is relevant or not.

Was this reply helpful? Yes No
bafrad 40 on at

Like (1)

Report

Thanks for the response.

I was able to resolve this today. I had to recreate the tables from scratch. I compared XML between objects and no difference but something had to have been corrupted on the tables.

Was this reply helpful? Yes No
Muhammad Saleh 15 on at

Like (1)

Report

Have you come up with a better solution yet? because this isnt helping as I tried it

Was this reply helpful? Yes No
Suggested answer

Isr 20 on at

Like (1)

Report

Delete the tmptable and recreate it with a different name. It's some cache issue on metadata.
I tried updating the datasource of report, didnt work

I tried renaming DP class, didn't work,

Cleared usage data and ran this url ?mi=SysClassRunner&cls=SysFlushData&cmp=ABMM, didn't work.

When i created a new tmp table and pointed it again in SSRS report and DP class, then i did not face the "No report data...." error and my report was generated.

Was this reply helpful? Yes No
Suggested answer

admin615 5 on at

Like (0)

Report

if one temp table can be used as multiple data sets in report that error will occur, while use separate temp tables in report, it won't generate error "

No report data table with name <TableName> Exists in repot schema for data provider"

Was this reply helpful? Yes No

Join the conversation

Community site session details

No report data table with name <TableName> Exists in repot schema for data provider

No report data table with name <TableName> Exists in repot schema for data provider"

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

No report data table with name <TableName> Exists in repot schema for data provider

No report data table with name <TableName> Exists in repot schema for data provider"

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates