A message similar to the following is continuously written to the TIBCO iProcess Engine (Oracle) sw_error.log file:
2017/01/14 11:29:59.590906(PROCMGR:2:19256:1::::pro:/idl.c:84775:6397): 1945-Database error: fil_active_logins_read() Unable to fetch data(SELECT logical_machine_id, user_name, user_id, process_id, filsh, windows, station_id FROM swpro.active_logins WHERE logical_machine_id=:1 ) (Statement ID - 311) (ORA-03124: two-task internal error)
Issue/Introduction
An ORA-03124: two-task internal error is continuously written to the TIBCO iProcess Engine (Oracle) sw_error.log file.
Environment
Oracle database.
All supported operating systems.
Resolution
This is an error returned by Oracle and should be investigated by the Oracle DBA and if necessary, the DBA should open a ticket with Oracle to fully investigate the cause of the error.
The error is resolved by modifying a hidden Oracle attribute, _ENABLE_ROW_SHIPPING, to false.
Note that Oracle Support should be consulted before changing a hidden parameter.