TIBCO BusinessEvents engine throws the exception "CONNECT BY loop in user data" when running the engine with the BackingStore feature.

TIBCO BusinessEvents engine throws the exception "CONNECT BY loop in user data" when running the engine with the BackingStore feature.

book

Article ID: KB0087945

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description
=======
While running TIBCO BusinessEvents engine with the Backingstore feature, the following exception is thrown.

Error [DistributedCache] - java.sql.SQLException: ORA-01436: CONNECT BY loop in user data
Error [DistributedCache] -    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
Error [DistributedCache] -     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316


Cause:
=====
This exception is mainly seen when using the Oracle Database with incompatible Oracle JDBC driver libraries.

Resolution:
=======
Make sure that you are using the exact same Oracle client version in your BE Application as the Oracle server version. Also make sure that the correct JDBC JAR gets picked up first in your TRA configuration.

Issue/Introduction

TIBCO BusinessEvents engine throws the exception "CONNECT BY loop in user data" when running the engine with the BackingStore feature.