QUESTION:
I am getting the following error when attempting to process a file in PeopleImport. How can I resolve?
2011-07-28T10:48:22-04:00,,"",,Insert,,,,," Message: MyLeadTrigger: System.LimitException: Too many script statements: 200001 Status code: 13"
ANSWER:
This type of error occurs when some type of custom APEX code (in this example a trigger called "MyLeadTrigger"), has not been properly optimized for batch processing. Specifically, this error is encountered when APEX code exceeds the "Total number of executed code statements" limit during run time.
The same error will occur if inserting/updating the same groups of records via the Salesforce Data Loader.
To resolve:
Search Salesforce solutions on how to fix the trigger, which is one option to resolve the error.
Lower the "Update/Insert Batch Size" setting in the PeopleImport Options menu; this may allow the processing to complete successfully (select the "Options" button on the lower left). The default setting is 100, but can be set as low as 1. Keep in mind that the smaller the batch size the more API calls will be used per insert/update. There is a limit imposed by Salesforce on how many API calls are allowed in a 24hr period.
