Attach workflow to catalog item

thanuja
Kilo Contributor

Hi,

I have created a workflow and attached to a catalog item and captured in a update set in Dev instance. 

now I have moved that to test environment, when i am clicking on previewed it is showing an error : "Could not find a record in sys_user for column owner referenced in this update”. But in the workflow I haven't used any sys_user table in workflow, i assigned fullfillment task to a group which is present in the Test environment

Please refer the below attachments

 

@Ankur Bawiskar 

5 REPLIES 5

Mark Roethof
Tera Patron
Tera Patron

Hi there,

The error concerns the value in the owner field of the sc_cat_item. So check what the value is (for example check the XML). It's not a critical issue, so you could also ignore it, though better ofcourse to analyze it a bit to understand what's going on.

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

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

---

LinkedIn
Community article, blog, video list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Mohith Devatte
Tera Sage
Tera Sage

Hello ,

Please check there is a field called "Owner" on the catalog form or maintain item and you must have given a owner value in that field but that user record is not present in the target instance so it is saying record not available for the column owner referenced to sys_user table.

for this you can take the xml of the sys_user record given in that field and import that xml into the sys_user table in the instance where you are commiting the update set and then try to preview the update set again

Please accept the solution or mark it helpful if it answers your question.

thanuja
Kilo Contributor

I have used sy_user table as a reference field for a variable (Requested_for) in a catalog form. Except there i haven't used anywhere in the form and in the update set xml (in which i captured attaching workflow to a catalog form) there is no sys_user table

i clicked skip remote update to commit in Test environment but workflow was not attached to catalog form

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

If you have skipped that record then it should work fine still

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader