I am trying to import leads using Manage Member--- Add Members- import files. Assiging new leads through Lead source. But I am not able to import Leads and I am getting the following errors. I dont know what I am doing wrong.
Appreciate any help.
Campaign Members error: _REQUIRED_FIELD_MISSING:Attempted to add a campaign member where either the member id 'null' or the campaign id '7011Y000002AvRB' is null
Leads error: _CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:LeadTrigger: System.LimitException: Too many query rows: 50001:
Thank you
Neeraja
3 respuestas
Hi Neerja,
As Amit mentioned, you have a trigger called LeadTrigger which is failing. The reason it is failing, however, is because it is querying too many records for whatever operation it is performing. Here is what you should do about it:
1. Contact the developer who wrote the trigger, or someone else who can fix it, and explain that the trigger needs to be bulkified and fixed to work with larger data volumes
2. For the time being, to import your files, try importing smaller batches. Don't import the entire file, but maybe just a few hundred records at a time, going lower and lower until you find an amount the trigger can handle.
