Using the .net core version of Invantive Data Hub 22.0.664, but also on the .net framework version, I am getting intermittent Oracle errors when connecting:
The data container with alias ‘ora’ could not be opened on provider ‘OracleManaged’.
ORA-12537: Network Session: End of file.
OracleInternal.Network.NetworkException
Oracle.ManagedDataAccess.Client.OracleException
ValidationException
ValidationException
at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
Exception during boot: Invantive.Basics.ValidationException: itgendhb005: Could not connect to database ‘L120\invoicing3’. Application will be closed.
at Invantive.Basics.ValidationException…ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String url)
at Invantive.Producer.Data.Hub.QueryEngine.Run(String arguments)
at Invantive.Producer.Data.Hub.Program.Main(String args)
at Invantive.Producer.Data.Hub.QueryEngine.Run(String arguments)
The error code is itgenclr130
.
Typically, the connection will succeed when trying again. When the problem persists, rebooting the Oracle database helps.
The Oracle database is Oracle Standard Edition Two version 19.0.0 (2023-04) with 2 GB of memory allocated and few concurrent users.