java.sql.SQLException: ORA-20006: Workflow thread does not exist. The order may have been moved by another user. Refresh your worklist and try again. order id = 10, hist_seq_id = 33 ORA-06512: at "OSM_DEV_ORDERMGMT.ERROR_MSG", line 8 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 5043 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4225 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4269 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_ORD_INST_PKG", line 1019 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1240 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1302 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)

Oracle Community | Bharathi | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    OSM7 COM cartridge with automated task

    Oracle Community | 5 years ago | Bharathi
    java.sql.SQLException: ORA-20006: Workflow thread does not exist. The order may have been moved by another user. Refresh your worklist and try again. order id = 10, hist_seq_id = 33 ORA-06512: at "OSM_DEV_ORDERMGMT.ERROR_MSG", line 8 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 5043 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4225 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4269 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_ORD_INST_PKG", line 1019 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1240 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1302 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-20006: Workflow thread does not exist. The order may have been moved by another user. Refresh your worklist and try again. order id = 10, hist_seq_id = 33 ORA-06512: at "OSM_DEV_ORDERMGMT.ERROR_MSG", line 8 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 5043 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4225 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4269 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_ORD_INST_PKG", line 1019 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1240 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1302 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)

      at com.mslv.oms.dataaccesslayer.CallableProxy.execute()
    2. com.mslv.oms
      OMSController_h9cupp_EOImpl_WLSkel.invoke
      1. com.mslv.oms.dataaccesslayer.CallableProxy.execute(Unknown Source)
      2. com.mslv.oms.handler.order.cache.AbstractOrderCacheManager.a(Unknown Source)
      3. com.mslv.oms.handler.order.cache.AbstractOrderCacheManager.getOrderByHistoryId(Unknown Source)
      4. com.mslv.oms.handler.order.f.a(Unknown Source)
      5. com.mslv.oms.handler.getorder.GetOrderHandlerEJB.process(Unknown Source)
      6. com.mslv.oms.handler.a.processRequest(Unknown Source)
      7. com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
      8. com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
      9. com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
      10. com.mslv.oms.jsp.xmlapi.InternalRequestProcessor.processRequestXMLResponse(Unknown Source)
      11. com.mslv.oms.jsp.controller.CoreRequestController.processRequest(Unknown Source)
      12. com.mslv.oms.security.base.ControllerBean.processRequestXMLReponse(Unknown Source)
      13. com.mslv.oms.security.base.ControllerBean.getOrderAsXML(Unknown Source)
      14. com.mslv.oms.security.base.ControllerBean.getOrderAsXML(Unknown Source)
      15. com.mslv.oms.security.base.OMSController_h9cupp_EOImpl.getOrderAsXML(OMSController_h9cupp_EOImpl.java:1452)
      16. com.mslv.oms.security.base.OMSController_h9cupp_EOImpl_WLSkel.invoke(Unknown Source)
      16 frames
    3. weblogic.rmi.internal
      BasicRemoteRef.invoke
      1. weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
      2. weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:222)
      2 frames
    4. com.mslv.oms
      AbstractAutomator._runAutomator
      1. com.mslv.oms.security.base.OMSController_h9cupp_EOImpl_1031_WLStub.getOrderAsXML(Unknown Source)
      2. com.mslv.oms.automation.TaskContextBean.getOrderData(Unknown Source)
      3. com.mslv.oms.automation.OrderContextImpl.getOrder(Unknown Source)
      4. com.mslv.oms.automation.plugin.AbstractAutomator._runAutomator(Unknown Source)
      4 frames
    5. oracle.communications.ordermanagement
      XQuerySender_68gpjv_EOImpl_WLSkel.invoke
      1. oracle.communications.ordermanagement.automation.plugin.XQuerySender_68gpjv_EOImpl._runAutomator(XQuerySender_68gpjv_EOImpl.java:133)
      2. oracle.communications.ordermanagement.automation.plugin.XQuerySender_68gpjv_EOImpl_WLSkel.invoke(Unknown Source)
      2 frames
    6. weblogic.rmi.internal
      BasicRemoteRef.invoke
      1. weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
      2. weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:222)
      2 frames
    7. oracle.communications.ordermanagement
      XQuerySender_68gpjv_EOImpl_1031_WLStub._runAutomator
      1. oracle.communications.ordermanagement.automation.plugin.XQuerySender_68gpjv_EOImpl_1031_WLStub._runAutomator(Unknown Source)
      1 frame
    8. com.mslv.oms
      c.a
      1. com.mslv.oms.automation.AutomationDispatcher.a(Unknown Source)
      2. com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.processMessage(Unknown Source)
      3. com.mslv.oms.automation.AutomationDispatcher.onLocalMessage(Unknown Source)
      4. com.mslv.oms.automation.plugin.AutomationEventHandlerImpl.a(Unknown Source)
      5. com.mslv.oms.automation.plugin.c.a(Unknown Source)
      5 frames
    9. oracle.communications.ordermanagement
      ClusterMessageHandlerBean.onMessage
      1. oracle.communications.ordermanagement.cluster.message.ClusterMessageHandlerBean.onMessage(Unknown Source)
      1 frame
    10. weblogic.ejb.container
      MDListener.onMessage
      1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
      2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
      3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
      3 frames
    11. weblogic.jms.client
      JMSSession$UseForRunnable.run
      1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4585)
      2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4271)
      3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3747)
      4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
      5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5096)
      5 frames
    12. weblogic.work
      ExecuteRequestAdapter.execute
      1. weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
      1 frame
    13. weblogic.kernel
      ExecuteThread.run
      1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
      2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
      2 frames