Could not find a record in sn_gsm_government_service_model for column u_service_offering referenced

[ztb1997]

I have the above conflict in an update set (see above image). I can also see this is for a record producer I am working with as it says Type: Record Producer, and I can see the record producer's script in part of the XML (see image below):

What is ServiceNow not liking and what is the issue and a potential solution? Please leave a comment requesting more information if need be and I will get back to you ASAP. Thanks!

[Rohit Singh]

Hi @ztb1997 ,

Is u_service_offering is a variable in your record producer or is it a field in your table where record producer is created? Seems like u_service_offering is not captured properly in your update set. 

If it is a field in your table then check if this field is available in the your target instance already (if it is not  captured in your update set). 

Can you clink on Find missing record and share snip.

Regards,

Rohit Singh

[ztb1997]

No, that is not a variable in my record producer. And also, it is not a field on my table either... Here is what I get when I click on "find missing record" this message is given: "Record not found". Would you like any more information?

[Robert H · Accepted solution]

Hello @ztb1997 ,

What this message is saying is that, in your Record Producer, there is a field called "Service offering" where records from the "sn_gsm_government_service_model" table can be selected.

The developer who created this particular Record Producer in the development instance selected one of these records, but that record does not exist in the ServiceNow instance where you are trying to commit the Update Set.

In order to resolve this you need to find this Record Producer in the development instance, check which "Service offering" record is selected, and then export that record as an XML file, and finally import that file into the target instance.

If you now re-run the Update Set preview the error will be gone. If you already committed the Update Set then that's no problem, the Record Producer in the target instance will still have it's "Service Offering" populated now.

Regards,

Robert

[ztb1997]

Great, thanks!