2863570 - Issues when replicating Customer Master

Symptom

Importing an Idoc in SAP Commerce using Data Hub in a standard environment works correctly, but not in a Commerce Cloud v2 (CCv2) environment. The error would look something like this:

unexpected preparer error: SQL search error - Invalid column name 'false'. query = 'SELECT item_t0.PK FROM addresses item_t0 WHERE ( item_t0.p_sapcustomerid =? and item_t0.p_duplicate = false) AND (item_t0.TypePkString=? )', values = [0001019859, 8796094201938], Exception : line 9: cannot create Address with values ItemAttributeMap[ registry: null, type: u003cnullu003e, data: {sapaddressusage=RE, sapaddressusagecounter=000, owner=0001019859_1000_10_10[8796224258053], publickey=0001019859_1000_10_10|0001019859|KNA1|RE, duplicate=false, sapcustomerid=0001019859} ] due to [com.sap.hybris.sapcustomerb2b.inbound.DefaultSAPCustomerAddressConsistencyInterceptor@1163b9ac]: unexpected preparer error: SQL search error - Invalid column name 'false'. query = 'SELECT item_t0.PK FROM addresses item_t0 WHERE ( item_t0.p_sapcustomerid =? and item_t0.p_duplicate = false) AND (item_t0.TypePkString=? )', values = [0001019859, 8796094201938]

Environment

Commerce Cloud v2 (CCv2) using Microsoft SQL or SAP HANA or Oracle DB and SAP Commerce Data Hub.

Product

SAP Commerce Cloud 2005 ; SAP Commerce Cloud 2011 ; SAP Commerce Cloud 2105 ; SAP Commerce Cloud 2205 ; SAP Commerce Cloud 2211 ; SAP Commerce Cloud 2211 for JDK21

Keywords

Data Hub, SAP Commerce, SAP Hybris Commerce, Hybris, SAP Commerce Cloud, IDoc, IDocs, CCv2, Commerce Cloud V2, BD12, ADRMAS, ADR3MAS, DEBMAS, ECC, Invalid column type, Boolean, Oracle, MS SQL, HANA, HSQL, SQL , KBA , idoc , data hub , CEC-SCC-CLA-ENV-EMG , Environment Management , CEC-SCC-INT-DHI , Data Hub Integrations , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.