Empty reference field but there are sys_id is in

[Archi]

Hello all. Madrid, on-premise.

In cmdb_ci_appl i have 'model_id' field. The field is empty om form but  is in.

Also if i push the button i see information about this application. 

Configure dictionary:

I have this bug on PROD, but on DEV instance all was correct. I checked rows on both instances - they were the same.

Did somebody catch a similar bug?

[Ankur Bawiskar]

Hi,

Does that user have read access to that table/field i.e. product model

check how many fields are having display=true at product model table

any dictionary overrides that are setting the display value to something else?

For which user this is happening?

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Michael Jones -]

That usually means that the record was (perhaps) imported via XML or captured in an update set (forced into one) where the record itself was moved, but not the underlying records found in your reference field. So, since the sys_id does not match a record in your instance, the display value is blank, but the sys_id remains the actual value. If you were to find the missing reference records and import them, the display value would show up. 

So, if your records are the same between DEV and PROD, but in PROD you have no display value, it likely means that the referenced records are missing. If you compare those fields in DEV and PROD, and the sys_id's match, then you'd need to port over those reference records, or set them appropriately in the PROD via script. 

If this was helpful or correct, please be kind and remember to click appropriately!

Michael Jones - Proud member of the CloudPires team!/p>