BusinessConnect interior server terminates on startup

BusinessConnect interior server terminates on startup

book

Article ID: KB0076778

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect 7.X

Description

The Business Connect interior server does not startup and terminates every time. We see the following errors in the logs :
<<<
2019 Sep 19 05:09:30:020 GMT -0500 BW.BusinessConnect-BusinessConnect-w2papl0046761 Info [bw.logger] BW-EXT-LOG-300000 Initializing extended configuration schema...
2019 Sep 19 05:09:30:338 GMT -0500 BW.BusinessConnect-BusinessConnect-w2papl0046761 Error [bw.logger] BW-EXT-LOG-100000 Error executing ORA-00942: table or view does not exist
2019 Sep 19 05:09:30:344 GMT -0500 BW.BusinessConnect-BusinessConnect-w2papl0046761 Info [bw.logger] BW-EXT-LOG-300000 EDIPluginRegistry registration successful!
>>>

This error usually suggests missing BC DB tables.

Issue/Introduction

When starting the BusinessConnect Interior Server, it terminates on startup with a ORA-00942 error from the Oracle Database

Environment

Linux: CentOS 7 with Oracle Databases

Resolution

First follow the below KB article :
<<<
https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-46300
>>>

If this does not resolve your issue, do the following :
<<<
  • Stop the BusinessConnect Interior Server
  • Go to Admin -> BusinessConnect -> System Settings -> Audit, Non-Repudiation and Runtime Database Configuration
  • Under, Connection Settings in Target Table Type : select "Runtime Data Store",  and then create the Runtime tables using,   
    ++++++++++++++++++++++++++++++++++++++++++++++++++
      Drop and recreate the database tables     "Create" 
    ++++++++++++++++++++++++++++++++++++++++++++++++++
  • BusinessConnect Interior Server
>>> 

Additional Information

ORA-00942, terminate
Powered by Wolken Software