1

I installed SSRS 2013, and made a report and deployed it into SSRS server. My source database Oracle ,and I also have Oracle client and .net data provider on the same server that SSRS is installed.

When I tried to view published reports on the server the following error is raised:

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)

Could anybody cam help me out of this?

APC
  • 144,005
  • 19
  • 170
  • 281
user3577606
  • 137
  • 1
  • 10
  • is this helfpul https://stackoverflow.com/questions/39776069/ssdt-in-visual-studio-2015-oracle-connection-issue – Moudiz Dec 26 '18 at 07:56

2 Answers2

0

You could refer to Moudiz's link for help. You need to pay attention client will use 32bit, and Server will use 64 bit, so you need to install two version to test. You could refer to Oracle Connection Type and Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server)for details.

Zoe

zoe zhi
  • 164
  • 3
0

I recently had the same issue with PBI Report Server. It ended up being that the ORACLE provider was commented out in the rsreportsserver.config file.

  1. Open your rsreportsserver.config file as an administrator. Microsoft has documented the locations here. In my case it was found in C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config.
  2. Locate the <Extension Name="ORACLE"... node and check if it’s commented out. If it is, uncomment it. enter image description here
  3. Save the file
  4. Restart the PowerBI Report Server Service / SQL Reporting Server Service.

Hopefully this has resolved it.

Peter Godwin
  • 77
  • 11