What to do when TIBCO BusinessEvents (BE) engine gives an error of java.lang.RuntimeException: java.sql.SQLException: ORA-00903: invalid table name details.

What to do when TIBCO BusinessEvents (BE) engine gives an error of java.lang.RuntimeException: java.sql.SQLException: ORA-00903: invalid table name details.

book

Article ID: KB0088315

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
============
The BE engine will not start and gives an Oracle error of 903 which is invalid table name.

Environment:
==========
All

Symptoms:
=========
See above.

Cause:
=====
The project database schema is not matching what is in the database.

Resolution:
=========
Recreate the database scripts and update/recreate the backingstore tables.

Issue/Introduction

What to do when TIBCO BusinessEvents (BE) engine gives an error of java.lang.RuntimeException: java.sql.SQLException: ORA-00903: invalid table name details.