• sqlfriends - Tuesday, February 27, 2018 5:35 PM

    I did an in place SQL server reporting server upgrade for 2017 SSRS.
    The server has both database engine and SSRS service.

    The SSRS service is the newest download from website.
    I can see from reporting server configuration manager it is the standard edition and the product version is 14.0.600.594.

    But  some of the datasource we created before not working.
    The oracle type for the connection, there is a line under it saying The data extension used here is not available. It has either been uninstalled, or it is not configured correctly.

    What could be wrong?

    Thanks

    The extension could be missing from the config file. In the ReportServer directory, there is a rsreportserver.config file that would have the extensions listed. Open that in a text editor and in the data section there should be all of the supported extensions listed. Oracles would be: 
    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    You pretty much want to always check the ReportServerService log file as it can provide additional information.

    Sue