Description:

Database connection messages are reported in the sw_warn and sw_error log files. For example in the sw_warn.log:

2013/03/14 00:10:07.973799(WISMBD:1:30737:2:SPRITOOL:22839:TMU00002:pro:/wismbd.c:83102:645): 1852-Error forwarding MBOX message to WIS (error=-2).

This may have a corresponding Work Item Server (WIS) message in sw_error.log similar to the following.

2013/03/14 00:10:07.973549(WIS:2:30594:1:SPRITOOL:22839:TMU00002:pro:/idl.c:83006:6104): 1945-Database error: film_exists() Unable to get column count (Statement ID - 326) (ORA-02396: exceeded maximum idle time, please connect again).
Symptoms:
There are no symptoms or loss of data.
Cause:
The Oracle connection used by the process reporting the problem has been lost or terminated by Oracle. This can occur if a system is idle for more than the time defined by the Oracle configuration parameter IDLE_TIME. The database connection will be retried and processing will continue once established.

An 1852 message is reported in the TIBCO iProcess Engine sw_warn.log file.

Increase the Oracle IDLE_TIME parameter to a value greater than the expected idle time or set it to UNLIMITED.