Item lookup suddenly failing (3 replies)
Can you provide the Lookup expression which you think is causing the error?
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...
And then a screenshot of the Lookup setup.
I can almost guarantee the Lookup is failing due to the valid reason.
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.