IBM Support

Stack Overflow Using GetInventorySnapshot API to Download Data --Workaround

Troubleshooting


Problem

Stack Overflow Using GetInventorySnapshot API to Download Data --Workaround

Symptom

GetInventorySnapshot API hangs if a large number of records are downloaded. Using the Httpapitester, stack overflow error is given when trying to download a large amount of data.
PART: API 2.0 SP3 Platform
COMPONENT: getInventorySnapShot
OS: Windows NT - 4.0 SP 3
DATABASE: Oracle - 7.3.2
WEB SERVER: IIS - 3.0
WEB BROWSER: Internet Explorer - 5.0

Cause

Resolving The Problem

Workaround:

Use the following query to get the inventory picture:

Select item_id, product_class, uom, On_hand_shippable_qty, On_hand_held, Reserved_qty, Allocated_Qty, Open_order_qty, Backordered_qty
from yfs_global_inventory
where shipnode_key > ' '
Order by ShipNode_Key, Item_ID, Product_Class, UOM

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI48363

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21521120

Page Feedback