Reference record with sys_id but no display value

[sruthi1]

Hello,

I have a functionality where servers are imported into the system through import set. When server data is imported software installation records are automatically created. In this scenario there are some records with empty display value for "installed on"(reference: server) but contains sys id.

In this screenshot the installed on value is shown empty but when I group by installed on we can see there is sys id for that field.

Kindly help with this issue.

Thanks,

Sruthi

[Oliver Stammler]

Hey @sruthi1,

there are two possibilities for this behavior.
First, have you checked that the display value field has a value? It could be possible that the for example "name" field is simply empty and therefore not shown.

The second option is that this record was deleted. 
It is possible, especially if records were created/updated by scripts including setWorkflow(false), that the reference was not correctly deleted and therefore the sys_id is still available for this reference but no display value since the record is deleted. 
In this case you often see the "i" button next to the reference field but if you click on it the sys_popup view shows "Record not found" since it was deleted.

In you case you eventually imported these records with an invalid sys_id for installed on. 

Best regards
Oli

[sruthi1]

Hello Oli,

Thanks for reply, we have imported server data, one of it is having state error in staging table. In the staging table target record is shown empty but it have sys id when I did show matching on the column. Is it possible that imported record with error are created and deleted again?.

I observed same sys id in the software installation record.

[Oliver Stammler]

Hey,
have you tried to open the record with this sys_id on the corresponding table? 
Is the record available or not? 

Best regards

Oli

[sruthi1]

I have checked if the sys id in the Server table but didn't find any records