Hi all, I'm new to Boomi and I'm trying to get a connection up and running between our NetSuite environment and SalesForce.
I'm getting an error when I try to bring over a NetSuite Multi-Select field into a SalesForce multi-select field. I'm sure the issue is formatting but I haven't figured out a way to get it to work successfully.
Error: Embedded message: Process terminating -- some documents reached an exception which is set to halt all documents: There was an error syncing customers. Please see the Process Log for details.
When I go look at the connection data I see this message <?xml version="1.0" encoding="UTF-8" standalone="no"?><Account><id/><success>false</success><errors><error><statusCode>DUPLICATE_VALUE</statusCode><message>OBJ: Account - Duplicate external id specified: 11654</message></error></errors></Account>
My assumption is that instead of trying to do one load it's breaking the one Customer Account into four records to upload, one for each multi-select value.
If anyone has overcome this and could help out I'd greatly appreciate it.