Hi
Over the weekend one on our ODX jobs failed with the following error;
Executing table [PRODDTA].[F0101]:
failed with error:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-50000: Connection request timed out
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPassw, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch, Boolean bAsync)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassw, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch, Boolean bAsync)
at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, OracleOpaqueString securedPassw, OracleOpaqueString securedProxyPassw, OracleConnection connRefForCriteria, Boolean bAsync)
at Oracle.ManagedDataAccess.Client.OracleConnectionInternal.OpenInternal(Boolean bAsync)
at Oracle.ManagedDataAccess.Client.OracleConnectionInternal.Open()
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
at DataStorageEngine.SQL.SQLHelper.<>c__DisplayClass38_0.<TransferWithBulkCopy>b__0(IDbConnection con)
at DataStorageEngine.SQL.SQLHelper.ApplyUsing[T](T disposable, Boolean dispose, Action`1 action)
at DataStorageEngine.SQL.SQLHelper.TransferWithBulkCopy(SqlDatabaseEndpoint storageEndpoint, IDbCommand destinationCommand, String destinationTableName, IEnumerable`1 columnModels, IDbCommand sourceTransferCommand, DataTable transferTable, String[] queries, Boolean disposeSourceObjects)
at DataStorageEngine.SQL.SQLStorageEngine.<>c__DisplayClass60_1.<TransferDataToTable>b__3(IDbCommand sourceCommand, String[] queries, Boolean disposeSourceObjects)
at DataStorageEngine.SQL.SQLStorageEngine.<>c__DisplayClass60_0.<TransferDataToTable>b__1(IDbCommand destinationCommand)
at DataStorageEngine.SQL.SQLStorageExtensions.ExecuteCommand(IDbConnection connection, Int32 commandTimeout, Action`1 action)
at DataStorageEngine.SQL.SQLStorageEngine.<>c__DisplayClass57_5.<TransferData>b__9(SQLExecutionMethod executionMethod)
at DataSourceEngine.Custom.CustomSourceEngine.InvokeDataSourceExecution(Action`1 action)
at DataSourceEngine.Custom.CustomSourceEngine.RunExecution[M](DataExecutionDestination dataExecutionMethod, Action`1 action)
at DataStorageEngine.SQL.SQLStorageEngine.<>c__DisplayClass57_3.<TransferData>b__6()
Having spent a little bit of time investigating this one of the recommendations has been to check the [connection timeout] value of the connection. Having had a look on the TX portal I cannot see a setting for this so presumably it is something that needs to be set as an ‘Additional Property’.
Does anyone know the correct name value to use to set this property so I can override whatever the default value is to something larger?
Regards