000026412 - AAOP in tomcat 6 'Unable to connect to the DB connection for the image service'<DATASTORE_ERROR ' Unable to get DB connection>'

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000026412
Applies To6.0.21 sp2 p1 and tomcat 6.

The following error occurs in the aa_server_admin.log

2011-07-18 07:14:02,890 -0700 ERROR - <DATASTORE_ERROR | Unable to get DB connection>

IssueA datasource needs to be correctly defined in the config file AdaptiveAuthenticationAdmin_with_image_service.xml
Resolution

Ensure that the config file contain the correct datasource in the tomcat configuration tree

conf\catalina\localhost\AdaptiveAuthenticationAdmin_with_image_service.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context antiResourceLocking="true" docBase="AdaptiveAuthenticationAdmin" path="/AdaptiveAuthenticationAdmin" reloadable="true" workDir="work\Catalina\localhost\AdaptiveAuthenticationAdmin">
 <ResourceLink global="jdbc/PassMarkDB" name="jdbc/PassMarkDB" type="javax.sql.DataSource"/>
</Context>

Notesconnection>
java.sql.SQLException: Io exception: The Network Adapter could not establish the connectionDSRA0010E: SQL State = null, Error Code = 17,002
 at java.lang.Throwable.<init>(Throwable.java:57)
 at java.lang.Throwable.<init>(Throwable.java:68)
 at java.sql.SQLException.<init>(SQLException.java:55)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
 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.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:157)
 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:94)
 at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:75)
 at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
 at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
 at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
 at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1180)
 at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
 at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1750)
 at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1517)
 at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2141)
 at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:843)
 at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:582)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
 at com.passmarksecurity.dao.util.DBConnectionFactory.getConnection(DBConnectionFactory.java:41)
 at com.rsa.csd.dao.sp.SessionStoredProcBase.cleanup(SessionStoredProcBase.java:233)
 at com.passmarksecurity.impl.PassMarkSessionMgrImpl.reapPersistentSessions(PassMarkSessionMgrImpl.java:1039)
 at com.passmarksecurity.impl.PassMarkSessionMgrImpl$SessionPersistenceReaperTask.run(PassMarkSessionMgrImpl.java:90)
 at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
 at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
 at java.lang.Thread.run(Thread.java:797)
2011-02-15 07:22:00,483 ERROR [pool-2-thread-2] [] [] [com.rsa.csd.dao.sp.SessionStoredProcBase] - <Caught SQL exception:  SessionStoredProcBase.cleanUp ; Throwing PassMark DatabaseException>
com.passmarksecurity.PassMarkException: Unable to get DB connection
 at com.passmarksecurity.dao.util.DBConnectionFactory.getConnection(DBConnectionFactory.java:54)
 at com.rsa.csd.dao.sp.SessionStoredProcBase.cleanup(SessionStoredProcBase.java:233)
 at com.passmarksecurity.impl.PassMarkSessionMgrImpl.reapPersistentSessions(PassMarkSessionMgrImpl.java:1039)
 at com.passmarksecurity.impl.PassMarkSessionMgrImpl$SessionPersistenceReaperTask.run(PassMarkSessionMgrImpl.java:90)
 at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
 at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
 at java.lang.Thread.run(Thread.java:797)
2011-02-15 07:22:00,499 ERROR [pool-2-thread-2] [] [] [com.passmarksecurity.impl.PassMarkSessionMgrImpl] - <Exception while reaping persistent sessions; reaping time-out is 3600>
com.passmarksecurity.PassMarkException$DatabaseException: class com.passmarksecurity.PassMarkException$DatabaseException:SessionStoredProcBase.cleanUp Failed com.passmarksecurity.PassMarkException: Unable to get DB connection
 at com.rsa.csd.dao.sp.SessionStoredProcBase.cleanup(SessionStoredProcBase.java:264)
 at com.passmarksecurity.impl.PassMarkSessionMgrImpl.reapPersistentSessions(PassMarkSessionMgrImpl.java:1039)
 at com.passmarksecurity.impl.PassMarkSessionMgrImpl$SessionPersistenceReaperTask.run(PassMarkSessionMgrImpl.java:90)
 at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
 at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
 at java.lang.Thread.run(Thread.java:797)
Legacy Article IDa55382

Attachments

    Outcomes