There are five possible cases when this type of error happens.
Cases:
1. Content size exceeds 25 MB.
2. Content is protected (password).
3. If the Content file is deleted -> Go to Recycle Bins and search for the Content by Title and Restore it.
4. If there exist Rendition log -> a) Open up the Developer console
-> b) Go to Query Editor and Paste below Query
SELECT Id, compliancequest_SQX_Controlled_Documentc FROM compliancequestSQX_Rendition_Logc where compliancequestSQX_Controlled_Document_c = 'Id of the affected document'
(Note: Change the 'Id of the affected document')
-> c) Click Execute
-> d) Select all the rows and click on the Delete Row button and click Yes to confirm
-> e) Go back to the Document and click Regenerate Secondary Content
(Note: Give some time for it to work and it should work if not then we need to follow step 5)
5. If no batch jobs are scheduled for rendition -> a) Go to Setup > Scheduled Jobs
-> b) Delete the batch jobs responsible for rendition
-> c) Go to Developer console and Open Execute Anonymous Window from Debug tab and Paste the script below
new compliancequest.SQX_Document_Scheduler().execute(null);
-> d) Click Execute
-> e) Go back to the Document detail page and click the Regenerate Secondary Content button


=============================================================================================



Anil Bhandari
13/Apr/22 4:37 PM

Hi jfranks@choicespine.com ,

After checking the Batch Job process, we found that “CQ-Document Rendition Retriever” is missing from the list. 

Please let System Admin follow the steps (case 5 in the provided instruction) as below:
1. Goto Setup and type in and select Scheduled Jobs. (please refer to the screenshot below)

2. Delete CQ-Document Rendition Status Checker. As you are missing CQ-Document Rendition Retriever, you do not delete this otherwise you need to delete this too. 

3. Goto Setup and select Developer Console. 

4. In the Developer Console, Open up Debug and select Open Anonymous Window. 

5. Paste the code in the window and click on Execute.

1new compliancequest.SQX_Document_Scheduler().execute(null);

6. Goto Setup > Schedule Jobs (step 1) and check for CQ-Document Rendition Retriever and CQ-Document Rendition Status Checker.
This should solve issues with regenerating secondary content. Please let us know if you need any further assistance.

Regards,
Anil Bhandari


====================================================

====================================================

We had checked the record and found that auto submit for approval was Hold, we had to change the status to False then regenerated the secondary content.

Steps to check if the auto submit for approval status.

  1. Go to Developer Console and execute the given query.
SELECT Id, compliancequest__Auto_Submit_For_Approval__c FROM compliancequest__SQX_Controlled_Document__c where Id = 'Id of the Document'
  1. Check the value for compliancequest_Auto_Submit_For_Approval_c.
  2. If the value is Hold. 
    1. Double click on compliancequest_Auto_Submit_For_Approval_c and change the value from Hold to False.
  3. Go to the document record and check the rendition error and the field if there is any errors.
  4. Click on regenerate the secondary content.