How to resubmit orders in START status.
Article ID: KB0093918
Updated On:
| Products | Versions |
|---|---|
| TIBCO Fulfillment Order Management | - |
| Not Applicable | - |
Description
Description:
We can have orders in START status when restarting Tomcat or when Tomcat goes down. We can find orders in START status with no plan. These orders do not resume after a Tomcat restart. We will see order related information in tables ORDERS,ORDER_DETAILS and sometimes in OMS_ROUTER_TBL.
We can have orders in START status when restarting Tomcat or when Tomcat goes down. We can find orders in START status with no plan. These orders do not resume after a Tomcat restart. We will see order related information in tables ORDERS,ORDER_DETAILS and sometimes in OMS_ROUTER_TBL.
Issue/Introduction
How to resubmit orders in START status.
Resolution
- com.tibco.af.oms.webservice.idempotency=true (ConfigValues_OMS.xml)
- It is possible for order to remain in START state with data in ORDERS/ORDER_DETAILS table and no entry in OMS_ROUTER_TBL. In such cases, the order can be recovered by resubmitting such orders.
- com.tibco.af.oms.webservice.idempotency=false (ConfigValues_OMS.xml)
- We will have to delete the corresponding entries in ORDERS,ORDER_DETAILS and OMS_ROUTER_TBL. No need to restart Tomcat. Resubmit the order.
-- using orderid
DELETE FROM OMS_ROUTER_TBL
WHERE orderid='%%ORDER_ID%%';
delete from order_details
where orderid='%%ORDER_ID%%';
delete from orders
where orderid='%%ORDER_ID%%';
commit;
-- using order ref
DELETE FROM OMS_ROUTER_TBL
WHERE orderid=( select orderid from orders where orderref='%%ORDER_REF%%');
delete from order_details
where orderid=( select orderid from orders where orderref='%%ORDER_REF%%');
delete from orders
where orderid=( select orderid from orders where orderref='%%ORDER_REF%%');
commit;
Feedback
Yes
No
Powered by
