Close Menu
    Facebook X (Twitter) Instagram
    Friday, May 16
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»Configmgr SSRS failed to upload RDL with error code definition of this report is not valid or supported by this version of reporting services

    Configmgr SSRS failed to upload RDL with error code definition of this report is not valid or supported by this version of reporting services

    Eswar KonetiBy Eswar KonetiJune 16, 11:56 pm3 Mins Read CM2012 18,660 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Introduction:

    When working with SQL Server Reporting Services (SSRS), you may encounter an error message stating, "The definition of this report is not valid or supported by this version of Reporting Services." This error can occur when attempting to upload an RDL (Report Definition Language) file into your SSRS reports. In this article, we will explore why this error occurs and discuss possible solutions.

    Why Does This Error Occur?

    The error message indicates that the RDL file you are trying to upload was created using a version of the reporting tool that is newer than the version of SQL Reporting Services installed on your server. In other words, if the RDL file was generated using a higher version (in this case, 2016) of the reporting tool than what your SQL Server is running (SQL Server 2014), you will encounter this issue.

    Explanation:

    Each version of Reporting Services comes with its own features, schemas, and target namespaces that define the structure and functionality of reports. These schemas and namespaces ensure compatibility and consistent interpretation of the report definitions within the reporting platform.

    When you attempt to upload an RDL file, the system compares the target namespace specified in the file with the version of Reporting Services it supports. In the case of an incompatible target namespace, such as 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition,' the system recognizes that the report definition cannot be upgraded to match the current version.

    Consequently, the system assumes that the report definition either contains content that is not well-formed or is not valid based on the schemas of the installed version. As a result, it throws the error message mentioned, preventing the upload of the RDL file.

    image

    Resolving the Issue:

    To make the report work on an older version of Reporting Services, you need to make two changes in the RDL file:

    1.Open the RDL file using a text editor such as Notepad or any other editing tool. Look for the following line at the beginning of the code:

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition"

    image

    Change the version from "2016" to "2010"

    2. Search for the block of code that contains "ReportParametersLayout" in the RDL file. This block of code is specific to reports created in the 2016 version of Visual Studio.

    As shown below ,Remove the entire block of code related to "ReportParametersLayout" from the RDL file. It should look similar to the following:

    image

    Save the modified RDL file.

    After making these changes, try uploading the modified RDL file into the Reporting Services and update the data source if necessary. You should now be able to run the report successfully on the older version of Reporting Services.

    Conclusion:

    Change the SQL version in the RDL file and remove the ReportParametersLayout to get the report into working state.

    cannot upload reports configmgr definition of this report is not valid or supported by this version of Reporting Services failed to upload sccm report ReportParametersLayout rsInvalidReportDefinition SCCM SQL Error SSRS
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Identifying devices managed by Intune but not reporting to WUfB using KQL

    November 09, 10:28 am

    13 Comments

    1. Evinrude on May 22, 2023 5:16 PM

      This SQL query work but it only lits 5 Windows 10 machines

      Reply
      • Eswar Koneti on June 26, 2023 7:44 AM

        Hi,
        Did you validate if your has any filters to limit few results? can you post your query?

        Thanks,
        Eswar

        Reply
    2. wendy yan on August 10, 2021 5:04 AM

      Thank you very much for this very clear and simple instruction!!! It solved my problems.

      Reply
    3. Muslim on January 8, 2021 4:06 AM

      Thank You so much man, been struggling with this for 2 days.

      Reply
      • Eswar Koneti on January 13, 2021 11:27 PM

        Thank you.

        Reply
    4. Barbara on October 22, 2020 3:42 AM

      I just did it! It worked!!! Thank you – thank you – thank you!!!

      Reply
    5. Bindra Shrestha on September 25, 2020 5:42 AM

      I am using visual studio 2019 and sql server 2016. After making above changes, RDLC report now shows the new error -"A data source instance has not been supplied for the data source... message. If I go back and add back data source again, version of report is now changed back 2016. So I am cycling between same 2 errors. Any suggestions much appreciated

      Reply
      • Eswar Koneti on September 27, 2020 2:11 AM

        Hi,
        after you make the changes, did you change the data source to the correct one?

        Thanks,
        Eswar

        Reply
    6. Shazzad on April 7, 2020 4:41 PM

      Thank you so much for your helpful work.

      Reply
    7. Pingback: Error while uploading a report – oraerr.com

    8. Subhoshree on September 10, 2018 6:56 PM

      Thank You so much Eswar for this resolution!!

      Reply
      • Eswar Koneti on September 12, 2018 9:17 AM

        Glad ,it helped!

        Thanks,
        Eswar

        Reply
      • Jair Roberto Del Angel Gil on May 4, 2019 12:48 AM

        Thank you so much, is working

        Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.