To repro:

- Create a GPAT assay design
- Have one field (in run is easiest, but works for result, too) be a lookup to a data class with the lookup validation turned on
- Try and import a new run
- Error (on mine) says:
dataClass: Value '386052.0' was not present in lookup target 'exp.data.Thing' for field 'dataClass'

Since I'm choosing the lookup through the dropdown in LKS, I would expect this to resolve, which it does when lookup validation is turned off but doesn't when the validation is turned back on.

I saw this with the client for assay request lookups as well as list lookups.

I think this is something we need to prioritize for 21.2 as it is blocking work.

Karl, could you help me assign this to the appropriate dev to estimate please?

This looks like there is a conversion error getting introduced, the validation is failing because we are comparing the float value to the rowid integer value 111.0 != 111

I did some investigation and this issue also shows up in both the 20.7 and 20.11 releases, I didn't regress it far enough back to see if this ever worked.

Specifically, if you have a run level lookup to another table with an integer PK field AND set the field to validate the lookup then you will see the problem, so maybe this suggests that the repro is narrower than previously suspected.

As Hannah and I discussed, we'll shift the milestone to 21.3 since it appears that there was no regression.

merged

Verified.