Hello,
I am new using the Oracle Data Access components. My company 32-bit .NET 4.0 VB.NET application uses the ODAC 12c libraries and it runs for an 2 plus hours and then crashes with the following:
Exception Level 1: Execption Type: Exception Exception Level 1: Error Description: OCIEnvCreate failed with return code -1 but error message text was not available.
Exception Level 1: Source:System.Data.OracleClient
Exception Level 1: Stack Trace: at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
1: at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
1: at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
1: at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
1: at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
1: at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
1: at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
1: at System.Data.OracleClient.OracleConnection.Open()
1: at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
1: at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetWrappedConnection()
1: at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
1: at USG.LinX.PrintAndApply.DataObjects.OracleDataProvider.LogEvent(String msg, String MessageType, String OrgCode, Nullable`1 LineNumber, Char LegLetter, Nullable`1 StackerNumber, String ServerName) in C:\Visual Studio 2013\Projects\PrintAndApply\DataObjects\OracleDataProvider.vb:line 984
1: at USG.LinX.PrintAndApply.Utilities.EventLogger.LogEvent() in C:\Visual Studio 2013\Projects\PrintAndApply\Utilities\EventLogger.vb:line 62
1: at USG.LinX.PrintAndApply.Utilities.AppEvents.Log(String msg, EventType EventType, String OrgCode, Int32 LineNumber, Char Leg, Int32 StackerNumber) in C:\Users\PKonstant\Documents\Visual Studio 2013\Projects\PrintAndApply\Utilities\AppEvents.vb:line 38
1: at USG.LinX.PrintAndApply.BusinessObjects.BLineReader.Run() in C:\Visual Studio 2013\Projects\PrintAndApply\BusinessObjects\Service\BLineReader.vb:line 821
1: at USG.LinX.PrintAndApply.BusinessObjects.BLineReader.StartProcessingCore() in C:\Visual Studio 2013\Projects\PrintAndApply\BusinessObjects\Service\BLineReader.vb:line 139
Exception Level 1: Target Site:Void .ctor(System.Data.OracleClient.OciHandle, HTYPE, MODE, HANDLEFLAG)
Event Viewer has the following:
Faulting application printandapply.exe, version 1.0.0.0, stamp 53c81478, faulting module oraociei12.dll, version 12.1.0.0, stamp 51cfc80d, debug? 0, fault address 0x00bd768c.
I am using Visual Studio 2013 with the Oracle Developer Tools for Visual Studio (12.1.0.1.2) libraries. Any help would be surely appreciated.
Many Thanks
Peter