2640879 - Product Cockpit: Query modification in Generic Search API

Product Cockpit uses GenericSearch API for write SQL queries and making any changes to those queires is pretty easy unless you have a requirement where you need to append something to the end of the query.

Customer can face issues while using MS SQL DB with Hybris. Issues such as,

INFO | jvm 1 | main | 2018/03/12 15:14:07.510 | [1;31mERROR [hybrisHTTP9] [172.30.32.223] [FlexibleSearch] Flexible search error occured...
INFO | jvm 1 | main | 2018/03/12 15:14:07.815 | [m[1;31mERROR [hybrisHTTP9] [172.30.32.223] [PagingDelegateController] SQL search error - The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

This can happen when there are large number of entries in the "IN" clause (normally in thousands) and the system does not get enough time to process all those IN clauses and effectively generate the query execution plan.

SAP Hybris Commerce suite 6.x

GenericSearch Product Cockpit Flexible Search , KBA , CEC-COM-CPS , SAP Commerce , How To