Unable to start Cache Server (JDBC type backingstore)

Unable to start Cache Server (JDBC type backingstore)

book

Article ID: KB0090059

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
Exception is thrown when starting the Cache Server.

Environment:
===========
  o BusinessEvents 3.0.1
  o All Operating Systems

Symptoms:
=========
The following exception is thrown upon startup:

Job Error on thread:dbstore-main.cluster-1
java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: ORA-00904: "T"."ENTITY"."ID$": invalid identifier   at com.tibco.cep.runtime.service.om.coherence.cluster.CacheCluster$ClusterRecoveryAgent.run(CacheCluster.java:2609)   at com.tibco.cep.runtime.session.BEManagedThread.execute(BEManagedThread.java:459)
        at com.tibco.cep.runtime.session.BEManagedThread.run_from_queue(BEManagedThread.java:401)  at com.tibco.cep.runtime.session.BEManagedThread.run(BEManagedThread.java:302)
Caused by: java.lang.RuntimeException: java.sql.SQLException: ORA-00904: "T"."ENTITY"."ID$": invalid identifier    at com.tibco.be.jdbcstore.BECoherenceJdbcStore.migrate(BECoherenceJdbcStore.java:3013)
        at com.tibco.cep.runtime.service.om.coherence.cluster.CacheCluster.recover(CacheCluster.java:1697)  at com.tibco.cep.runtime.service.om.coherence.cluster.CacheCluster$ClusterRecoveryAgent.run(CacheCluster.java:2607)
        ... 3 more

Cause:
======
The property be.engine.cluster.migrateObjectTable was set to "true".

Resolution:
========
Remove the property from the TRA file (used only to migrate BE 2.2 backing store database - not valid for JDBC types)

Issue/Introduction

Unable to start Cache Server (JDBC type backingstore)