Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / No report data table w...
Finance forum
Unanswered

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

(0) ShareShare
ReportReport
Posted on by Muhammad Saleh 15

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:

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

My Conclusion:

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

NEED A WORKING SOLUTION

Categories:
Data Integration
Development / Customization / SDK
  • Community member Profile Picture
    Community member 2 on at
    No report data table with name Exists in repot schema for data provider
    I'm also encountering the same
  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,999 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi,

    Anything, i did new not duplicate , because on duplicating already waste 1 day then on another day i recreate class and table object now resolve.

    Best Regards,

    Shabir Ahmad

  • AT982020 Profile Picture
    AT982020 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Hi ,

    My issue was resolved by writing again DP class Code and recreating  tmptables .

    Best Regards,

    Shabir Ahmad

    [/quote]

    Congrats then. Just curious, did you duplicate these object or create them manually again from scratch? Because I tried duplicating the tmp table and it didn't solve the issue.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,999 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi ,

    My issue was resolved by writing again DP class Code and recreating  tmptables .

    Best Regards,

    Shabir Ahmad

  • AT982020 Profile Picture
    AT982020 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Cloud Dev

    [/quote]

    If you're sure there are no issues in your code, maybe you should raise a support ticket with Microsoft? Since you're developing on a cloud machine, it should belong to an LCS project and therefore you should be able to raise issues in that enviornemnt.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,999 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Cloud Dev

  • AT982020 Profile Picture
    AT982020 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Hi,

    My environment is D365 fin and ops

    [/quote]

    What tier? (Local VM, cloud dev, UAT, Production)

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,999 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi,

    My environment is D365 fin and ops

  • AT982020 Profile Picture
    AT982020 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [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?

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,999 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi,

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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans