My Oracle Support Banner

Internal Exception: Java.sql.SQLSyntaxErrorException: ORA-00904: "CREATION_DATE": Invalid Identifier (Doc ID 2376593.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 to 11.1.1.7.8 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.8 version, Mediator Service Engine

After applying Mediator Merge Patch 27254956 (MERGE REQUEST ON TOP OF SOA BP 11.1.1.7.8 FOR BUGS 24795394 25736925 18599002 ), the mediator related composites are failing.

Below is the error that is seen in the in the soa server logs at the time of issue.

...
Caused By: Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "CREATION_DATE": invalid identifier

Error Code: 904
Call: Insert into MEDIATOR_GROUP_STATUS (ID,COMPONENT_DN,OPERATION,GROUP_ID,START_SEQUENCE_ID,LAST_SEQUENCE_ID,NEXT_SEQUENCE_ID,LAST_RECEIVED_TIME,STATUS,SEQU
ENCING_LEVEL,CONTAINER_ID,RESEQUENCER_TYPE,TIMEOUT_DURATION,CREATION_DATE) values (?,?,?,?,?,?,?,systimestamp at time zone 'UTC',?,?,?,?,?,?)
  bind => [ItQJC235+7qaubQWKhiAytSwaDHdT+PMCGhne5XlIjI=, default/SyncAcctSiebelAggrEventConsumer!1.0/SyncAcctSiebelAggrEventConsumer_RS, receive, 1-1F3S
9V2, null, -1, null, 0, OPERATION_SEQUENCING, 7AADE9B1239411E8BFDD1DB62BFBAF02, FIFO, null, 2018-03-12 10:56:22.779]
Query: DataModifyQuery()
  at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:296)
  at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:725)
...



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.