3 Replies Latest reply: Jun 13, 2013 4:57 PM by 1013092 RSS

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

    User721265-Oracle
      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