AAOP in tomcat 6 'Unable to connect to the DB connection for the image service'<DATASTORE_ERROR ' Unable to get DB connection>'
Originally Published: 2011-07-18
Article Number
Applies To
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>
Issue
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>
Notes
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)
Related Articles
v7.0.0 installation fails during configuring wildfly Failed to set session cookie. Error message - Unable to connect to co… Number of Views Error: 'Error running sdrepmgmt. Unable to connect to database. A replica management session may already be running. Only … Number of Views Access Manager is unable to connect to Active Directory even after expired Domain Controller certificate is replaced Number of Views How to connect to SQL in RSA Authentication Manager 8.x Number of Views RSA SecurID Authenticator 4.2 for iOS and Android Quick Start Guide (Italian) Number of Views
Trending Articles
RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA Announces the Release of RSA MFA Agent 2.5 for Microsoft Windows RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to generate a PASSCODE for manual entry on a Ericsson R380 WAP phone
Don't see what you're looking for?
