SAP Knowledge Base Article - Preview

2719957 - A query using `false` as inline boolean value does NOT work on HANA database and hybris with marketplace extension enabled

Symptom

In a hybris intallation using the marketplace_acc receipe on Hana DB, checkout would fail with below error:

INFO | jvm 1 | main | 2018/11/01 12:57:36.385 | �[1;31mERROR [hybrisHTTP12] [FlexibleSearch] Flexible search error occured...
INFO | jvm 1 | main | 2018/11/01 12:57:36.385 | �[mNov 1, 2018 12:57:36 PM org.apache.catalina.core.StandardWrapperValve invoke
INFO | jvm 1 | main | 2018/11/01 12:57:36.385 | SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [/yacceleratorstorefront] threw exception [Request processing failed; nested exception is de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - SAP DBTech JDBC: [266]: inconsistent datatype: BOOLEAN type is not comparable with DECIMAL type.: line 1 col 187 (at pos 186) query = 'SELECT item_t0.PK FROM cartentries item_t0 JOIN products item_t1 ON item_t0.p_product = item_t1.PK JOIN carts item_t2 ON item_t0.p_order = item_t2.PK WHERE ( item_t1.p_saleable =false and item_t2.p_code =?) AND ((item_t0.TypePkString=? AND item_t1.TypePkString IN (?,?,?) AND ((( item_t1.p_onlinedate IS NULL OR item_t1.p_onlinedate <= ?) AND ( item_t1.p_offlinedate IS NULL OR item_t1.p_offlinedate >= ?)) AND ( item_t1.p_catalogversion IN (?,?,?,?,?,?,?,?,?,?,?)) AND ( item_t1.p_approvalstatus = 8796100690011 )) AND item_t2.TypePkString=? ))', values = [00000000, 8796098134098, 8796101017682, 8796101050450, 8796097773650, Thu Nov 1 00:00:00 GMT 2018, Thu Nov 1 00:00:00 GMT 2018, PropertyValue:8796093514329, PropertyValue:8796093350489, PropertyValue:8796093252185, PropertyValue:8796093416025, PropertyValue:8796093153881, PropertyValue:8796093481561, PropertyValue:8796093383257, PropertyValue:8796093317721, PropertyValue:8796093186649, PropertyValue:8796093284953, PropertyValue:8796093448793, 8796094005330]] with root cause
INFO | jvm 1 | main | 2018/11/01 12:57:36.385 | com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [266]: inconsistent datatype: BOOLEAN type is not comparable with DECIMAL type.: line 1 col 187 (at pos 186)
INFO | jvm 1 | main | 2018/11/01 12:57:36.385 | at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:201)

Read more...

Environment

Hybris 6.7.X

Hana Database

Product

SAP Hybris Commerce 6.7

Keywords

Marketplace, hybris, hana, boolean , KBA , CEC-COM-CPS , Commerce Platform & Suite (SAP Commerce) , How To

About this page

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

Search for additional results

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