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.