2

i'm trying to migrate XConnect contact data to salesforce CRM using Data Exchange Framework (Connect for salesforce 2.0.1)

After clicking "xConnect Contacts to Salesforce Sync" no error message shown but my contact data is not mapped into salesforce.

below i attached my log file. i didn't know why this happened

ManagedPoolThread #14 11:54:31 INFO [Data Exchange] Starting pipeline batch processing. (pipeline batch: xConnect Contacts to Salesforce Sync) ManagedPoolThread #14 11:54:32 INFO [Data Exchange] Entities were read from xConnect. (total count: 2) (pipeline: Read Contacts from xConnect Pipeline, pipeline step: Read Contacts from xConnect, pipeline step identifier: 0743d433-c141-4256-a27f-c8a967b18199, endpoint: xConnect Client Endpoint, entity: contact) ManagedPoolThread

14 11:54:32 DEBUG [Data Exchange] Pipeline step is configured not to look for an existing object. (pipeline: Process Single Contact from

xConnect Pipeline, pipeline step: Fake Resolve Salesforce Contact, pipeline step identifier: c2290ab8-eca3-41ff-9356-a719600a227b, identifier: 938f8692-1842-0000-0000-05790af6ac83) ManagedPoolThread

14 11:54:32 DEBUG [Data Exchange] At least one value mapping failed. (pipeline: Process Single Contact from xConnect Pipeline, pipeline

step: Apply Mapping from Contact Model to Salesforce Contact, pipeline step identifier: 6622f7fb-8b13-4bb9-8673-471183dd48fb, mappings that failed: 1, value mapping ids: 28f2187f-201f-4ba6-8c23-733288fbd0f9) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] Iterable data is null. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Iterate Salesforce Results and Run Pipelines, pipeline step identifier: 0777f0a2-2932-45b0-8cd6-4a95c8ce5f0a) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Iterate Salesforce Results and Run Pipelines, completed pipeline steps: 4) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] Pipeline step is configured not to look for an existing object. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Fake Resolve Salesforce Contact, pipeline step identifier: c2290ab8-eca3-41ff-9356-a719600a227b, identifier: df1108eb-bde1-0000-0000-0578d92f6ec4) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] At least one value mapping failed. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Apply Mapping from Contact Model to Salesforce Contact, pipeline step identifier: 6622f7fb-8b13-4bb9-8673-471183dd48fb, mappings that failed: 1, value mapping ids: 28f2187f-201f-4ba6-8c23-733288fbd0f9) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] Iterable data is null. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Iterate Salesforce Results and Run Pipelines, pipeline step identifier: 0777f0a2-2932-45b0-8cd6-4a95c8ce5f0a) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Iterate Salesforce Results and Run Pipelines, completed pipeline steps: 4) ManagedPoolThread #14 11:54:32 DEBUG [Data Exchange] 2 elements were iterated. (pipeline: Read Contacts from xConnect Pipeline, pipeline step: Iterate xConnect Contacts and Run Pipelines, pipeline step identifier: 3b07fc71-3687-497a-b2cc-5005249ebb61) ManagedPoolThread

14 11:54:34 ERROR [Data Exchange] Exception raised while submitting Batch to Salesforce ManagedPoolThread #14 11:54:34 ERROR [Data

Exchange] One or more errors occurred. ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] at System.Threading.Tasks.Task1.GetResultCore(Boolean waitCompletionNotification) at Sitecore.DataExchange.Providers.Salesforce.Queues.BaseSubmitQueuePipelineProcessor.SubmitBatch(PipelineStep pipelineStep, PipelineContext pipelineContext, OperationType operationType, List1 inputList, ILogger logger) ManagedPoolThread #14 11:54:34 ERROR [Data Exchange] FeatureNotEnabled ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] at Salesforce.Common.XmlHttpClient.d__c1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Salesforce.Common.XmlHttpClient.d__81.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Salesforce.Force.ForceClient.d__31.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Salesforce.Force.ForceClient.<RunJobAsync>d__161.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Salesforce.Force.ForceClient.<RunJobAndPollAsync>d__1e1.MoveNext() ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] 0 elements were iterated. (pipeline: Read Contacts from xConnect Pipeline, pipeline step: Iterate Salesforce Results and Run Pipelines, pipeline step identifier: 9df0b97c-d1d9-4412-afc0-630a023d0929) ManagedPoolThread

