Can't publish Record Producer that is checked out in Catalog Builder

[kimreverman]

Greetings,

I have a record producer that appears with state of "Publishing" without the buttons "Edit in Catalog builder" nor "Cancel Checkout":

 

In Catalog Builder the record producer appears twice.

We can edit the item, click on the submit, but it reverts back to this.

Any help is appreciated.

Kim

[Vasantharajan N · Accepted solution]

Step 1:

Go to Record Producer page and Filter your catalogue Item

https://instance-name.service-now.com/nav_to.do?uri=sc_cat_item_producer_list.do?sysparm_query=&sysparm_first_row=1&sysparm_view=

Step 2:

Delete the in active record record (i.e., In Catalog builder it's state will be Draft)

Step 4:

Open the active record now.

Step 4:

Please check whether you are able to see the UI buttons on the form and the message highlighted.

Step 5: 

If you are able to see the UI button, then you can cancel checkout or edit item in Catalog builder and submit to publish it.

else

Please use the below backgroud script to update the state to published for your record producer.

Please update the sys_id marked BOLD in the script to your record producer sys_id 

var gr = new GlideRecord("sc_cat_item_producer");

if(gr.get("2d8582fd2f1020108cb85ff62799b6fc")){
gs.print(gr.state);
gr.state = "published";
gr.setWorkflow(false);
gr.update();
}

 After running this script, you will definitely see the UI buttons back on the form. 

[kimreverman]

Greetings Vasantharajan,

Thank you!

What I did with your steps...

1. Followed successfully.
2. Followed successfully.
3. Followed successfully.
4. On "Step 4" the UI Buttons were still not visible.
5. Could not cancel checkout. 
   Proceed to run fix script with the appropriate sys_id.
   As "admin" I could not cancel checkout.  However, the item owner was able to open record producer in Catalog Builder and cancel checkout.

Thank you! 

[Bruno Moreira1]

Hi. I have the same issue. How can you resolved it ? 

[Vasantharajan N]

@Bruno Moreira1 - Could you please check flow designer execution for subflow "Catalog Builder - Item review base flow" and understand the error why it's reverting to Draft instead of publishing it.