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

Last updated on APRIL 08, 2018

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)

[2012-02-24T01:37:55.018-06:00] [oim11g_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '44' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 0000JMdP^8xEGR0prw5EiY1FHVpy000002,0] [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-39A47B299E536E81C759
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1616)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSour

DB configured in RAC mode.

Cause