Web Verifier Error "The underlying provider failed on Open. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater"
(Doc ID 2963583.1)
Last updated on JULY 26, 2023
Applies to:
Oracle WebCenter Forms Recognition - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12c]Information in this document applies to any platform.
Symptoms
Accessing WebVerifier is throwing below exception:
Web Verifier Client Error
An error has occurred in the Web Verifier Client. Retry operation in a few minutes or contact your administrator.
An error has occurred in the Web Verifier Client. Retry operation in a few minutes or contact your administrator.
When attempting to test the Oracle Provider for OLE DB on the Windows box the following error is returned:
Provider is no longer available. ensure that the provider is installed properly.
The trace.log shows error:
2023-06-19 02:05:09,887 [19] ERROR Brainware.Verifier.WebClient.Global [(null)] - The underlying provider failed on Open.
[PID=7296|UID=?|MEM PH/V=56,484k/757,828k|MEM_ALL_PH OCC/AV=0k/4,194,303k|MEM_ALL_V OCC/AV=796,744k/3,397,432k|HNDL=539]
System.Data.EntityException: The underlying provider failed on Open. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
at System.Data.OracleClient.OCI.DetermineClientVersion()
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 EFOracleProvider.EFOracleConnection.Open() in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\EFOracleProvider\EFOracleConnection.cs:line 147
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.<>c__11`1.b__11_1(IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
at Brainware.System.DAL.DA.ModuleTypeDA.GetByName(String moduleTypeName) in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\System.DAL\DA\ModuleTypeDA.cs:line 27
at Brainware.System.Controllers.Module.ModuleController.SetModuleTyepId(String moduleTypeName, Boolean ignoreIfAlreadySet) in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\System.Controllers\Module\ModuleController.cs:line 124
at Brainware.System.Controllers.Module.ModuleController.get_CurrentModuleId() in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\System.Controllers\Module\ModuleController.cs:line 45
at Brainware.Verifier.WebClient.Global.Application_End(Object sender, EventArgs e) in c:\Jenkins\workspace\V5.9_Build\Cedar\dNET\rel\src\Verifier.WebClient\Global.asax.cs:line 223
[END APPLICATION AT 2023-06-19 02:05:10,172]
[START APPLICATION AT 2023-06-19 02:05:39,223]
[PID=7296|UID=?|MEM PH/V=56,484k/757,828k|MEM_ALL_PH OCC/AV=0k/4,194,303k|MEM_ALL_V OCC/AV=796,744k/3,397,432k|HNDL=539]
System.Data.EntityException: The underlying provider failed on Open. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
at System.Data.OracleClient.OCI.DetermineClientVersion()
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 EFOracleProvider.EFOracleConnection.Open() in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\EFOracleProvider\EFOracleConnection.cs:line 147
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.<>c__11`1.b__11_1(IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
at Brainware.System.DAL.DA.ModuleTypeDA.GetByName(String moduleTypeName) in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\System.DAL\DA\ModuleTypeDA.cs:line 27
at Brainware.System.Controllers.Module.ModuleController.SetModuleTyepId(String moduleTypeName, Boolean ignoreIfAlreadySet) in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\System.Controllers\Module\ModuleController.cs:line 124
at Brainware.System.Controllers.Module.ModuleController.get_CurrentModuleId() in c:\Jenkins\workspace\Build\Cedar\dNET\rel\src\System.Controllers\Module\ModuleController.cs:line 45
at Brainware.Verifier.WebClient.Global.Application_End(Object sender, EventArgs e) in c:\Jenkins\workspace\V5.9_Build\Cedar\dNET\rel\src\Verifier.WebClient\Global.asax.cs:line 223
[END APPLICATION AT 2023-06-19 02:05:10,172]
[START APPLICATION AT 2023-06-19 02:05:39,223]
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |