SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,130 questions
in browser , SSRS 2016 enterprise
Run report error
chan patrick
1
Reputation point
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.
{count} votes
-
Olaf Helper 27,211 Reputation points2022-09-02T10:34:11.71+00:00 Where do you get the error: in browser or Report Builder or SSDT or ...?
Which Edition of SSRS are you using?
Sign in to comment
5 answers
Sort by: Most helpful
-
Joyzhao-MSFT 15,381 Reputation points Microsoft Employee2022-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.
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.-
chan patrick 1 Reputation point
2022-09-05T07:16:23.707+00:00 thanks reply ,
I found the below entry and do not commented , so it is not the cause , would you advise what I need to do to fix it ? thanks
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
Joyzhao-MSFT 15,381 Reputation points Microsoft Employee2022-09-07T09:38:35.353+00:00 Hi @chan patrick ,
I assume you have SSDT and SSRS installed on the same system. SSDT runs in 32 bit whereas SSRS runs in 64 bit. Since we are in the same system, we need to install both the bit-ness of Oracle drivers one by one. see more：Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server).In addition, you need to check whether a component is missing.
Regards,
Joy
Sign in to comment
chan patrick 1 Reputation point2022-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
AniyaTang-MSFT 3,211 Reputation points Microsoft Vendor2022-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-
chan patrick 1 Reputation point
2022-09-06T07:37:23.78+00:00 Thanks reply ,
I can't open the link odp.net , while the second link is for power BI only ?
thanks
AniyaTang-MSFT 3,211 Reputation points Microsoft Vendor2022-09-06T08:14:02.41+00:00 Hi @chan patrick
I'm sorry the first one was my copy error, it's not a link. The second link you mentioned contains SSRS & Power BI Report Server.
I searched again and find one documentation says "SSDT runs in 32 bit whereas SSRS runs in 64 bit. Since we are in the same system, we need to install both the bit-ness of Oracle drivers one by one". So I think you need to download 32 bit Oracle drivers and configure them according to the documentation.
This is the document link: configure-oracle-data-source-for-sql-server-reporting-services-ssdt-and-report-server.
Regards,
Aniya
.
chan patrick 1 Reputation point2022-09-06T08:56:12.507+00:00 Thanks reply ,
I did installed the Oracle drivers and installed it before , but still not work.
Thanks.
Sign in to comment
Sign in to answer
ZoeHui-MSFT 20,176 Reputation points2022-09-07T07:16:13.357+00:00 Here is a documentation about Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server).
You may refer it for more details to see if there are any steps missing.
Regards,
Zoe
in browser , SSRS 2016