Apex – DML Operation Delete Not Allowed: How to Fix

I am receiving the following errors:

DML operation Delete not allowed on List<AccountHistory>
DML operation Delete not allowed on List<ContactHistory>

List<ContactHistory> conHis = [SELECT id, ContactId FROM ContactHistory];
delete conHis; 

List<CaseHistory> caseHis = [SELECT id, CaseId FROM CaseHistory];
delete caseHis;

Best Answer

You can't ordinarily delete field history before you Enable delete of Field History and Field History Archive. Therefore, if you try to deploy this code to an org without this feature enabled, you'd get this error. The change set is presumably correct. This is generally true for all kinds of optional features in Salesforce. You can't deploy code that would violate the configuration settings for the org (e.g. trying to modify share records with Public Read/Write enabled). Enable the feature and try the deployment again.

Related Solutions

[SalesForce] How to delete latest version from ContentDocument

Yes, all the version will be deleted, check the doc here, ContentDocument

'When you delete a document, all versions of that document are deleted, including ratings, comments, and tags.'

Yeah, there is no standard way to do this. But you can copy the latest version to a new file, and delete all the old version, like this,

ContentVersion oldCV = [Select Id, VersionData, PathOnClient, ContentUrl, Title, PublishStatus, Origin from ContentVersion Order By CreatedDate Desc Limit 1];

ContentVersion newCV = new ContentVersion();
newCV.Title = oldCV.Title;
newCV.PathOnClient = oldCV.PathOnClient;
newCV.ContentUrl = oldCV.ContentUrl;
newCV.VersionData = oldCV.VersionData;
newCV.Origin = 'H';
insert newCV;

[SalesForce] ‘DML operation DELETE not allowed on AccountHistory’

It is very risky, but apparently there is a known workaround: delete and recreate the affected Account.

Before you take any actions, back up all data. Make sure this includes all child data.

If you have a small number of records, you can clone them in execute anonymous (don't preserve id), delete the existing records, then insert the clones.

Best Answer

Related Solutions

[SalesForce] How to delete latest version from ContentDocument

[SalesForce] ‘DML operation DELETE not allowed on AccountHistory’

Related Topic