Wednesday, September 17, 2014

[Exception_BatchController_ExceptionCount:] CDKBC2006E:Exception occurred: count = 2; processorID = ParseAndExecuteConsumer; messageID = 0;

While running batch file getting this error.


ERROR     - [Exception_BatchController_ExceptionCount:] CDKBC2006E:Exception occ                                                                                        urred: count = 1; processorID = ParseAndExecuteConsumer; messageID = 1; addition                                                                                        al error message = null
DEBUG     - starting Processor.checkQueue: , inQueue size = 1, idleQueue size =                                                                                         8
DEBUG     - WriterConsumer >>> 1
Faulty record: 1
ERROR     - [Exception_BatchController_ExceptionCount:] CDKBC2006E:Exception occ                                                                                        urred: count = 2; processorID = ParseAndExecuteConsumer; messageID = 0; addition                                                                                        al error message = null
DEBUG     - starting Processor.checkQueue: , inQueue size = 1, idleQueue size =                                                                                         8
DEBUG     - WriterConsumer >>> 0
Faulty record: 2
--
Probable Cause:
Could be database connectivity issue. Check Customer.logs & SystemOut.logs
In my case it was also com.ibm.ws.Transaction.XAResourceNotAvailableException:
So resolved by :
clear the trans logs of Websphere Application Server and restart the same.

Reference used:
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.wsadapters602.jca_ff.doc/shared/csha_tro_tranlog.html

----
Customer.logs
2014-09-17 14:34:35,417 [ORB.thread.pool : 3] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,417 [ORB.thread.pool : 3] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,417 [ORB.thread.pool : 3] WARN  com.dwl.base.util.DWLClassFactory - [Error_Common_NoClass:] CDKCS0008E:The following class cannot be created. Class = DWLErrorMessageComponent
2014-09-17 14:34:35,419 [ORB.thread.pool : 3] ERROR com.dwl.management.config.repository.database.RepositoryImpl - Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,419 [ORB.thread.pool : 3] INFO  com.dwl.management.config.cache.CacheFactory - Couldn't get the cache from CacheManager :ApplicationCache
com.ibm.mdm.cache.common.CacheLoaderException: CacheLoader Exception in getCache: java.lang.RuntimeException: com.dwl.management.config.repository.RepositoryStoreException: [Exception_RepositoryImpl_CreateConnectionFailed:] CDKCR2019E:A failure occurred while trying to create a connection to the configuration repository database.
2014-09-17 14:34:35,421 [ORB.thread.pool : 1] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,421 [ORB.thread.pool : 1] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,421 [ORB.thread.pool : 1] WARN  com.dwl.base.util.DWLClassFactory - [Error_Common_NoClass:] CDKCS0008E:The following class cannot be created. Class = DWLErrorMessageComponent
2014-09-17 14:34:35,424 [ORB.thread.pool : 0] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,425 [ORB.thread.pool : 0] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,425 [ORB.thread.pool : 0] WARN  com.dwl.base.util.DWLClassFactory - [Error_Common_NoClass:] CDKCS0008E:The following class cannot be created. Class = DWLErrorMessageComponent
2014-09-17 14:34:35,425 [ORB.thread.pool : 3] ERROR com.dwl.management.config.repository.database.RepositoryImpl - Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,425 [ORB.thread.pool : 3] INFO  com.dwl.management.config.cache.CacheFactory - Couldn't get the cache from CacheManager :ApplicationCache
com.ibm.mdm.cache.common.CacheLoaderException: CacheLoader Exception in getCache: java.lang.RuntimeException: com.dwl.management.config.repository.RepositoryStoreException: [Exception_RepositoryImpl_CreateConnectionFailed:] CDKCR2019E:A failure occurred while trying to create a connection to the configuration repository database.
2014-09-17 14:34:35,427 [ORB.thread.pool : 3] ERROR com.dwl.management.config.repository.database.RepositoryImpl - Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myclient)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
2014-09-17 14:34:35,429 [ORB.thread.pool : 3] ERROR com.dwl.base.db.DataManager - [pdq][10003][2.1.7500] pureQuery could not connect to the database.;  Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:

SystemOut.log
recoveryClasspath = /opt/IBM/WAS/wasadmin1/app/WebSphere/AppServer/lib/rsadapter.rar:/opt/IBM/WAS/wasadmin1/app/WebSphere/AppServer/lib/rsadapter.rar:/opt/IBM/WAS/wasadmin1/app/oracle/product/11.2.0/db11g/jdbc/lib/ojdbc14.jar
raKey = cells/oat/clusters/mdmb01/resources.xml#builtin_rra
. The exception stack trace follows: com.ibm.ws.Transaction.XAResourceNotAvailableException: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA8100E: Unable to get a XAConnection from the DataSource.
at com.ibm.ejs.j2c.J2CXAResourceFactory.getXAResource(J2CXAResourceFactory.java:413)
at com.ibm.ws.Transaction.JTA.XARecoveryData.getXARminst(XARecoveryData.java:446)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:573)
at com.ibm.tx.jta.PartnerLogTable.recover(PartnerLogTable.java:389)
at com.ibm.tx.jta.RecoveryManager.resync(RecoveryManager.java:1530)
at com.ibm.tx.jta.RecoveryManager.performResync(RecoveryManager.java:2265)
at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:114)
at com.ibm.tx.jta.RecoveryManager.run(RecoveryManager.java:2218)
at java.lang.Thread.run(Thread.java:738)
Caused by: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA8100E: Unable to get a XAConnection from the DataSource.
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:444)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1324)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2471)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1639)
at com.ibm.ejs.j2c.J2CXAResourceFactory$1.run(J2CXAResourceFactory.java:380)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ejs.j2c.J2CXAResourceFactory.getXAResource(J2CXAResourceFactory.java:190)
... 8 more
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=191t.wload.myClients.co.uk)(PORT=7777))(CONNECT_DATA = (SERVICE_NAME = CDI.wload.myClients.co.uk)(METHOD=BASIC)(RETRIES=180)(DELAY=10)))
DSRA0010E: SQL State = null, Error Code = 0
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:472)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:159)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:133)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1275)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1312)
... 13 more


No comments:

Post a Comment