Troubleshooting
Problem
Attempts to stamp SelectMethod="WAIT" in YFSBeforeChangeOrderUE does not get honored in changeOrder API call in IBM Sterling Order Management.
Cause
This is a product limitation.
Diagnosing The Problem
When the SelectMethod="WAIT" is passed in Input then the database select operations are carried out in the WAIT mode.
- If this attribute is passed in changeOrder API Input, then database select operations are carried out in the WAIT mode.
- If you do not pass it in changeOrder API and set this attribute to WAIT in beforeChangeOrder user exit (UE) then database select operations should be carried out in the WAIT mode as per javadocs. But they are carried out in NO WAIT mode.
When you call the changeOrder API, first the SELECT operation is executed on YFS_ORDER_HEADER table and after that beforeChangeOrder UE is being invoked.
The Order object is being read from DB before calling beforeChangeOrder UE to invoke Order's Enterprise Code specific UE. This also serves the purpose of validating the Order. Once the UE is called, the SelectMethod from the UE is used for any future selects.
Since SelectMethod is not passed in changeOrder API input, this SELECT operation on YFS_ORDER_HEADER table is carried out in NO WAIT mode irrespective of the value of SelectMethod in beforeChangeOrder UE. Because this select operation is being executed before the beforeChangeOrder UE execution.
Resolving The Problem
To execute the DB selects in WAIT mode by passing the SelectMethod="WAIT" in changeOrder API, set it by any of the below mentioned ways instead of setting it in beforeChangeOrder UE:
- Modify the changeOrder API input and add the SelectMethod="WAIT" in API Input.
OR
- Implement a wrapper changeOrder service, which massages the input and adds SelectMethod="WAIT" before calling actual changeOrder API.
[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Documentation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;9.1;9.2;9.2.1;9.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21671295