Hi everyone. Got an error that's driving me nuts. ...
# generalc
Curtis of Denver
02/10/2023, 3:07 PMHi everyone. Got an error that's driving me nuts. Stemming from a boomi integration. The error is "Error executing Netsuite operation: org.xml.sax.SAXException: 'value' on {urn:core_2019_2.platform.webservices.netsuite.com}BooleanCustomFieldRef is required." The weird part is the following:
1. This is an Account Create flow from Salesforce to NetSuite, where a Customer Record is created.
2. When we put in a number string for a field that looks for NetSuite Internal IDs, it switches to the Update account flow. The Update flow CREATES A NEW RECORD in NetSuite and then overwrites the internal ID in Salesforce.
3. The Update and Create flows are otherwise identical - but the Update flow works and the Create flow does not.
4. We have accounted for 100% of the checkboxes/boolean fields on the Customer Record (I pulled all 29 checkboxes that exist on the Customer record and verified only 3 needed to be mapped, and all are mapped. Also, the Update flow maps the exact same checkboxes and it works just fine.)
5. There are workflows on the Customer record. I've disabled the ones that are on Create by moving the status to "Suspended" and Inactivating them, just so I won't see them anymore either. Didn't seem to make a difference.
This is for a series of tests we're performing in Sandbox, so there are limited System Notes.
Question: What is the best way to troubleshoot this particular error? Creating a Customer record in UI goes through with no issue. It is only when the boomi integration is triggered. I also have zero idea (and the boomi team has no ideas either) about why the Update flow works to create a Customer record, but a Create flow gets hung up on this error - even though they have the exact same mapping (we went through the mapping line by line, so we verified it was indeed exact).
b
battk
02/10/2023, 4:35 PMthats a response you get when invalid xml is received
battk
02/10/2023, 4:36 PMin this case, one of the BooleanCustomFieldRef elements is missing its child value element
c
Curtis of Denver
02/10/2023, 5:04 PM@battk Thank you very much for responding. I get invalid xml, I'm not clear on "missing its child value element" (not a technical consultant, this is definitely outside of my wheelhouse). Do you mean that we're referencing a parent field only and not an actual field which is a child field?
b
battk
02/10/2023, 5:07 PMdoesnt have anything to do with netsuite
battk
02/10/2023, 5:07 PMsuitetalk soap expects that the xml it receives to match its wsdl
battk
02/10/2023, 5:08 PMits not receiving it and the error its giving you is telling you what part of the xml is wrong
battk
02/10/2023, 5:10 PMif you didnt recognize the keyword element in reference to xml, then you probably wont get much further than the xml is invalid
c
Curtis of Denver
02/10/2023, 5:14 PMGot it. Thank you. I will pass this along to my boomi team. I appreciate you!!!
7 Views