14 Replies Latest reply on Jul 6, 2012 12:06 AM by vladodias

    Error retrieving instance details from soa-infra runtime

    937917
      Hello

      I am getting the below error while deploying the SOA composite app on weblogic .it is being deployed on server but giving the error " *Error retrieving instance details from soa-infra runtime."*

      From Jedeveloper am able to perform DML/DDL operation on database

      Error::::::::::::::::::::::::::


      Error retrieving instance details from soa-infra runtime. This could happen due to the instance database being down. Please view the log files for details.

      below is the stack trace from soa_server-diagnostic

      Oracle SOA Server version 11.1.1.6.0
      Build: 0
      Build time: Wed Dec 14 13:55:57 PST 2011
      Build type: release
      Source tag: PCBPEL_11.1.1.6.0_GENERIC_111214.0600.1553

      ]]
      [2012-07-03T10:15:10.390+05:30] [soa_server1] [NOTIFICATION] [] [oracle.soa.bpel.engine.cluster] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] Detected Enable Cluster=true StandAlone=true
      [2012-07-03T10:15:10.390+05:30] [soa_server1] [NOTIFICATION] [] [oracle.soa.bpel.engine] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] [[

      OraBPEL "bpel-engine" BPEL domain loaded.
      *****************************************************************************
      ]]
      [2012-07-03T10:15:10.390+05:30] [soa_server1] [NOTIFICATION] [] [oracle.soa.bpel.engine] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] CubeServiceEngine=> initialized ....
      [2012-07-03T10:15:10.484+05:30] [soa_server1] [NOTIFICATION] [] [oracle.soa.mediator.serviceEngine] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] Setting executor from fabric
      [2012-07-03T10:15:10.500+05:30] [soa_server1] [NOTIFICATION] [] [oracle.soa.mediator.monitor] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] MediatorActivityMonitor:dms metrics collection enabled
      [2012-07-03T10:15:10.765+05:30] [soa_server1] [NOTIFICATION] [] [oracle.soa.mediator.serviceEngine] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] ****** MediatorServiceEngine:: Sucessfully able to connect to instance tracking store ******
      *[2012-07-03T10:15:10.968+05:30] [soa_server1] [ERROR] [] [oracle.soa.mediator.serviceEngine] [tid: [STANDBY].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000JXB8zZ8Fw000jzwkno1FwbV9000002,0] [APP: soa-infra] Runtime store connection error. Check runtime store DB is up and available[[*
      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-00942: table or view does not exist

      Error Code: 942
      Call: SELECT GUID FROM VERSION
      Query: DataReadQuery()
      at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
      at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:614)
      at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:468)
      at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:447)
      at oracle.toplink.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:117)
      at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)

      Edited by: 934914 on Jul 3, 2012 2:28 AM