Run report error

chan patrick 1 Reputation point
2022-09-02T09:40:34.337+00:00

I have a oracle database version 12.1.0.2.0 that running on SQL server SSRS 2016 .

When I run the report , it pops the below error .

An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

Then I have installed the package called "ODAC122011_x64" on it , but still no help .

Would advise how to fix the issue ?

thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
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,827 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,564 questions
{count} votes

5 answers

Sort by: Most helpful
  1. chan patrick 1 Reputation point
    2022-09-03T01:51:43.967+00:00

    in browser , SSRS 2016 enterprise

    0 comments No comments

  2. Joyzhao-MSFT 15,566 Reputation points
    2022-09-05T02:27:50.957+00:00

    Hi @chan patrick ,
    Try opening your rsreportsserver.config file as an administrator. Applies to: SQL Server Reporting Services (2016).
    The path is:C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer
    Locate the <Extension Name="ORACLE"... node and check if it’s commented out. If it is, uncomment it.
    237655-01.png
    Save the file and restart SQL Report Server.

    If the issue is not resolved, please check the Report Server Service Trace Log and Windows Application Log for more error messages.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.


  3. chan patrick 1 Reputation point
    2022-09-05T09:24:21.813+00:00

    I also find the below Trace log , it seems do not have issue .

    <Header>
    <Product>Microsoft SQL Server Reporting Services Version 13.0.1601.5</Product>
    <Locale>en-US</Locale>
    <TimeZone>China Standard Time</TimeZone>
    <Path>C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles\Microsoft.ReportingServices.Portal.WebHost_09_05_2022_09_07_11.log</Path>
    <SystemName>EORDER</SystemName>
    <OSName>Microsoft Windows NT 6.2.9200.0</OSName>
    <OSVersion>6.2.9200.0</OSVersion>
    </Header>
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:11:: i INFO: Setting up Debug CRT libraries
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:11:: w WARN: %_NTDRIVE% not defined... Skipping
    Microsoft.ReportingServices.Portal.WebHost!library!1!09/05/2022-09:07:11:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    Microsoft.ReportingServices.Portal.WebHost!library!1!09/05/2022-09:07:11:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    Microsoft.ReportingServices.Portal.WebHost!library!1!09/05/2022-09:07:11:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExceptionMicrosoft.ReportingServices.Modeling.InternalModelingExceptionMicrosoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    Microsoft.ReportingServices.Portal.WebHost!library!1!09/05/2022-09:07:11:: i INFO: Do not dump on: System.Threading.ThreadAbortExceptionSystem.Web.UI.ViewStateExceptionSystem.OutOfMemoryExceptionSystem.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadExceptionMicrosoft.SharePoint.SPExceptionMicrosoft.ReportingServices.WmiProvider.WMIProviderExceptionSystem.AppDomainUnloadedException
    Microsoft.ReportingServices.Portal.WebHost!library!1!09/05/2022-09:07:11:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:11:: i INFO: Starting ReportServerWebApp
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:12:: i INFO: Working directory : C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\RSWebApp
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:12:: i INFO: Report Server url: http://localhost:80/ReportServer
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:12:: i INFO: Report Server Web App virtual root: /Reports
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:12:: i INFO: Web app url: http://+:80/Reports/
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:12:: i INFO: Authentication scheme(s): Ntlm
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 0 : AuthSchemeConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 5 : RequestLoggingConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 10 : CustomAuthenticationConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 20 : BasicAuthenticationConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 25 : RequestThrottlingConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 30 : CsrfTokenCreationConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 40 : LanguageConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 50 : XFrameOptionsConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 50 : ClassicUrlRedirecterConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 50 : PopulateHeadersConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 53 : LocalWindowsAuthRequestConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 55 : ClassicUrlRewriterConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 100 : FileSystemConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 190 : ServiceUnavailableConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 200 : DatabaseAvailableConfig
    Microsoft.ReportingServices.Portal.WebHost!crypto!1!09/05/2022-09:07:13:: i INFO: Initializing crypto as user: NT Service\ReportServer
    Microsoft.ReportingServices.Portal.WebHost!crypto!1!09/05/2022-09:07:13:: i INFO: Exporting public key
    Microsoft.ReportingServices.Portal.WebHost!crypto!1!09/05/2022-09:07:13:: i INFO: Importing existing encryption key
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 300 : CsrfTokenValidationConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:13:: i INFO: Registering 500 : WebApiOwinConfig
    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!09/05/2022-09:07:14:: i INFO: Registering 600 : ODataWebApiOwinConfig

    0 comments No comments

  4. AniyaTang-MSFT 12,331 Reputation points Microsoft Vendor
    2022-09-06T06:55:09.873+00:00

    Hi @chan patrick
    You may need to run the 2 commands in the SSRS documentation to register the ODP.NET driver: oracle-connection-type-ssrs.
    Best regards,
    Aniya


  5. ZoeHui-MSFT 33,701 Reputation points
    2022-09-07T07:16:13.357+00:00

    Hi @chan patrick

    Here is a documentation about Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server).

    https://techcommunity.microsoft.com/t5/sql-server-support/configure-oracle-data-source-for-sql-server-reporting-services/ba-p/319134

    You may refer it for more details to see if there are any steps missing.

    Regards,

    Zoe

    0 comments No comments