Duplicate location in hz_locations table
Summary:
We are creating accounts from CX Sales to ERP Cloud. One creation of the Sites we have a call to merge location in OIC which sends payload to ERP adapters but this request is failing due to data error. On checking the hz_locations table there is a duplicate data. We tried to delete them using SOAP but still the ERP adapters are trying to merge the account and giving the same error
WSDL SOAP Request -> /crmService/FoundationPartiesLocationService.
ERROR MESSAGE Received from ERP Adapters:
CASDK-0033: Received a SOAP fault while invoking endpoint target:
[CDATA[ Fault Code : env:Server Fault String : Exception Description: The object [300000837942324 300000839576864], of class [class java.lang.String], could not be converted to [class java.lang.Long]. Internal Exception: java.lang.NumberFormatException: For input string: "300000837942324 300000839576864" ]]