0 Replies Latest reply: Jul 8, 2014 1:01 PM by user12231589 RSS

    SOA AQAdapter ORA-25247: XXXXX is not a recipient of specified message[[

    user12231589

      When SOA datadourse SOADataSource was suspended somehow and resumed back , the  AQAdapter don't consume the message completely since . Some are deQueued but some are not.  In soa_server1-diagnostic.log, it shows the

      AQ Adapter BanDispatcher ORA-25247: SFORCE is not a recipient of specified message[[

       

      But there is no change in the CONSUMER in the composite property and there is no change of the  enQueue in the client endpoint.

      We tried to restart weblogic and soa server, the issue has not  solved.

      Then, we tried to re-deploy the AQAdapter, the issue has not solved either.

      Then, we drop and re-create the queue in the client endpoint, the issue solved.

       

      But it seems not proper to request our client to re-create the queue. Any suggestion to solve in the SOA end?   Thanks.

       

       

       

      [2014-07-08T10:42:12.654-04:00] [soa_server1] [ERROR] [] [oracle.soa.adapter] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1828133a] [userId: <anonymous>] [ecid: 0000KSMPtMFCOtW3Xzj8F71Jj03h00001i,0] [APP: soa-infra] [WSM_OperationName: Dequeue] [dcid: 1c32016bb7fd47dc:2b69b702:1471663b67a:-8000-000000000000001d] [WSM_LogType: Request] [WSM_PolicyVersion: 1] [WSM_ServiceID: default/BanDispatcher/DispatchMediator] [WSM_PolicyName: oracle/log_policy] AQ Adapter BanDispatcher ORA-25247: SFORCE is not a recipient of specified message[[

       

      ]]

      [2014-07-08T10:42:12.654-04:00] [soa_server1] [ERROR] [] [oracle.soa.adapter] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1828133a] [userId: <anonymous>] [ecid: 0000KSMPtMFCOtW3Xzj8F71Jj03h00001i,0] [APP: soa-infra] [WSM_OperationName: Dequeue] [dcid: 1c32016bb7fd47dc:2b69b702:1471663b67a:-8000-000000000000001d] [WSM_LogType: Request] [WSM_PolicyVersion: 1] [WSM_ServiceID: default/BanDispatcher/DispatchMediator] [WSM_PolicyName: oracle/log_policy] AQ Adapter BanDispatcher [[

      java.sql.SQLException: ORA-25247: SFORCE is not a recipient of specified message

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:415)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

              at oracle.jdbc.driver.T4Caqdq.receive(T4Caqdq.java:435)

              at oracle.jdbc.driver.T4CConnection.doDequeue(T4CConnection.java:4067)

              at oracle.jdbc.driver.PhysicalConnection.dequeue(PhysicalConnection.java:16057)

              at oracle.jdbc.driver.PhysicalConnection.dequeue(PhysicalConnection.java:16138)

              at oracle.jdbc.OracleConnectionWrapper.dequeue(OracleConnectionWrapper.java:1594)

              at weblogic.jdbc.wrapper.XAConnection_oracle_jdbc_driver_LogicalConnection.dequeue(Unknown Source)

              at weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection.dequeue(Unknown Source)

              at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.dequeue(AbstractDequeueAgent.java:356)

              at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.removeMessage(AbstractDequeueAgent.java:331)

              at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.getInputRecord(AbstractDequeueAgent.java:237)

              at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:101)

              at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:105)

              at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)

              at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)

       

      ]]

      [2014-07-08T10:42:12.655-04:00] [soa_server1] [NOTIFICATION] [] [oracle.adapter.aq.logger] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1828133a] [userId: <anonymous>] [ecid: 0000KSMPtMFCOtW3Xzj8F71Jj03h00001i,0] [APP: soa-infra] [WSM_OperationName: Dequeue] [dcid: 1c32016bb7fd47dc:2b69b702:1471663b67a:-8000-000000000000001d] [WSM_LogType: Request] [WSM_PolicyVersion: 1] [WSM_ServiceID: default/BanDispatcher/DispatchMediator] [WSM_PolicyName: oracle/log_policy] Invalidating application connection handle....

      [2014-07-08T10:42:12.655-04:00] [soa_server1] [NOTIFICATION] [] [oracle.soa.adapter] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1828133a] [userId: <anonymous>] [ecid: 0000KSMPtMFCOtW3Xzj8F71Jj03h00001i,0] [APP: soa-infra] [WSM_OperationName: Dequeue] [dcid: 1c32016bb7fd47dc:2b69b702:1471663b67a:-8000-000000000000001d] [WSM_LogType: Request] [WSM_PolicyVersion: 1] [WSM_ServiceID: default/BanDispatcher/DispatchMediator] [WSM_PolicyName: oracle/log_policy] AQ Adapter BanDispatcher Invalidating application connection handle....