locked
Cannot create a connection to data source 'PPY_DS'. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am getting this error when I am running SSRS report from service account. I am able to open the report manually as well I can connect to database also credential stored in reporting server.

    C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles content are below:

    processing!ReportServer_0-52!6a88!07/28/2020-06:17:09:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'PPY_DS'., ;
     Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'PPY_DS'. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
       at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
       at System.Data.OracleClient.OciEnvironmentHandle..ctor(MODE environmentMode, Boolean unicode)
       at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
       at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
       at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.OracleClient.OracleConnection.Open()
       at Microsoft.ReportingServices.DataExtensions.ConnectionExtension.Open()
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenDataExtensionConnection(DataSource dataSourceObj, OnDemandProcessingContext pc, CreateDataExtensionInstance createDataExtensionInstance)
       --- End of inner exception stack trace ---
    processing!ReportServer_0-52!6a88!07/28/2020-06:17:09:: e ERROR: Data source 'PPY_DS': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'PPY_DS'. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
    processing!ReportServer_0-52!6a88!07/28/2020-06:17:09:: e ERROR: An exception has occurred in data source 'PPY_DS'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'PPY_DS'. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
    processing!ReportServer_0-52!6a88!07/28/2020-06:17:09:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!ReportServer_0-52!6a88!07/28/2020-06:17:09:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
     Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'PPY_DS'. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
       --- End of inner exception stack trace ---
    chunks!ReportServer_0-52!6a88!07/28/2020-06:17:09:: w WARN: Rolling back shared chunk transaction for snapshot 'bc88e972-6a96-41cd-b134-02b39bdd7b63', Permanent=True.

    Could you please help me with this error.

    Thanks

    Sandeep


    Tuesday, July 28, 2020 10:33 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Amelia and Olaf Helper, 

    Thanks for your support.

    I have followed below link and it worked for me for others benefit i am posting the link. 

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

    Sandeep

    Tuesday, August 18, 2020 5:54 AM

All replies