Internal Exception: Java.sql.SQLSyntaxErrorException: ORA-00904: "CREATION_DATE": Invalid Identifier
(Doc ID 2376593.1)
Last updated on AUGUST 16, 2024
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! |
In this Document
| Symptoms |
| Cause |
| Solution |