Lookup error - How do I fix. (2 replies)
Looking from the extract of the audit report, there is a lookup function on the 'InventoryOnHand' field on the 'Map' transform.
- The lookup function can return at most one record. If it returns multiple records this error is raised (this behaviour is fixed). The lookup function is defined here.
- The first parameter of any lookup function is the lookup id (defined here).
- At this point you could alter the query to return just the single result required (for every time this lookup is called).
- Alternatively, you may wish to find which record caused the error, providing you with enough info to make a more informed resolution.
a. If you return back the designer & load the integration.
b. Open the Map transform
c. Set the Log Key for the 'Item Code' field (or SKU) to 1
This will cause the Audit Report to print the item code in the source column of audit report. And if you re-run the integration you will know which record caused the error. From there you can alter the lookup query accordingly.
Hope this helps.
Setting the log key helped us locate the item that was causing the issue. Ultimately we found the issue was with the item setup in Sage and not Realisable.
I am experiencing the following error on an inventory upload integration. How do I go about fixing this?
4/27/2018 11:52:02 AM
Map
9650
Error whilst evaluating field [InventoryOnHand] on transaction type [Variant].
Resolved Function - InventoryOnHand
Error - Description: Lookup returned [2] records, but expected 1.