Catalog item stuck in publish

[Thomas Knight2]

Every item I try and publish from catalog builder seems to get stuck. In catalog builder it states checked out. Within in maintain items it states that it is being published.

There is also a draft version that is not active, but I can't remove this delete or active it.

Not sure when this behaviour started, has anyone else experienced anything similar? 

[Miguel Donayre · Accepted solution]

Hello,

This is a known issue that should have been fixed in Rome. 

Look at this support article.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0965279

If you are still having issues I suggest opening a HI Support ticket.

[JSM91]

Not fixed in Rome, we are on Vancouver. For anyone looking for a solution, here's how I got it to work .. and I tried everything from removing the audit (like one support article recommended), editing the state in list view, reverting versions, etc. My fix was exporting the sc_cat_item in XML, modifying the checked_out, allow_edit, and state fields, then re-uploading.. Hope it helps.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1166254

[dlwillequer]

Just spent a few hours troubleshooting this very issue in a coworker's lab instance for the CSA course on Vancouver on Lab 5.2. 

Ultimately I ended up creating it via the Catalog Builder, Submitting it to get to In Review, cancelled review to return to draft, created a new import set, added the catalog item to the update set, went to the import set and viewed the xml for the sc_cat_item that was added to the update set, modified the value of "state" inside the XML to "published" and updated that record within the update set. Marked the update set as complete, exported the update set as XML, imported it into Retrieved Update Set then tested and committed the update set.

Once I did that - It was in a published state and I was able to click the "Active" flag.

Probably a simpler way to go about achieving what I did above but I learned a lot in the process including how to repair plugins, repair indexes, Install modules, update modules, view all system logs, view all form policies / configurations simultaneously and enable flow execution logs across the board. Not sure if that last one has a performance impact but it provides a lot more detail.

Ultimately - the problem appeared to be with one of the related subflows not properly executing and getting stuck in a "Queued" status. 

The subflows I found to be related were "Catalog Builder - Item review base flow" and "Template: Catalog Builder - Item review".  

[KishorJadhav]

I had similar issue while doing Lab 5.2 of ServiceNow Administration Fundamental, it was stuck in 'in review' stage and was not able to activate it. Checked length of 'script' column it was 4000. In one of the blog it was mentioned that it moved to Published state automatically, so waited for a day and service catalog got published automatically. Issue resolved for me. But it needs to be investigated as why it gets stuck in 1st place.