Troubleshooting
Problem
This issue is relevant to OMS-IV Phase 1 integration-
https://www.ibm.com/support/knowledgecenter/SSGTJF/integrating/c_IS_IntegratingWithInventoryVisibility.html
The integration servers are defined to send supply and demand updates from OMS to IV-
https://www.ibm.com/support/knowledgecenter/SSGTJF/integrating/c_DefiningIntegrationProperties.html
These servers are throwing the below error-
413: Payload too large
Since these errors are set to be reprocessible, the servers attempt to update this in the yfs_reprocess_error table, however this fails with -
<Errors>
<Error ErrorCode="YDB92_001"
ErrorDescription="The data bound to the column is invalid in this context." ErrorRelatedMoreInfo="">
<Error ErrorCode="YDB92_001"
ErrorDescription="The data bound to the column is invalid in this context." ErrorRelatedMoreInfo="">
How can this be resolved?
Cause
The maximum payload supported by IV is 500kb. However, IBM recommends no more than 100 items per payload. If you need to send more than 100 items, invoke multiple API calls-
https://www.ibm.com/support/knowledgecenter/SSSMTK/com.ibm.help.oncloud.invservice.doc/c_best_practices.html
In this case, inputs being sent to IV via adjustInventory calls in OMS were exceeding the limit, leading to the errors seen.
Diagnosing The Problem
The issue is being seen due to the large payload being sent from OMS (via adjustInventory)
Resolving The Problem
In general, OMS APIs do not restrict with the data being used by the customer because it may not know what part of the data is used in the service definitions later. Suggestion is to look into writing a logic to split the data if large payloads are expected in OMS.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"ARM Category":[{"code":"a8m0z000000cxzrAAA","label":"Inventory"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0.0;9.5.0"}]
Was this topic helpful?
Document Information
Modified date:
13 November 2020
UID
ibm16366875