Description:

p { margin-bottom: 0.1in; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "AR PL UKai CN"; font-size: 11pt; }p.ctl { font-size: 11pt; }p { margin-bottom: 0.1in; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "AR PL UKai CN"; font-size: 11pt; }p.ctl { font-size: 11pt; }
Symptoms:

2014 Feb 09 00:10:33:919 GMT +8 CacheEngine Debug [ClusterCacheRecoveryManager.Thread.3] - [runtime.service] Creating Recovery BackingStore (class=com.tibco.be.jdbcstore.BECoherenceJdbcStore)

2014 Feb 09 00:10:33:919 GMT +8 CacheEngine Error [ClusterCacheRecoveryManager.Thread.1] - [root] java.sql.SQLException: ORA-00903: invalid table name

2014 Feb 09 00:10:33:919 GMT +8 CacheEngine Debug [ClusterCacheRecoveryManager.Thread.3] - [jdbcstore] INITIALIZED BECoherenceJdbcStore for recovery with commit size=10

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Error [ClusterCacheRecoveryManager.Thread.1] - [root] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Debug [ClusterCacheRecoveryManager.Thread.3] - [jdbcstore.impl] DBAdapter <init> with cluster G3CEPEngine-PROD

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Error [ClusterCacheRecoveryManager.Thread.1] - [root] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Debug [ClusterCacheRecoveryManager.Thread.3] - [jdbcstore.impl] WorkItems batch size 500

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Error [ClusterCacheRecoveryManager.Thread.1] - [root] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Info [ClusterCacheRecoveryManager.Thread.3] - [jdbcstore] Loading objects from database, class=be.gen.Concepts.ConcordPPsysInfo

2014 Feb 09 00:10:33:920 GMT +8 CacheEngine Error [ClusterCacheRecoveryManager.Thread.1] - [root] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

2014 Feb 09 00:10:33:921 GMT +8 CacheEngine Error [ClusterCacheRecoveryManager.Thread.3] - [runtime.service] Error while Pre-Loading class be.gen.Concepts.ConcordPPsysInfo

p { margin-bottom: 0.1in; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "AR PL UKai CN"; font-size: 11pt; }p.ctl { font-size: 11pt; }
Cause:
p { margin-bottom: 0.1in; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "AR PL UKai CN"; font-size: 11pt; }p.ctl { font-size: 11pt; }

Backing store is not in-sync with the project. Some of the Concepts are not registered in the ClassToTable table in the database.

Regenerate the backing store SQL script from the latest project and import to the database.

TIBCO BusinessEvents Cache engine throws a “java.sql.SQLException: ORA-00903: invalid table name” exception upon startup.

Backing store invalid table name error recovery.