The TIBCO iProcess Engine sw_error.log file may show errors similar to:ORA-03124: two-task internal error.

The TIBCO iProcess Engine sw_error.log file may show errors similar to:ORA-03124: two-task internal error.

book

Article ID: KB0093509

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (Oracle) -
Not Applicable -

Description

Description:
The sw_error log file may contain entries similar to the following: 1945-Database error: fil_active_logins_read() Unable to execute statement(fetch) (Statement ID - 311) (ORA-03124: two-task internal error).


Symptoms:
The sw_error log file may contain entries similar to the following: 
1945-Database error: fil_active_logins_read() Unable to execute statement(fetch) (Statement ID - 311) (ORA-03124: two-task internal error).

Cause:
This is an internal Oracle error and as such, DBAs should open a ticket with Oracle to fully investigate the cause of this error in each environment. A common solution to this issue involves modifying a hidden Oracle attribute, _ENABLE_ROW_SHIPPING, to false.  Before undertaking this change, it is recommended to contact Oracle support to ensure this is the appropriate solution for this environment. 

Issue/Introduction

The TIBCO iProcess Engine sw_error.log file may show errors similar to:ORA-03124: two-task internal error.

Resolution

Updating the _ENABLE_ROW_SHIPPING Oracle parameter to false may resolve the error however, contact Oracle support for a full analysis.

Additional Information

Link to TIBCOmmunity article discussing this issue: https://tibbr.tibcommunity.com/tibbr/#!/messages/31795