000034408 - Adaptive Authentication (On Premise) 7.1 customer seeing "Cannot open connection" error in aa.scheduler.log file

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

Article Content

Article Number000034408
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.1
 
IssueAn AAOP customer noticed the following error in their aa.scheduler.log:
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; 
uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; [tomcat-http--235] Timeout:
Pool empty. Unable to fetch a connection in 10 seconds, none available[size:100; busy:100; idle:0;
lastwait:10000].; nested exception is org.apache.tomcat.jdbc.pool.PoolExhaustedException: [tomcat-http--235]
Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[size:100; busy:100; idle:0;
lastwait:10000].



 
CauseAn examination of their server.xml revealed the customer was using the following:
 
auth="Container" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" 
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" testOnBorrow="true"
validationQuery="SELECT 1" validationInterval="30000" suspectTimeout="60" logAbandoned="false"
maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/PassMarkDB"

 
 
ResolutionThis issue was resolved by changing the factory setting in the server.xml.
The configuration should be changed so that this:
 
factory=org.apache.tomcat.jdbc.pool.DataSourceFactory
is replaced with this:

factory=org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory

Attachments

    Outcomes