Error during Bulk Load : DB_READ_FAILED com.thortech.xl.orb.dataaccess.tcDataAccessException (Doc ID 1436323.1)

Last updated on JULY 12, 2021

Applies to:

Symptoms

SQL connection errors happening during bulk load operations.

com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: select err_key, err_code, err_desc, err_rowver, err_remedy, err_count, err_last_occurance, err_action, err_help_url, err_severity from err where err_code='DOBJ.INITIAL_SELECT_FAILED'Description: Got a null connectionSQL State: Vendor Code: 0Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException
at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(tcDataAccessExceptionUtil.java:81)
at com.thortech.xl.dataaccess.tcDataBase.createException(tcDataBase.java:3171)
at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:743)

[ERROR] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '44' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <INTERNAL_USER>] [ecid: <ECID>] [APP: oim#11.1.1.3.0] Class/Method: DirectDB/getConnection encounter some problems: Error while retrieving database connection.Please check for the follwoing[[
Database srever is running.
Datasource configuration settings are correct. java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 600 seconds
BEA1-<TRANSACTION_ID>
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1616)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSour

DB configured in RAC mode.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.