Roll-backs in JBoss Lead to Exceptions: DirectDB/getConnection encounter some problems (Doc ID 1097926.1)

Last updated on MARCH 08, 2017

Applies to:

Identity Manager - Version 9.1.0.1 to 9.1.0.2
Information in this document applies to any platform.
**Checked for Relevance on 03-Jan-2014**

Symptoms

On :  9.1.0.1 version, Reconciliation

When attempting to run a target or trusted reconciliation and some error is injected, such as a required field having no data, the OIM code rolls back the transaction and within the same rolled back transaction tries to get a DB connection to query the ERR table which will never take place because the app server will not permit the connection in the transaction being rolled back. This leads to many unneeded errors in the logs and the query against the ERR and other tables is never successful so there is no further information on the original error. The following errors occur.

 
ERROR
-----------------------
2010-04-05 01:45:16,142 ERROR [XELLERATE.JMS] An error occurred while processing the off lined reconciliation events
2010-04-05 01:45:16,142 ERROR [XELLERATE.JMS] Processing Reconciliation Message with ID 8825510 failed.
2010-04-05 01:45:16,325 ERROR [XELLERATE.SERVER] Class/Method: tcOrderItemInfo/eventPreInsert Error :
Data object process form required data is missing.
2010-04-05 01:45:16,328 ERROR [XELLERATE.SERVER] Class/Method: tcDataObj/save Error :
Insertion of dataobject into database failed
2010-04-05 01:45:16,330 ERROR [XELLERATE.SERVER] Class/Method: tcOrderItemInfo/eventPreInsert Error :
Data object process form required data is missing.
2010-04-05 01:45:16,331 ERROR [XELLERATE.DATABASE] Class/Method: tcDataBase/rollbackTransaction encounter some problems:
Rollback Executed From
java.lang.Exception: Rollback Executed From
      at com.thortech.xl.dataaccess.tcDataBase.rollbackTransaction(Unknown Source)
      at com.thortech.xl.dataobj.tcDataObj.rollback(Unknown Source)
...
       at com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
...
2010-04-05 01:45:16,333 ERROR [XELLERATE.SERVER] Class/Method: tcRCE/linkToUser Error :
Failed to reconcile provision object for user.
2010-04-05 01:45:16,334 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 0
...
2010-04-05 01:45:16,339 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 4
2010-04-05 01:45:16,339 ERROR [XELLERATE.DATABASE] 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.
2010-04-05 01:45:16,339 ERROR [XELLERATE.DATABASE] Class/Method: tcDataBase/readPartialStatement encounter some problems:
Got a null connection
java.sql.SQLException: Got a null connection
       at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
...
       at com.thortech.xl.dataobj.tcDataBase.getError(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.handleError(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.handleError(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
...
2010-04-05 01:45:16,343 ERROR [XELLERATE.SERVER] Class/Method: tcDataObj/handleError encounter some problems: {1}
com.thortech.xl.orb.dataaccess.tcDataAccessException
       at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)
...
Caused by [Nested Exception]:
java.sql.SQLException: Got a null connection
       at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.readStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.getError(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.handleError(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.handleError(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
...
2010-04-05 01:45:16,345 ERROR [XELLERATE.DATABASE] Error: Error Keyword: DAE.DB_READ_FAILED
Description: Could not execute database read.  The database encountered a problem with the specified SQL query.
Remedy: Check the database query. Contact your system adminstrator.
Action: E
Severity: H
Help URL:
Detail:
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.GEN_ERROR'
Description: Got a null connectionSQL State: Vendor Code: 0
Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException
       at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)
       at com.thortech.xl.dataaccess.tcDataBase.createException(Unknown Source)
...
Source SQL Exception:
java.sql.SQLException: Got a null connection
       at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.readStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.getError(Unknown Source)
...
2010-04-05 01:45:16,349 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 0
2010-04-05 01:45:16,350 ERROR [XELLERATE.SERVER] Class/Method: tcDataObj/save Error :
Insertion of dataobject into database failed
2010-04-05 01:45:16,350 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 1
2010-04-05 01:45:16,352 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 2
2010-04-05 01:45:16,353 ERROR [XELLERATE.DATABASE] Class/Method: tcDataBase/rollbackTransaction encounter some problems:
Rollback Executed From
java.lang.Exception: Rollback Executed From
       at com.thortech.xl.dataaccess.tcDataBase.rollbackTransaction(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.rollback(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.doRollback(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
       at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.insertProcessData(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.provisionObject(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
...
2010-04-05 01:45:16,353 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 3
2010-04-05 01:45:16,354 ERROR [XELLERATE.SERVER] Class/Method: tcRCE/linkToUser Error :
Failed to reconcile provision object for user.
2010-04-05 01:45:16,355 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 4
2010-04-05 01:45:16,355 ERROR [XELLERATE.DATABASE] 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.
2010-04-05 01:45:16,356 ERROR [XELLERATE.DATABASE] Class/Method: tcDataBase/readPartialStatement encounter some problems:
Got a null connection
java.sql.SQLException: Got a null connection
       at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
       at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.cache.CacheUtil.getSetCachedQuery(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
       at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.finishDataReceived(Unknown Source)
...
2010-04-05 01:45:16,357 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 0
2010-04-05 01:45:16,358 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 1
2010-04-05 01:45:16,360 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 2
2010-04-05 01:45:16,360 ERROR [XELLERATE.SERVER] Class/Method: tcDataObj/eventPostUpdate encounter some problems:
Data Access Error
com.thortech.xl.dataaccess.tcDataSetException: Data Access Error
       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
       at com.thortech.xl.cache.CacheUtil.getSetCachedQuery(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
...
Data AccessException:
com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL:
select evt.evt_key, evt.evt_name, evt.evt_package from dob dob, evt evt, dvt dvt
 where dob.dob_key=dvt.dob_key and dvt.evt_key=evt.evt_key and
 (dob.dob_name='com.thortech.xl.dataobj.tcRCE' or dob.dob_name='com.thortech.xl.dataobj.tcTableDataObj'
or dob.dob_name='com.thortech.xl.dataobj.tcDataObj' )
  and dvt.dvt_post_update_sequence>0 order by dvt.dvt_post_update_sequence
Description: Got a null connectionSQL State: Vendor Code: 0
Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException
       at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)
...
       at com.thortech.xl.dataobj.tcDataObj.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
       at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
...
Source SQL Exception:
java.sql.SQLException: Got a null connection
...
2010-04-05 01:45:16,361 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 3
2010-04-05 01:45:16,363 WARN  [XELLERATE.DATABASE] Trying to get the connection count : 4
2010-04-05 01:45:16,363 ERROR [XELLERATE.DATABASE] 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.
...
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms