DefaultSAPCustomerAddressConsistencyInterceptor :inconsistent datatype: BOOLEAN type is not comparable with DECIMAL type

[former_member623616]

Hi All, We have implemented Hybris(v6.7.0.0)-S4HANA integration using Datahub(v6.7.0.1) for Master Data replication. We are using HANA DB, for Hybris and Datahub. While replicating Customer from SAP to Hybris, we are getting below error while customer Address import in Hybris platform: NOTE: publication is successful in Datahub, but error is coming while customer Address import in Hybris,

While looking for solution, i come across below thread from Hybris JIRA, which stated the same error: https://jira.hybris.com/browse/ECP-968

 INFO | jvm 1 | main | 2019/02/07 03:51:45.337 | WARN [impex result worker [cj:00001AAR]] [ImpExImportReader] line 4 at main script: dumped unresolved line ValueLine[unresolvable:Exception : line 12: cannot create Address with values ItemAttributeMap[ registry: null, type: <null>, data: {sapaddressusage=RE, sapaddressusagecounter=000, owner=0010000011_ID01_10_10[8796420931589], publickey=0010000011_ID01_10_10|0010000011|KNA1|RE, duplicate=false, sapcustomerid=0010000011} ] due to **[com.sap.hybris.sapcustomerb2b.inbound.DefaultSAPCustomerAddressConsistencyInterceptor@18cbbb2a]: unexpected preparer error: SQL search error - SAP DBTech JDBC: [266]: inconsistent datatype: BOOLEAN type is not comparable with DECIMAL type**.: line 1 col 109 (at pos 108) 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 = [0010000011, 8796094234706], Exception : line 4: cannot create Address with values ItemAttributeMap[ registry: null, type: <null>, data: {sapaddressusage=RE, sapaddressusagecounter=000, owner=0010000011_ID01_10_10[8796420931589], publickey=0010000011_ID01_10_10|0010000011|KNA1|RE, duplicate=false, sapcustomerid=0010000011} ] due to [com.sap.hybris.sapcustomerb2b.inbound.DefaultSAPCustomerAddressConsistencyInterceptor@18cbbb2a]: unexpected preparer error: SQL search error - SAP DBTech JDBC: [266]: inconsistent datatype: BOOLEAN type is not comparable with DECIMAL type.: line 1 col 109 (at pos 108) 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 = [0010000011, 8796094234706],line 4 at main script,null,HeaderDescriptor[line 2 at main script, insert_update, Address, {}, [@address, sapAddressUsageCounter, sapAddressUsage, sapCustomerID, duplicate, publicKey, owner] ],{1=ValueEntry('419'=null,unresolved=null,ignore=false), 2=ValueEntry('005'=null,unresolved=null,ignore=false), 3=ValueEntry('000'=000,unresolved=false,ignore=false), 4=ValueEntry('RE'=RE,unresolved=false,ignore=false), 5=ValueEntry('0010000011'=0010000011,unresolved=false,ignore=false), 6=ValueEntry('false'=false,unresolved=false,ignore=false), 7=ValueEntry('0010000011_ID01_10_10|0010000011|KNA1|RE'=0010000011_ID01_10_10|0010000011|KNA1|RE,unresolved=false,ignore=false), 8=ValueEntry('0010000011_ID01_10_10'=0010000011_ID01_10_10[8796420931589],unresolved=false,ignore=false)}]

IF it's the same issue(mentioned in above JIRA ticket), shouldn't it be fixed in Hybris version we are using i.e. v6.7.0.0.

And if it's different issue, then can you please help me to understand the root cause of this issue.

Thanks, Yaten