Resolution:
Description:
===========
In TIBCO BusinessEvents, Cache Engines were not able to start and wait in recovery state.

Environment:
==========
TIBCO BusinessEvents 4.0.1

Symptoms:
=========

The engine logs has the following messages:

java.sql.SQLSyntaxErrorException: ORA-00904: "T"."CONFIRMATIONINTERCEPTSTATUS_FG": invalid identifier
2013 Jan 04 22:06:34:299 GMT +0 ILS_Cache-ILS-Cache-1 Error [ClusterCacheRecoveryManager.Thread.1] - [root]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
2013 Jan 04 22:06:34:299 GMT +0 ILS_Cache-ILS-Cache-1 Error [ClusterCacheRecoveryManager.Thread.1] - [root]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
2013 Jan 04 22:06:34:299 GMT +0 ILS_Cache-ILS-Cache-1 Error [ClusterCacheRecoveryManager.Thread.1] - [root]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
2013 Jan 04 22:06:34:300 GMT +0 ILS_Cache-ILS-Cache-1 Info [ClusterCacheRecoveryManager.Thread.3] - [jdbcstore] ######## Pre-loaded
        
Cause:
======
The error is due to different alias name in the database.


Resolution:
==========
Correct the alias name in the backingstore.