SAP Knowledge Base Article - Preview

2640879 - Product Cockpit: Query modification in Generic Search API

Symptom

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.


Read more...

Environment

SAP Hybris Commerce suite 6.x

Product

SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4 ; SAP Hybris Commerce 6.5

Keywords

GenericSearch Product Cockpit Flexible Search , KBA , CEC-COM-CPS , Commerce Platform & Suite (SAP Hybris) , 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.