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.