web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / No report data table w...
Finance | Project Operations, Human Resources, ...
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,988 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,988 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,988 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,988 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,988 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

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…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

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

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans