BusinessConnect not updating Audit Log even when processing messages.
Article ID: KB0081768
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect | - |
| Not Applicable | - |
Description
Description:
BusinessConnect processes messages without updating the Audit log. When reviewing the interior server log file, there are a large number of these errors:
"While executing: null: ORA-02291: integrity constraint (BC01TIBCO.MESSAGES_BIN) violated - parent key not found "
Resolution
The schema for the database audit log tables is corrupt and will need to be rebuilt. Shut down the BC engines, back up the BC_MESSAGES, BC_MESSAGES_BIN, and BC_TRANSACTIONS table. Then use the wizard inside the System Settings>Audit, Non-Repudiation and Runtime Database Configuration "Create tables" button to drop and recreate the audit log tables. Restart the engine when complete.
NOTE: Backing up these three tables will only preserve transaction data. It will not preserve the BC_DUP, BC_RESEND_BIN, and or the BC Access Control List tables. If you need to retain these tables, please refer to the BC Interior Server Administration Guide Appendix A for the full structure of these tables, as well as how to back them up.
NOTE: Backing up these three tables will only preserve transaction data. It will not preserve the BC_DUP, BC_RESEND_BIN, and or the BC Access Control List tables. If you need to retain these tables, please refer to the BC Interior Server Administration Guide Appendix A for the full structure of these tables, as well as how to back them up.
Issue/Introduction
BusinessConnect not updating Audit Log even when processing messages.
Additional Information
BusinessConnect Interior Server Administration Guide
Feedback
Yes
No
Powered by
