Modify 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.
You must have logged in to the WFA host system as a root user.
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.
At the shell prompt, navigate to the following directory on the WFA server: WFA_install_location/wfa/bin/
Enter the following command:
./wfa --txn-timeout[=TIMEOUT] --restart=WFA
./wfa --txn-timeout=1000 --restart=WFA