Return
-
Title
ORA-02396: exceeded maximum idle time, please connect again -
Description
Workflows using Oracle connector are failing with the following error message:
The specified SQL Server instance cannot be contacted.
Details: ORA-02396: exceeded maximum idle time, please connect again ---> Oracle.DataAccess.Client.OracleException ORA-02396: exceeded maximum idle time, please connect again.
-
Cause
Oracle connection times out after 15 minutes. Quick Connect is unable to re-establish the connection until Quick Connect service is restarted. -
Resolution
Add a custom parameter to the Oracle connection string as follows:
- In Quick Connect Administration Conosle, navigate to the Oracle connection properties
- Under Oracle connection properties select Advanced Properties
- Add a new parameter named VALIDATE CONNECTION
- Set the parameter value to true
-
Change Request
TF00203091 -
Additional Information
Full error message recorded in QuickConnectServerHost.log: Debug --> Workflow step execution failed! Quest.QuickConnect.Server.Execution.WorkflowExecution.WorkflowStepExecutor.Execute System.ApplicationException: The specified SQL Server instance cannot be contacted. Details: ORA-02396: exceeded maximum idle time, please connect again ---> Oracle.DataAccess.Client.OracleException ORA-02396: exceeded maximum idle time, please connect again at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.GetSQLSchema(SelectQueryContainer query) at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.SetQuery(SelectQueryContainer query) at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.Connect(IConnectionParameterCollection connectionParameters) --- End of inner exception stack trace --- at Quest.QuickConnect.Connectors.DBConnectorBase.DBConnector.Connect(IConnectionParameterCollection connectionParameters) at Quest.QuickConnect.Server.QcConnector.Connect(IConnectionParameterCollection connectionParameters) at Quest.QuickConnect.Server.Execution.ConnectedConnectorsCache.CreateConnector(Connection connection, QcConnectorInfo connectorConfig) at Quest.QuickConnect.Server.Execution.ThreadSafeCache`2.AddItem(T