000030757 - How to increase max-pool-size for Workpoint data source (WPDS) in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support on Jun 7, 2019
Version 6Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000030757
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9.x (JBoss), 7.x (WildFly)
 
IssueThe max-pool-size connection setting for the Workpoint data source (WPDS) may be set to 90, which is too low for heavy workflow usage. Engineering recommends a minimum setting of 150.

Examples of errors that indicate connections need to be increased are as follows:
 
  1. These errors are often noticed in the server.log if login attempts fail.


==========
2010-06-04 18:02:31,731 ERROR [org.hibernate.util.JDBCExceptionReporter]
No ManagedConnections available within configured blocking timeout ( 10000 [ms] ); -
nested throwable: (javax.resource.ResourceException:
No ManagedConnections available within configured blocking timeout ( 10000 [ms] ))
==========

 

  1. In the Workpoint.log the following messages may show:


==========
2010-06-04 18:57:44,238 ERROR [STDERR]
Jun 4, 2010 6:57:44 PM com.aveksa.gui.pages.portlet.myTasks.data.MyTasksStore getMyTasksCount

SEVERE:
com.aveksa.server.workflow.WorkflowServiceException:
com.aveksa.server.db.PersistenceException:
org.hibernate.exception.GenericJDBCException: Cannot open connection
at com.aveksa.server.workflow.WorkflowServiceProvider.getWorkflowWorkItemsCount(WorkflowServiceProvider.java:2092)
==========


 
Tasks

JBoss steps (RSA Identity GOvernance & Lifecyckle 6.x


In order to increase this setting to 150, modify aveksa-ds.xml as follows:

  1. Shutdown the acm:


$ acm stop


  1. As the oracle user, edit the aveksa-ds.xml


$ cd /home/oracle/jboss/server/default/deploy
$ vi aveksa-ds.xml


  1. Change <max-pool-size>90</max-pool-size> to <max-pool-size>150</max-pool-size>:User-added image
  2. Start acm


$ acm start

 

WildFly steps (RSA Identity Governance & Lifecycle 7.0+)



  1. Shutdown acm


$ acm stop


  1. As the oracle user, edit the aveksa-standalone-full.xml


$ cd home/oracle/wildfly/standalone/configuration/aveksa-standalone-full.xml
$ vi aveksa-ds.xml


  1. Change <max-pool-size>90</max-pool-size> to <max-pool-size>150</max-pool-size>:


                <xa-datasource jndi-name="java:/jdbc/WPDS" pool-name="WPDS" enabled="true" use-java-context="true" use-ccm="true">
                    <xa-datasource-property name="URL">
                        jdbc:oracle:thin:@//localhost:1555/AVDB
                    </xa-datasource-property>
                    <driver>OracleXADriver</driver>
                    <xa-pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>150</max-pool-size>


  1. Start acm


$ acm start
ResolutionOn a system with heavy workflow usage, this value may need to be increased above 150.

 

Attachments

    Outcomes