000035407 - RSA Adaptive Authentication (on Premise) 7.3 - Offline tasks get stuck when using JBoss 6.4 application server

Document created by RSA Customer Support Employee on Jul 28, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035407
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.3
 
IssueCustomer reported that they see the below error when offline tasks executes and because of these errors offline tasks never completes which impacts risk calculations and database maintenance activities.
 
ERROR [com.rsa.db.direct.CTrxMgrJDBCImpl] Could not connect to database. java.sql.SQLException: javax.resource.ResourceException: IJ000453: 
Unable to get managed connection for java:/jdbc/PassMarkDB
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151)
at com.rsa.db.direct.CConnectionManager.openConnection(CConnectionManager.java:209)
at com.rsa.db.direct.CTrxMgrJDBCImpl.startTrxImpl(CTrxMgrJDBCImpl.java:26)
at com.rsa.db.CTrxMgr.startTrx(CTrxMgr.java:56)
at com.rsa.re.offlinetasks.tasks.normalization.strategy.buildAggregation.impl.BuildEventPreNormScores.run(BuildEventPreNormScores.java:127)
at com.rsa.tools.external.jboss.workmanager.connector.ReJBossWorkManager$WorkWrapper.run(ReJBossWorkManager.java:218)
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808)
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:828)
at java.lang.Thread.run(Thread.java:745)
at org.jboss.threads.JBossThread.run(JBossThread.java:122) Caused by: javax.resource.ResourceException: IJ000453:
Unable to get managed connection for java:/jdbc/PassMarkDB
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:410)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:367) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143) I recommended the below changes based upon JIRA


 
CauseCRE OfflinetasksThreadPool configuration specifically for JBoss 6.4 application server was not set to the recommended value.
 
ResolutionPlease change the OfflinetasksThreadPool configuration in JBoss standalone.xml as below:
<workmanager name="OfflinetaskThreadPool">
< short-running-threads allow-core-timeout="false">
< core-threads count="50"/>
< queue-length count="7000"/>
< max-threads count="100"/> 
< keepalive-time time="20000" unit="milliseconds"/> 
< /short-running-threads>
< /workmanager>

Attachments

    Outcomes