How to fix failed promotion in Documentum Compliance Manager?

Use the following steps:



1. Get the object id of the controlled document that failed with promotion. Make sure you have the correct ID if the Controlled Document is a non-current version.

2. In DQL run the following query to find the status of the promotion:


select status from dcm_process_relation where relation_name = 'dcm_promote' and parent_id = '{OBJECT ID From step1}'

The status should be "Pending', if this is the case, run the following DQL to update the status:

update dcm_process_relation object set status = 'success' where relation_name = 'dcm_promote' and parent_id = '{OBJECT ID From step1}'

3. Retry promote.