Catalog Orphaned Records

34 Views

Hi All,

We are running SRM 5.5. with CCM 2.0 and have the following issue.

When we run the program \CCM\CLEANUP_MAPPING with no commit, it finds many orphaned records in our Master catalog and Procurement Catalog.

Although these errors do not appear to be causing any problems for our user community I would never the less prefer to remove them.

When we run the program outside of normal working hours with commit on to try and remove the errors

we get the error message

Exception occured

^ Error during catalog update 4400000047; catalog is locked by CATALOG_ENRICHMENT/491035F93F6E67C7E10000000A003214

Has anyone any ideas on how to resolve the orphaned records problem or what to do to remove the lock?

Thanks in advance

Allen Brooks

SRM BPO

Sunderland City Council