Reporting Services - Oracle Source.

  • sudhakara

    SSCrazy Eights

    Points: 9425

    Hi,

    I am getting the error message while viewing from http://localhost/reports after deploying the ssrs reports which has been created using the Oracle Source to pull the data from oracle 10g server.

    The error message follows

    An error has occurred during report processing.Cannot create a connection to data source Oracle.OCIEnvCreate failed with return code -1 but error message text was not available.

    Pls help me to resolve this issue.

    Thanks in Advance.

  • sudhakara

    SSCrazy Eights

    Points: 9425

    Has anyone come across such a problem ?

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    Apparently not if they haven't posted a reply.

    Two suggestions for you.

    1) Google the error message.

    2) Make sure you can connect to your data source outside of the report using the same user name and password the report has. I'm betting it's a security issue on Oracle's side. But this is a W.A.G. on my part because I don't know Oracle.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Erik-496633

    Mr or Mrs. 500

    Points: 573

    I am getting the same error too, right now, and also searching for a fix.

    I'm in the BIDS designer and while simply testing the connection I get this error, "OCIEnvCreate failed with return code -1 but error message text was not available".

    The following link makes it sound like a permission issue on the Oracle folder.

    http://oraclepoint.com/oralife/2010/08/19/oracle-odbc-connection-issue-of-system-exception-ocienvcreate-failed-with-return-code-1-on-windows-with-asp/

    I tried changing permissions but it did not solve it for me. Maybe I didn't get the steps right...

    I've read another link discussing this error and it seemed to indicate there may be a fix in a newer version of the oracle 10g connection client software. That's what I think I'll try next.

  • Erik-496633

    Mr or Mrs. 500

    Points: 573

    Just solved it for me with these steps...

    1. Uninstalled all Oracle products.

    2. Deleted the Oracle directory, (since the Oracle uninstaller did not do so).

    3. Visited here http://www.oracle.com/technetwork/database/10203vista-087538.html

    4. Downloaded the appropriate version for my 32-bit Windows 7 of the "Oracle Database 10g Client Release 2 (10.2.0.3)".

    5. Installed using the Administrator option set (probably doesn't matter which install option set you choose).

    Noticed that during the install, the scrolling log section mentioned applying patch/fixes. So I'm guessing that the original Oracle 10g client connection software that I installed was missing whatever this patch was...

    Without even rebooting, I tested the connection using several non-Oracle tools and it now works. Hope that is a help.

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    Thanks for posting your solution, Erik. That will help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • vanu

    Newbie

    Points: 2

    Hi, I was getting same error when I was trying to create SSRS datasource (SQL RS 2012) to Oracle database. And in my case I found that there were two instances of Oracle client installed on SSRS (SQL Reporting Service) server i.e.

    1st Installation (main) at C:\Oracle\*

    2nd Installation at C:\Program Files\Oracle*

    I resolved this error by uninstalling 2nd Oracle client installation using Oracle Universal Installer utility on SSRS server. I believe when SSRS trying to look for TNSNAMES.ORA file it was not able to refer due to two set of Oracle client.

    Thanks,

    Ash

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply