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

Item lookup suddenly failing (3 replies)

Jay C
4 years ago
Jay C 4 years ago

I have an Iman Lookup function that I use on 6 different transform jobs.  It uses a SQL view to get the Sage item number from an optional field.

Today, one of the jobs started failing with "1140 - Item number 23WALK-8.5-WHITE/BLUE-B does not exist.", but that item definitely exists, we can see it in the view.  I don't even know where to start to fix it.  I've reset the Iman services.

 

Support
4 years ago
Support 4 years ago

Can you provide the Lookup expression which you think is causing the error?

Jay C
4 years ago
Jay C 4 years ago

Never mind, I'm an idiot. It's not the view, it's a table with almost the same name.  And that table gets refreshed once every 12 hours.  Duh...

Support
4 years ago
Support 4 years ago

And then a screenshot of the Lookup setup.

I can almost guarantee the Lookup is failing due to the valid reason.

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