Search This Blog

Thursday, 5 March 2015

no report data table with name exists in report schema for data provider


I was getting the following error message when I move my already running report from Test Server to the Live Server.

After running the report on live server the error message was:

"No report data table with name MZK_ProductPriceHeaderTmp exists in report schema for data provider MZK_ProductPriceDP."

 The Solution to this issue is that restart the reporting services running on this server and than clear cache and the usage data and than try to run the report again.

Thanks

Muhammad Zahid.

Posted by at

10 comments:

  1. Unknown17 October 2015 at 20:51

    Hi Zahid,
    Iam also facing the same error ,please if you find any solution can you please post here.
    Thanks in advance.

    Regards,
    Naresh.

    ReplyDelete
    Replies
    1. Muhammad Zahid20 October 2015 at 11:18

      Hi Kuche Naresh,

      I have already post the solution on the above post.Please check and apply and than let me know if its fixed your issue or not.

      Thanks
      Muhammad Zahid

      Delete
  2. Unknown10 November 2015 at 09:33

    Thanks! This worked for me.

    ReplyDelete
  3. Unknown28 September 2016 at 20:03

    Work for me thanks!

    ReplyDelete
  4. Anonymous24 December 2019 at 04:12

    how to clear the cache?

    ReplyDelete
  5. Kanika's Tech Blog13 May 2021 at 23:30

    can you tell me how to clear cache and usage data??

    ReplyDelete
  6. Unknown27 October 2021 at 22:55

    Thank you, worked for me.

    ReplyDelete

Subscribe to: Post Comments (Atom)