Workflow retire publish sys id missing in knowledge base

[NityaB161013953]

When previewing the update set batch on the Zurich instance, I am getting 4 preview errors under the "Preview Problems for Batch" tab.

Error Message:

Could not find a record in wf_workflow for column workflow referenced in this update.

Could not find a record in wf_workflow for column retire_workflow referenced in this update.

Affected Records:

• kb_knowledge_base_307561d1dbac7110b14850... — both workflow and retire_workflow missing
• kb_knowledge_base_8fa74e87dbd4bd10b14850... — both workflow and retire_workflow missing

These are custom Knowledge Base records included in the update set (not OOB). They were configured on the source instance with legacy wf_workflow based publish and retire workflows.

[Sanjay191]

Hi @NityaB161013953 

Could you please check whether the missing workflow exists in the lower environment? If it is present there, then please verify whether the same workflow is available in the higher environment where you would like the changes to be migrated.

[Tanushree Maiti]

Hi @NityaB161013953 

KB0818946 Update Set Preview Error: Could not find a record in wf_workflow for column workflow refer... 

Check this solution for your Knowledge table.

Resolution

• The error means that the instance is expecting the wf_workflow record, associated with the sc_cat_item record.
• Please import the workflow to the current instance and then run the preview again.
• You can do this via another update set import.
• The sys_ids of the wf_workflow and the associated sc_cat_item can be found in the Update Set Preview itself

[Tanushree Maiti]

Hi @NityaB161013953 

These Update Set preview errors mean your target instance is missing the specific workflow records that your Knowledge  update set is trying to reference.

To fix this issue:

1. Export the missing workflows from the source instance as an XML file (e.g., from the wf_workflow table).
2.  Import the XML file directly into your target instance.
3.  Run the Update Set preview again in your target instance.