Finance | Project Operations, Human Resources, ...

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

(1) 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 42 on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 42 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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