Back to connectors… Back to Other...

SalesForce - Field showing twice in dropdown - Sequence contains more than one matching element (No replies)

Randy
3 years ago
Randy 3 years ago

I am currently unable to sync data to a particular Object in IMan due to the following issue:

 

I am seeing the same field twice in the mapping dropdowns when attempting to push data to SalesForce.

When it is mapped and I attempt to "Refresh":

  • No error is written back to IMan (SYS.ERROR)
  • Via the Salesforce.log file I can see that an InvalidOperationException is being thrown: Sequence contains more than one matching element

2021-01-08 12:20:18:5803814 - 313 - ABWI1S3001SAFO1-VendorsToBrands - BrandUpsert - System.InvalidOperationException: Sequence contains more than one matching element
at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
at Realisable.Connectors.Salesforce.Dataflow.CompositeJSONWriter.WriteBody(Transaction transaction, String referenceField, DescribeSObjectResultSmall description, String parentId)
at Realisable.Connectors.Salesforce.Dataflow.CompositeJSONWriter.WriteObject(Transaction transaction, DescribeSObjectResultSmall description, String referenceField, String parentId)
at Realisable.Connectors.Salesforce.Dataflow.CompositeJSONWriter.ProcessParent(Transaction parent, DescribeSObjectResultSmall description)
at Realisable.Connectors.Salesforce.AbstractTransactionHandler.ProcessState(IteratorState state, DescribeSObjectResultSmall description, ITransformAuditController auditController)
at Realisable.Connectors.Salesforce.Dataflow.CompositeJSONWriter.Process(IteratorState state, DescribeSObjectResultSmall description, ITransformAuditController auditController, eTransformErrorAction errAction)
at Realisable.Connectors.Salesforce.Dataflow.CompositeProcessor.ProcessTranactionTree(BaseMessage message, TransformDefinition tfmDef, IForceClient client, ITransformAuditController auditController, eTransformErrorAction errAction)

In the attached screenshot, please see the "Supplier" field being listed twice.

 

When I looked at the Object Manager in SalesForce, I only see the field listed once.

Is IMan showing the field twice incorrectly?

Do we have make an adjustment in SalesForce?

https://www.realisable.co.uk/wp-content/uploads/2021/01/Screenshot-from-2021-01-08-10-17-46.png

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close