Devart Forums

Hello,

We have built a SSIS job that runs every night in order to update informations of a Salesforce custom object.
The job post informations about Accounts and Leads with external Ids. When a lead is converted to an account, our job is crashing with this error :

[Salesforce [815]] Erreur : « System.Exception: An exception has occured during data insertion, the message returned from the provider is:

cannot reference converted lead ---> System.Data.InvalidExpressionException:
cannot reference converted lead
à Devart.SSIS.Salesforce.SalesforceDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
--- Fin de la trace de la pile d'exception interne ---
à Devart.SSIS.Salesforce.SalesforceDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
à Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) »


I have identified the converted lead, but I can't figure out why the job is crashing because the created account from the lead looks "normal".

Is there a problem with dotConnect Salesforce or should I search somewhere else ?
We are using dotConnect for Salesforce SSIS v2.5.764.

Thanks for your support.

Adrien

There is no direct way to modify the fields of converted lead: http://salesforce.stackexchange.com/que ... erted-lead.