1

Am trying to Update Leads.

When Lead converted flag is true.

Lead Status is Contacted. I have to update all the contacted leads to Converted.

Am Getting this error on the data loader:

ERROR: cannot reference converted lead

Maybe because converted leads cannot be updated because they are locked out once they are converted?

Is there a workaround to update Lead Status to Converted from Contacted?

1

Once a Lead is converted it can not be modified via the UI, DataLoader or APEX. However, SFDC Help has a workaround that is documented here.

Here is the doc:

Although converted Leads cannot be updated by design, you can export, modify converted leads externally in Excel, delete the existing leads and then re-import them with changes back into Salesforce as new records.

Note: It is a recommended best practice to ensure that you have a up to date or recent full data export file available before starting this process. See Exporting Backup Data for more details.

  1. Create a Case with support to have the "Create Audit Fields" feature activation enabled for your organization as this will allow you to set the audit fields Created Date and Last Modified Date upon record creation: Include the below information in the feature activation request: a. Organization ID b. Requested feature c. Requested duration d. Business case

  2. Perform an export on your converted Leads with Data Loader. See Exporting Data for more details.

  3. Update the necessary values on the CSV export file from step 2
  4. Delete the converted Leads that you exported in step 2
  5. Import the converted Lead information with the updated .csv file from step 3

Essentially the above creates "new" Leads with the updated information while keeping all of the record associations and date/times of the original Leads.

Note: The Lead ConvertedDate field is a date field while CreatedDate field is a date/time field. You may receive an Error: FIELD_INTEGRITY_EXCEPTION: Converted Date: Converted Date(Sat Sep 06 00:00:00 GMT 2014) Before Create Date(Sat Sep 06 17:17:44 GMT 2014) for Leads that were created and converted on the same day. To correct this error set the affected record's CreatedDate value back one day or their ConvertedDate forward a day. Even if you attempt to change the time attribute of the ConvertedDate field to after that of the CreatedDate field you will still encounter the error because despite whether you may specify a time attribute for a date field, it will always be set to a default value of 00:00:00 GMT or 00:00:000Z on import.

SFDC Help actually has quite a few useful Knowledge Articles dealing with common and not-so common situations.

1

Salesforce introduced a fix to this with Spring 16.

Here's 2 quite helpful links:

  1. Data Loader updates to converted leads causes "ERROR: insufficient access rights on object id"
  2. How can I update Lead fields on converted Leads?

In short: You can update converted lead but it will have to be done via dataloader.

  • You don't have to do so much of the formatting on your own here! Stack Exchange has a pretty robust Markdown syntax. – Adrian Larson Oct 27 '16 at 19:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.