ORA-03124: two-task internal error reported in TIBCO iProcess Engine (Oracle) sw_error.log file

ORA-03124: two-task internal error reported in TIBCO iProcess Engine (Oracle) sw_error.log file

book

Article ID: KB0084348

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (Oracle) All supported versions

Description

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.