NONPROFIT-CLOUD-CONSULTANT practice question 25 of 35

A nonprofit wants to migrate millions of Contact records from a legacy system. Most records fail to import with the following error: "npsp.TDTM_Address: System.LimitException: Apex CPU time limit exceeded". Which three actions could a consultant take to successfully import this data? Choose 3 answers

Full set: 268 questions
Answer options
A: Enable "Simple Address Change Treated as Update' in Address Settings.
B: Check 'User Managed' on the Address TDTM record.
C: Disable all automation and load the Address object separately. Correct answer
D: Disable 'ADDR_Addresses_TDTM' Handler in Trigger Configuration. Correct answer
E: Reduce the batch size significantly when addresses are included. Correct answer
Correct Answer:
C. Disable all automation and load the Address object separately.; D. Disable 'ADDR_Addresses_TDTM' Handler in Trigger Configuration.; E. Reduce the batch size significantly when addresses are included.
Explanation

When migrating millions of Contact records and encountering the error "npsp.TDTM_Address: System.LimitException: Apex CPU time limit exceeded," you can take the following actions: Disable Automation: Go to NPSP Settings. Navigate to "TDTM" (Table Driven Trigger Management). Disable all automation triggers temporarily to ensure they do not interfere with the data load process. Load Address Object Separately: Split the data load into two parts: first load Contacts without address data, then load address data separately. This reduces the complexity and processing required for each batch. Disable ADDR_Addresses_TDTM Handler: In NPSP Settings, go to "Trigger Configuration." Locate the 'ADDR_Addresses_TDTM' handler. Disable this specific handler to prevent it from executing during the data import process. Reduce Batch Size: When using Data Loader or any import tool, set the batch size to a significantly lower number (e.g., 100 or 200 records per batch). This helps in managing CPU limits and ensures smoother processing. By following these steps, you can mitigate the Apex CPU time limit issue and successfully import large volumes of data into NPSP.
Reference: Salesforce documentation on managing Apex CPU time limits. Nonprofit Success Pack (NPSP) documentation on Trigger Management and Data Import.

Scroll to Top