BusinessConnect log shows Oracle database errors (ORA-01691) and loses message data.

BusinessConnect log shows Oracle database errors (ORA-01691) and loses message data.

book

Article ID: KB0093621

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect -
Not Applicable -

Description

Description:
BusinessConnect loses data payload files. In the audit log, an error similar to the one listed below is observed:


java.sql.SQLException: ORA-01691: unable to extend lob segment TIBBC.SYS_LOB0000215197C00003$$ by 8192 in tablespace TIBBC_DATA

Resolution

This error occurs when the Oracle database hosting BC audit data is full. The specific BC table affected is BC_MESSAGES_BIN which contains LOB segments. LOB segments contain unstructured data, which in this case is BC payloads. To resolve the issue, increase the tablespace area available to the BC database. Truncating the table may have no effect as the disk space will not be relinquished by truncation alone.

Customers have reported that the issue can also be resolved by creating a dummy table with the same schema as the BC_MESSAGES_BIN table, moving the data from BC_MESSAGES_BIN to this table and then renaming the table to take the old table's place.

If message data is not needed, consider disabling the "Include Message in Log" setting under Admininstrator>BusinessConnect>System Settings>Audit, Non-Repudiation and Runtime Database Configuration.  This will minimize database space requirements but will eliminate the capability of resending messages.


Issue/Introduction

BusinessConnect log shows Oracle database errors (ORA-01691) and loses message data.