/CCM/CLEANUP_CATALOG won't unlock the catalog

[Former Member]

I have been using this transaction, but some catalogs seem to get 'corrupt' beyond repair (cleanup) and are no longer accessible. Is deletion and recreation the only way to proceed? I have done it once, but I can't imagine doing it consistently in production with thousands of items.

[former_member184214 · Accepted solution]

Hello,

information about the catalog status is held in table /CCM/D_CTLG_REQ.

If your catalog is locked by UI (i.e. publishing) try report /CCM/CLEANUP_UPDATE_STATUS.

HTH

Gordan

[Former Member]

Hi Greg,

I have also come across this issue where /CCM/CLEANUP_CATALOG does not seem to unlock the catalogues. To get around this I have had to do the following:

- Look in table /CCM/D_CTLG_REQ for your catalog and look for the one without active flag.

- In /CCM/CLEANUP_CATALOG, I used the "delete catalog" option for that specific catalog and ticked the "Inactive version". This will remove that entry from the table above.

- Then run /CCM/CLEANUP_CATALO again and use the "unlock catalog" for that catalog for all versions (Active, Inactive, Last).

This usually works for me.

Regards,

Paula.