Error in oracle.soa.bpel.engine.cluster After Patching "Failed to execute heartbeat update java.sql.SQLSyntaxErrorException: ORA-00904: "COMPONENTTYPE": invalid identifier" (Doc ID 1543146.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

After applying any patch which contains the fix for Bug 12643184, Bug 12742831 and/or unpublished Bug 12766945 you see the following error in your log files upon restart:

<Mar 29, 2013 3:14:46 PM EDT> <Error> <oracle.soa.bpel.engine.cluster> <BEA-000000> <Failed to execute heartbeat update
java.sql.SQLSyntaxErrorException: ORA-00904: "COMPONENTTYPE": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:929)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)

Changes

You've recently applied any patch containing the fix for Bug 12643184, Bug 12742831 and/or unpublished Bug 12766945

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms