Jump to content

DBLOOKUP2 when no record exists


Glenn Sullivan

Recommended Posts

I have a job processing messages from the message queue from the Dynamics GP MOP1210 table. What I want to do is only process records that have a value in the BINNMBR field of IV00102 for the specific site RLIT.

I figured, no problem, create step logic with DBLOOKUP2:

IF(ISERROR(DBLOOKUP2(S8, "RLIT", "GPAdapter-DCCI", "IV00102", "ITEMNMBR", "LOCNCODE", "BINNMBR")),

SKIPSTEP(),

TRUE()

)

The logic being that, if there item at hand is not assigned to the RLIT site, the DBLOOKUP2 will return a #Null, the ISERROR will return a TRUE and the step will be skipped.

BUT, later on in the data formulas, I use that EXACT same DBLOOKUP command to pull that BINNMBR field and drop it into a SQL table field:

TRIM(DBLOOKUP2(S8, "RLIT", "GPAdapter-DCCI", "IV00102", "ITEMNMBR", "LOCNCODE", "BINNMBR" ))

I FREQUENTLY get failures, and the failure is during the insert of that row, with an error that the destination field does not accept NULLS! If that DBLOOKUP2 command returned a NULL, why did the step even process

I am very confused... and it is real hard to troubleshoot this, as it is reliant on messages coming through the message queue from the publisher...

Thanks in advance!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...