Error in BPM ORA-25156: old style outer join (+) cannot be used with ANSI joins

Solution Verified - Updated -

Issue

Following error is displayed when clicking on Task menu in business-central:

aused by: java.sql.SQLException: ORA-25156: old style outer join (+) cannot be used with ANSI joins

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

Environment

  • Red Hat JBoss BPM Suite 6.0.x
  • Oracle Database 11g

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In