This discussion is archived
3 Replies Latest reply: Jun 13, 2013 2:57 PM by 1013092 RSS

Internal : java.sql.SQLSyntaExceptionxErrorException: ORA-00904: "TENANT_ID

user721265 Newbie
Currently Being Moderated
I had to refresh my view to the latest label. After I did the ade refresh -latest, I got this label:
FMWTOOLS_11.1.1.6.0_GENERIC_120112.0037.2_PATCHES4FA_11.1.1.6.2_PLATFORMS
this label also updated the JDeveloper to 11.1.1.6. I was using before 11.1.5.
The problem is that now I cannot run composites that were running with no issues before the upgrade.

This error is shown in the console after starting the SOA server, without even trying to run anything at all.

soa_server1] [ERROR] [] [oracle.soa.mediator.common.listener] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\n] [ecid: 889cfef60875ddb5:-530c4ecd:135e2d7308b:-8000-0000000000000003,0] [APP: soa-infra] DBLocker caught exception while retrieving locked messages. Will retry retrieval after 2 seconds[[
Local Exception Stack:
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: "TENANT_ID": invalid identifier

Error Code: 904
Call: SELECT CASE_ID, CONTAINER_ID, DUMMY1, MSG_ID, COMPONENT_DN, OPERATION, CREATION_DATE, PRIORITY, COMPONENT_STATUS, QNAME_LOCAL_PART, CASE_INFO, QNAME_NAMESPACE, LOCK_TIME, SOURCE_URI, TENANT_ID, INSTANCE_CREATED, IS_EVENT, STATUS FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?))
bind => [1, 2012-03-05 04:59:22.978, 56B16AC166BF11E1AF4DC30F777D0670]
Query: ReadAllQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage)
at oracle.toplink.exceptions.DatabaseException.sqlException
My environment:
is a VM with Linux
I am using the standalone weblogic
running SOA composites.


Is this a Database Issue?

Any help would be appreciated.

Thanks

Edited by: user721265 on Mar 9, 2012 5:00 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points