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
Last Modified: 2023-10-06
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
Unable to get value for field SRCID when running custom report in RSA Identity Governance & Lifecycle Number of Views RSA Authentication Manager 8.6 VMware Virtual Appliance Getting Started Number of Views RSA Authentication Manager 8.7 SP2 Hardware Appliance Getting Started Number of Views Segregation of Duties (SOD) Rule fails with error 'ORA-30926: unable to get a stable set of rows in the source tables' err… Number of Views Invalid filename message when uploading an attachment to a Request Form in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
