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] |
Read more...
Environment
Commerce Cloud v2 (CCv2) using Microsoft SQL or SAP HANA or Oracle DB and SAP Commerce Data Hub.
Product
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.