Update set error - Could not find a record in sc_cat_item_delivery_plan for column delivery_plan referenced in this update

[Nathan Dupuis]

Hi everyone,

This evening, were committing an update set to our production environment. This will be to create a new widget, and add it to the service portal.  There is 1 error listing, and I can't seem to figure out how to fix it.

The error is: 

Could not find a record in sc_cat_item_delivery_plan for column delivery_plan referenced in this update

Any thoughts on this? Should I skip this update?

Due to an issue, we created this update set in a test environment, so we are unable to test the functionality prior.

Thank you,

Nathan

[RAHUL Khanna1]

Try open the table "sc_cat_item_delivery_plan" and see the record of your intresst in that record ..."delivery_plan" might be referencing value would be there, i think that record is missing ....it would show the sys id also ...can you place the exact screen shot of the error.

[BryanS413339635]

Go to the catalog item and see what is in the execution plan. Sounds like that execution plan doesn't exist in Prod and/or didn't get captured in the update set. 

[MrMuhammad · Accepted solution]

Execution plan is missing that is being referenced in the catalog item captured. If you think execution plan is not required then you can just accept the remote update and you are good to go. 

you can also, look into below thread

https://community.servicenow.com/community?id=community_question&sys_id=3af647e5db1cdbc01dcaf3231f96...

Thanks & Regards,

Sharjeel