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

(0) Share

Report

Posted on by Muhammad Saleh

I have 14 Datasets pointing to a single DP class with one SSRS Report attached to it, every time I try to execute after entering parameters, the error shown above is thrown on F&P dashboard

I have tried:

Restarted IIS
Restarted SSRS
Model build and database sync
Deleted All datasets and recreated them (from SQL server too)
Recreated Contract, UI and DP class from scratch (IN SEQUENCE, tables first -> classes -> report -> menu)
Cleared Cache

My Conclusion:

Report throws this error after adding more than three datasets, works just fine with three datasets,

NEED A WORKING SOLUTION

I have the same question (0)

All responses (15)

Answers (0)

Sort by

atajjo 509 on at

Like (1)

Report
Copy link

Link copied!

I'm having the same issue with a report that has 2 DPs that have one temp table per each. So I don't think it's related to the number of datasets.

Btw I'm having this issue in local dev machine, version 10.0.17 .

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

Like (0)

Report
Copy link

Link copied!

Have you tried recreating tables and DP class from scratch in sequence with different names?

Recreate Tables from scratch - build - Recreate DP class - build - so on

OR follow the steps in the question (THE ONLY SOLUTION YET)

Was this reply helpful? Yes No
atajjo 509 on at

Like (2)

Report
Copy link

Link copied!

No, I only tried re-creating the report from scratch.

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

I have the same issue did you find any solution for this error.

Best regards,

Shabir

Was this reply helpful? Yes No
atajjo 509 on at

Like (1)

Report
Copy link

Link copied!

[quote user="Shabir Ahmad"]
Hi ,

I have the same issue did you find any solution for this error.

Best regards,

Shabir
[/quote]

No. I decided to ditch the data provider and go with the query based approach. Luckily, I already built an AOT query that contains most of my requirements.

I had to modify the query to get all the info I needed, but it was better than wasting more time with this strange issue.

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

Hi,

My report will must be developed follow the DP calss and etc so i again started creating new tables, and classes etc.

Was this reply helpful? Yes No
atajjo 509 on at

Like (1)

Report
Copy link

Link copied!

[quote user="Shabir Ahmad"]
Hi,

My report will must be developed follow the DP calss and etc so i again started creating new tables, and classes etc.
[/quote]

Well, my reply was a workaround, not a solution, so of course it's not suitable to every situation. Just curious, in what type of environment do you face this error?

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

Hi,

My environment is D365 fin and ops

Was this reply helpful? Yes No
atajjo 509 on at

Like (1)

Report
Copy link

Link copied!

[quote user="Shabir Ahmad"]
Hi,

My environment is D365 fin and ops
[/quote]
What tier? (Local VM, cloud dev, UAT, Production)

Was this reply helpful? Yes No
Shabir Ahmad 3,124 on at

Like (0)

Report
Copy link

Link copied!

Cloud Dev

Was this reply helpful? Yes No