Back to forum list… Back to Issues and Problems...

Lookup error - How do I fix. (2 replies)

R Adler
6 years ago
R Adler 6 years ago

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.

Support
6 years ago
Support 6 years ago

Looking from the extract of the audit report, there is a lookup function on the 'InventoryOnHand' field on the 'Map' transform.

  1. 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.
  2. The first parameter of any lookup function is the lookup id (defined here).
  3. At this point you could alter the query to return just the single result required (for every time this lookup is called).
  4. 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.

R Adler
6 years ago
R Adler 6 years ago

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.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close