+ Start a Discussion
craigmhcraigmh 

Issue with Deleting Records

I've had an issue with deleting records, which I thought was caused by the size of the batches. But when I run this in the System Log:

 

delete [Select Id From CustomObject__c Limit 1];

 

I get this error:

 

EXCEPTION_THROWN|[1]|System.DmlException: Delete failed. First exception on row 0 with id xxxxxxxxxxxxxxxxxx; first error: UNKNOWN_EXCEPTION, Operation affected too many rows: []

 

How is it possible that one row is too many? Is there a daily limit for DML rows?

 

bob_buzzardbob_buzzard

This can happen for a couple of reasons:

 

(1) There is a trigger or triggers that is deleting other records

(2) CustomObject__c is the master in a master-detail relationship, and there are a large amount of detail records that would be deleted as part of this. 

 

There's a limit of 10,000 records affected by DML in a single transaction.

craigmhcraigmh

sorry, I should have specified what I tried before coming here.

 

the instance I'm working also has no triggers. also, there are a number of lookup fields pointing to CustomObject__c, but no actual records that aren't null for those fields, and there are no master-detail fields pointing to it. I was thinking a cascade may have been the cause, but once I saw there was nothing that would be deleted as a result, I eliminated that as a possible cause.

 

I was thinking that it may be a daily limit since I am working with a Professional Edition instance (API-enabled), and we are using the API to move a lot of data over.

 

I did find a way to get around this (removing the object, didn't need to persist the data), although that's not exactly a resolution. more of a work-around.

 

thanks for your help.

Lori@GSPLori@GSP

 I do want to cascade delete, but how can I workaround the 10K limit? Thank you