The document is stuck in Pre-release status with batch job error.
Background:
The document is stuck in Pre-release status with a batch job error as shown below.
Database.Error[getFields=();getMessage=compliancequest.SQX_Controlled_Document_Trigger: execution of BeforeUpdate
caused by: System.DmlException: Delete failed. First exception on row 0 with id 069###############; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, This content cannot be deleted since it is part of audit trailed record(s): ##################: []
(compliancequest);getStatusCode=CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY;]
This issue occurs in CQ v9.2.4 and is resolved is CQ v9.2.5. The issue will occur for the documents that were created before applying v9.2.5 or higher version.
Solution:
The only option is to delete the content link by following the below steps by the system administrator.
SELECT compliancequest__LinkedEntityId__c, Id, compliancequest__ContentDocumentId__c FROM compliancequest__CQ_Content_Link__c where compliancequest__LinkedEntityId__c ='Id of the document' AND compliancequest__ContentDocumentId__c = 'Id of the content'
28 Dec 2022, 08:23 PM
|