Products | Versions |
---|---|
TIBCO BusinessEvents Enterprise Edition | - |
Not Applicable | - |
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.