I have an item that was edited in Catalog Builder, then submitted. It's status immediately went to "Checked Out". After waiting a few hours, I looked again and it was still "Checked Out". I attempted to edit it and got the message you see below.
I went and looked at the Record Producer in Maintain Items and there it said it was in the process of being published. There was no button to "Cancel Checkout".
I waited another 12 hrs and nothing changed. It still said "Checked Out" in the Catalog Builder and "Publishing" in Maintain Items. I went to look at the Record Producers and saw 2 entries, on is the one publishing, the other says "Reviewed".
Neither will let me let me update them, change their status, or generally do anything. Any suggestions to resolve this? Thanks!
Hey Josh,
I used to run into this issue quite often and we use Tokyo. Here is the fix, follow the steps below. You will need admin access to complete these steps.
- Give it a few mins for all your updates to the catalog item to actually save.
- Refresh/Reload catalog builder page a few times, if the state continues to show as Checked out, go to next step.
- Use Context menu to copy the sys_id of your catalog item.
- Open your instance in another browser, Navigate to System Definition -> Scripts - Background
Be sure to replace the sys_id place holder with your sys_id obtained at Step 3. Run this script.
var cat = new GlideRecord('sc_cat_item');
cat.addQuery('sys_id=your_Sys-ID_here');
cat.autoSysFields(false); //Will avoid updating System. fields of the table used
cat.query();
if(cat.next()){
cat.setValue('checked_out',false); //Will set Checked out state to False
cat.setWorkflow(false); //Will override any related Business Rules from stop the updates
cat.update();
}
After running this script, Checked out state of the catalog item will be set to false and this item will again be available for edits and tests. This method has worked for me. Also, I noticed all the updates I had made to the catalog item before executing this script were saved.