14 11:54:34 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Read Contacts from xConnect

Pipeline, pipeline step: Submit xConnect Batch, completed pipeline steps: 7) ManagedPoolThread #14 11:54:34 INFO [Data Exchange] Entities were read from xConnect. (total count: 2) (pipeline: Read Contact Interactions from xConnect Pipeline, pipeline step: Read Contacts from xConnect, pipeline step identifier: 65787491-b016-4362-b951-20efa038d622, endpoint: xConnect Client Endpoint, entity: contact) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] 0 elements were iterated. (pipeline: Process Interactions for Single xConnect Contact Pipeline, pipeline step: Iterate xConnect Interactions and Run Pipelines, pipeline step identifier: e5f3a442-4f1e-4619-b16a-ad43793287ea) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Process Interactions for Single xConnect Contact Pipeline, pipeline step: Iterate xConnect Interactions and Run Pipelines, completed pipeline steps: 2) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] 0 elements were iterated. (pipeline: Process Single Interaction from xConnect Pipeline, pipeline step: Iterate Events and Run Pipelines, pipeline step identifier: ca53669a-7feb-41c4-a3c7-2aaf72784bec) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Process Single Interaction from xConnect Pipeline, pipeline step: Iterate Events and Run Pipelines, completed pipeline steps: 3) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] 0 elements were iterated. (pipeline: Process Single Interaction from xConnect Pipeline, pipeline step: Iterate Events and Run Pipelines, pipeline step identifier: ca53669a-7feb-41c4-a3c7-2aaf72784bec) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Process Single Interaction from xConnect Pipeline, pipeline step: Iterate Events and Run Pipelines, completed pipeline steps: 3) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] 2 elements were iterated. (pipeline: Process Interactions for Single xConnect Contact Pipeline, pipeline step: Iterate xConnect Interactions and Run Pipelines, pipeline step identifier: e5f3a442-4f1e-4619-b16a-ad43793287ea) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Process Interactions for Single xConnect Contact Pipeline, pipeline step: Iterate xConnect Interactions and Run Pipelines, completed pipeline steps: 2) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] 2 elements were iterated. (pipeline: Read Contact Interactions from xConnect Pipeline, pipeline step: Iterate xConnect Contacts and Run Pipelines, pipeline step identifier: 208d4356-fc0b-486c-b472-3dd9a1cd895b) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] Pipeline processor finished processing pipeline steps. (pipeline: Read Contact Interactions from xConnect Pipeline, pipeline step: Submit Remaining Tasks In Salesforce Object Queue, completed pipeline steps: 4) ManagedPoolThread #14 11:54:34 DEBUG [Data Exchange] Pipeline batch processor finished processing pipelines. (pipeline batch: xConnect Contacts to Salesforce Sync, completed pipelines: 2)

any suggestion appreciated.

  • 1. What does troubleshooter for Salesforce endpoint say? 2. Run it with "Include Stack Trace For Exceptions" enabled to see inner exceptions. – Vlad Shpak Jan 28 at 17:23
  • 1. when i click "Run troubleshooter" Connection was successfully established msg was shown. – Rajasekar Jan 29 at 6:27
  • At least one value mapping failed. (pipeline: Process Single Contact from xConnect Pipeline, pipeline step: Apply Mapping from Contact Model to Salesforce Contact, pipeline step identifier: 6622f7fb-8b13-4bb9-8673-471183dd48fb, mappings that failed: 1, value mapping ids: 28f2187f-201f-4ba6-8c23-733288fbd0f9) – Rajasekar Jan 29 at 6:56
  • in that error ,Salesforce Contact Id -28f2187f-201f-4ba6-8c23-733288fbd0f9 – Rajasekar Jan 29 at 9:10
  • Try to disable Salesforce Contact It value mapping or set 'Do Not Fail If Unable To Read Source Value ' – Vlad Shpak Jan 29 at 12:53
0

Try to do next:

  1. Set 'Do Not Fail If Unable To Read Source Value' on Salesforce Contact Id value mapping item.
  2. Include PII fields to index.

You have to enable indexing for PII sensitive fields because Read Contacts from xConnect pipeline step reads all contacts by filter/search. See Contact Filter on the pipeline step. The default assigned contact filter is trying to find all contacts where first name and email address not equal null. It means that xconnect will use search to get contacts but by default these fields are PII and default xconnect configuration does not index such fields.

P.S Do not forget re-index after changes.

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.