Could not find a record in sc_cat_item for column cat_item referenced in this update

[Leonardo Ferrar]

I am trying to import an xml updateset but the following conflict is going on. How can I adjust it?

[Michael Jones -]

Well, that would indicate that an update you are trying to push is referencing a Catalog Item that doesn't exist in your target system. Usually seems to happen when something like a variable ends up modified in an update set that gets pushed before the update set with the actual catalog item. You would want to examine the record, find the sys_id of the sc_cat_item that is missing, then determine if that item is one you plan to deploy, or not.

If you plan to deploy it you can usually accept the remote update and when you later deploy, the reference should be set. If it's not one you plan to deploy, you would want to skip the update. 

Otherwise, you would want to find the missing update and merge it your other update and deploy them together. 

Hope this helps!

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

Michael Jones - Proud member of the CloudPires Team!

[DirkRedeker · Accepted solution]

Hi

You need to make sure, that the target system has the referenced Catalog Items records in the table [sc_cat_item].

Remeber to copy over the Catalog Items from your source system to your target system as well. If you recreate them in the target system, they will get different sysIDs, and the reference will also be broken.

Let me know if that answers your question and mark my answer as correct and helpful.

BR

Dirk