Modifying the transaction timeout setting of OnCommand Workflow Automation

The OnCommand Workflow Automation (WFA) database transaction times out in 300 seconds by default. You can increase the default timeout duration when restoring a large-sized WFA database from a backup to avoid potential failure of the database restoration.

Before you begin

You must have logged in to the WFA host system as a root user.

About this task

The default WFA installation path is used in this procedure. If you changed the default location during installation, you must use the changed WFA installation path.

Steps

  1. At the shell prompt, navigate to the following directory on the WFA server: WFA_install_location/wfa/bin/
  2. Enter the following command: ./wfa --txn-timeout[=TIMEOUT] --restart=WFA
    Example
    ./wfa --txn-timeout=1000 --restart=WFA