Error pvInvalidDefinition : The definition of the report xxx is invalid.

Peter Nolan 1 Reputation point
2021-03-06T12:08:17.273+00:00

Hi All,

I am resurrecting some RS dashboards I created in 2006 using VS 2005, SQL Server 2005, and Dundas charts.

In 2006 I was convinced MSFT would make it BIG with RS. But by 2010, with the purchase of Dundas widgets, and the slow uptake of RS, we decided to put those old reports in mothballs. There was no automated way to upgrade from the Dundas charts to the MSFT charts and it all just seemed like too much trouble in 2010.

But here we are in 2021. Now SQL server is MUCH faster and it is a viable competitor for real DWs.

Also, RS is MUCH better. So we think it's time to dust off these old reports and upgrade them. We will likely do new dashboards in Power BI some time soon too. But we have 70+ reports we can just dust off and convert so that's a good starting point.

I am using VS2017 SSDT but I am getting the same result on VS2013. There is something amiss with the upgrade process of the RDL.

I have seen a LOT of posts about this problem. I have tried all those things like upload the report from bin and download it again and put it back in to the project. All to no avail.

Currently I am able to load the report into RS on SQL server 2016 developer edition and it runs ok. So SQL Server can read and process the RDL. But VS2017 and VS 2013 can't.

The message in VS for the deploy is: "Error pvInvalidDefinition : The definition of the report '\ACPA0100 - Campaign Revenue Variance Summary.rdl' is invalid."

When I try preview I get "An error occurred during local report processing. The size necessary to buffer the XML content exceeded the buffer quota".

I was quite expert on RS in 2006 but I have to admit I am rusty.

If any of you "young guns" know what is the exact problem with the RDL XML and can tell me how to fix it?

I would be very grateful.

I have put the report and components in my drop box here if you need to look at it to know exactly what is wrong. What a great idea for being able to share code with problems in it!

Thank you in advance!

https://www.dropbox.com/sh/kdtvmb1pvnkwiv2/AADX5Ka626Yn37BSkmNknlDza?dl=0

Best Regards

Peter

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,796 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-03-08T02:33:20.353+00:00

    Hi @Peter Nolan ，

    Error pvInvalidDefinition : The definition of the report '\ACPA0100 - Campaign Revenue Variance Summary.rdl' is invalid.

    This error occurs when the RDL you uploaded has a version that is not supported by the SSRS server. For example, a SSRS 2016 RDL version is uploaded to a SSRS 2012 server. You can see the version incompatibility information in the error message text itself.
    There are no tricks to solving this problem. All you need to do is set the RDL to the appropriate version that's supported by your SSRS server. however, to this fix. The original RDL version is always stored in the project directory as the HIGHEST RDL version supported by VS or RB. Whereas the appropriate (aka downgraded) version is found within the “BIN” project directory.
    The "BIN" project directory here, it can be BIN or BIN\Debug or BIN\Release. Located in the folder where the recently created RDL is stored.

    How to choose a suitable RDL version/downgrade RDL version?
    In the Solution Explorer window, right-click on the project and select Properties.
    In the TargetServerVersion drop down, select the appropriate version. Once the appropriate version is selected, click on the OK button.

    It is important to understand how to "downgrade" reports to support all versions of SSRS you intend to support. This is a very simple solution that allows people with different SSRS versions to use your report.

    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. WU YY Yaoyao (APJ) 1 Reputation point
    2022-03-04T01:26:37.91+00:00

    i occurred the same error when deploy the report. I tried to upload the report file directly in reporting service, and the detail error message is showed: "the expression of the textbox xx has wrong, xxxx".
    so we can use this method to get the detail error message and then update the error to re-deploy.

    0 comments