The Problem
Sometimes when using Venio, a custodian deduplication task may become stuck, indicated by a lock on the custodian deduplication process. When this happens, you will not be able to proceed with the deduplication for the affected custodian.
The post processing status in the Project job status UI says 'Custodian Dedupe Lock'
Resolution
If you encounter this issue, you can manually unlock the custodian deduplication task using the following SQL query:
UPDATE tbl_ex_custodian WITH(rowlock)
SET custodiandedupelockholder = NULL,
custodiandedupelockholdermedia = NULL,
custodianduponprogress = 0
WHERE custodianid = <replace_with_custodianid_of_stuck_job>
Replace <replace_with_custodianid_of_stuck_job> with the ID of the custodian for which the job is stuck.
How to Find the Custodian ID
You can find the custodian ID to which the media belongs in the tbl_ex_media table. You can run a select query on this table to identify the custodian ID associated with the stuck job.
Please proceed with caution when manually updating values in the database and only do so under the guidance of a system administrator or a member of the Venio support team. If you are uncomfortable with or unsure about this process, please contact Venio's support team for further assistance.
Comments
1 comment
Thank you!
Please sign in to leave a comment.