IBM Support

SOAR: No active JTA transaction on join transaction call

Troubleshooting


Problem

Seeing JTA Transaction message-related errors "No active JTA transaction on joinTransaction call", and performance decreased. There are more than 50 threads that need database connections than the number of default JTA transactions of 50.

Symptom

In addition to error "No active JTA transaction on joinTransaction call", there are more than 50 threads that need database connections then the number of default JTA transactions of 50. 
09:20:07.683 [QuartzScheduler_Co3Scheduler-NON_CLUSTERED_MisfireHandler] INFO  o.q.impl.jdbcjobstore.JobStoreTX - Handling 4 trigger(s) that missed their scheduled fire-time.
09:20:09.252 [Action ack handler] ERROR c.co3.context.DefaultCo3ContextImpl - Unable to establish context
javax.persistence.TransactionRequiredException: No active JTA transaction on joinTransaction call
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:1605)
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:1568)
 at com.co3.jta.JtaTransactionImpl.doBeginOrJoinTransaction(JtaTransactionImpl.java:226)
 at com.co3.jta.JtaTransactionImpl.startTransaction(JtaTransactionImpl.java:48)

Cause

By default the default values are 50.

Resolving The Problem

To fix the issue, increase the JTA transactions to 100 to be more than the number of threads:
Note: An upgrade reverts these changes.
  1. Backup SOAR
  2. Back up the JTA properties file: 
    sudo cp -p /usr/share/co3/conf/jta.properties /usr/share/co3/conf/jta.properties.20190513
  3. Edit the JTA properties and increase the transactions to 100: 
    sudo vi /usr/share/co3/conf/jta.properties
    Look for line with "max_actives" and change to 100: 
    com.atomikos.icatch.max_actives = 100
  4. Back up the database configuration file: 
    sudo cp -p /var/lib/pgsql/9.6/data/postgresql.conf /var/lib/pgsql/9.6/data/postgresql.conf.20190513
  5. Edit the postgres configuration to allow more transactions: 
    sudo vi /var/lib/pgsql/9.6/data/postgresql.conf
  6. Change the following line to 100 transactions: 
    max_prepared_transactions = 100
  7. Restart SOAR messaging and the database: 
    sudo systemctl stop resilient-messaging
sudo systemctl restart postgresql-9.6
sudo systemctl start resilient-messaging

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSA230","label":"IBM Security QRadar SOAR"},"ARM Category":[{"code":"a8m0z000000cwKFAAY","label":"Performance"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSIP9Q","label":"IBM Security SOAR"},"ARM Category":[{"code":"a8m0z000000cwKFAAY","label":"Performance"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
16 May 2024

UID

ibm17028859

Page Feedback