Error in retrieved update set

[padmaja9]

Hi Team,

On opening the retrieved update set, got the below errors. 

1. "Could not find a record in cmn_schedule for column schedule referenced in this update"

I believe this is due to unavailability of some schedules in target instance which i have created in remote instance.

2. "Could not find a record in domain for column sys_domain referenced in this update" and this got trigegred for an notification update in remote instance.

Can you please help me how to over come these errors and obtain the missing schedules and records in target instance also.

Regards,

Padmaja.

[Mark Roethof]

Hi there,

So if you open the record concerned. What is the value in field sys_domain? And is that sys_domain actually already on the environment where you want to commit this update set (the error indicates: no)? So the field, which is referenced in your sysevent_email_action record.

And same applies for the first one concerning cmn_schedule.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Willem · Accepted solution]

1. Make sure you transfer the Schedule that is referenced. You can export and import via XML or force it into an update set.

2. Check the domain field of the email. Is that domain available in your target system? If not, do you want to use domains?

If you do not want to use the domain, you can Accept remote update and check if it works.

[padmaja9]

Hi Willem,

i have imported xml of the schedule from dev to prod instance. Again i have retrieved completed update sets from dev and opened the required update set. 

I can still see the same errors and not able to see the "run preview again button" in retrieved update set.

I have verified that the imported schedule is present in the prod instance but still getting same error when retrieved again and not able to preview it again. Please help me on next course of action.

Regards,

Padmaja.

[Willem]

If you are sure the schedule is now available, just select Accept remote update and submit the update set.

After testing you can see if any of the required field is empty/missing and transfer them afterwards as well.