Discussions

So essentially what is happening is that after an iMIS upgrade to the self-hosted version of 2017 we have been experiencing issues where the cart intermittently does/doesn't calculate shipping and handling, however this error always prevents the cart from actually going through, and this seems to be narrowed down to one issue where in the SOA methods an address lookup fails:

Error: The supplied value, 'XXXXXX' is not defined in Contacts/Customers and is invalid.

but upon looking to the account in question, under the Name table, the ID for ADDRESS_NUM in question is properly assigned to the SHIP_ADDRESS_NUM column, and also exists under the Name_Address table verified with a quick query of:

SELECT * FROM Name_Address WHERE ADDRESS_NUM = XXXXXX

The way this error exposes itself is upon cart submit the method "ValidateCart" returns with a valid = true state... however when immediately followed by the action to "SubmitCart" (as there are no reported errors at this point) this results in a then valid = false response from iMIS and the above error about the supplied value is thrown.