Expression queue execution leads to latency on PostgreSQL database in Rational Focal Point

Technote (troubleshooting)


Attempts to execute the expression queue with large number expressions leads to latency on the PostgreSQL database in IBM Rational Focal Point.


Latency being observed during the execution of expression queue.


You might notice the reported problem during one of the following operations:

Cause 1: Importing a new workspace from template

Cause 2: Importing elements

Cause 3: Database execution plans not adapting to the changed expression queue load

Resolving the problem

In order to resolve the reported problem; apply the steps below:

  1. Stop Tomcat server

  2. Navigate to <Tomcat Home>/conf

  3. Open the server.xml file in edit mode

  4. Change the value of the entry maxActive to 30 in the following section

    <Resource connectionProperties="SetBigStringTryClob=true;deferPrepares=false" defaultAutoCommit="true" driverClassName="org.postgresql.Driver" factory="org.apache.commons.dbcp.BasicDataSourceFactory"  maxActive="10" maxIdle="30" maxWait="60000" name="jdbc/focalpoint" password="xxxx" type="javax.sql.DataSource" url="jdbc:postgresql://" username="postgres"/>

  5. Save and close the file

  6. Increase the Java Virtual Memory [JVM] by 1 GB

  7. Launch PostgreSQL database and execute the following commands:

    • vacuumdb -f -h localhost <dbname>

  8. Once done, start Tomcat server

Document information

More support for:

Rational Focal Point
General Information

Software version:

6.5,,, 6.5.1

Operating system(s):

Linux, Solaris, Windows

Reference #:


Modified date:


Translate my page

Content navigation