SalesForce - Unable to import object - InvalidOperationException (3 replies)
Unmapping the "Supplier" field allowed the import to continue.
Still need a fix though
After successfully importing an Object while using an "Insert" update operation, I switched to an "Insert/Update", but then I get an error "duplicate value found: gvp__Brand_Key__c duplicates value on record with id: a123456789" (I changed the actual Id value).
I also tried an Update which doesn't throw an error, but doesn't seem to have updated SalesForce either.
Randy, we are moving to this to support. Please reply to the ticket there.
I am unable to Insert or Insert/Update a new "Brand" record. There are no errors shown in IMan, but the Salesforce.log file has logging for an InvalidOperationException: Sequence contains more than one matching element.
Here is the full stack trace:
2020-12-18 16:17:50:7328843 - 611 - BrandImport - 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)
As an attachment I'm including the IMan Preview as well as the SalesForce Object definition