System.LimitException: Apttus_Config2: Too many DML rows: 10001
This exception occurs when you try to perform DML operations on more than 10000 records at a time.
DML is different than SOQL. DML is the process typically used to insert, update, upsert, or delete records; SOQL is the query language used to return rows. Per the governor limits, the maximum number of records retrieved by SOQL queries is 50000. The maximum number of records processed as a result of DML statements, Approval.process, or database.emptyRecycleBin is 10000.
Sample Business Use Cases
- The Hierarchy View update job displays the Too many queries error, which has impacted the price book and display of products (products are not displayed under the correct categories on the catalog).
- When adding items to the option group Destination Sets in CPQ Admin Console in Production, an error is received for the Bundle LOGIQ S8 R3 (ULS_PCL_GI_0025).
Best Practices
- A separate class implementing the Database.Batchable interface allows CPQ to handle DML in batches of records.
- You can use <apex:actionPoller> in a Visualforce page.
- If the trigger has DML functionalities for many rows (more than 10000), it must be in Batch Apex.
