Error in SAP Commerce 1905 : HAC->FlexibleSearch window

[bidyadhar_tripathy]

Hi All,

In 1905 version, Whenever I type a wrong flexible query in HAC->Flexiblesearch section then we are getting empty "Search Result" tab without any error messages where as in 6.7 version we are getting error message in "Search Result Tab".

Query : select * fro {Product}

1905 version

Log : ERROR [hybrisHTTP30] [FlexibleSearch] Flexible search error occured...
ERROR [hybrisHTTP30] [FlexibleSearch] Query translation was not successful.
ERROR [hybrisHTTP30] [ConnectionImpl] transaction of unbinding connection 18(-) has not been ended - will rollback automatically
Sep 20, 2019 9:15:45 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [springmvc] in context with path [/hac] threw exception [Request processing failed; nested exception is de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: Missing FROM clause in 'select * fro {Product}'] with root cause
de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: Missing FROM clause in 'select * fro {Product}'[HY-0]
        at de.hybris.platform.persistence.flexiblesearch.ParsedQuery.splitQuerySections(ParsedQuery.java:703)

6.7 version

ERROR [hybrisHTTP23] [FlexibleSearch] Flexible search error occured...
ERROR [hybrisHTTP23] [FlexibleSearch] Query translation was not successful.
ERROR [hybrisHTTP23] [ConnectionImpl] transaction of unbinding connection 611(-) has not been ended - will rollback automatically 

I am getting few extra console errors in 1905 version as compared to 6.7.

Is this a bug in 1905 version ? Can anyone please help me on this issue.

Thanks.

[bidyadhar_tripathy]

Hi Arvind,

Thank you for the reply. If a wrong query is typed then it should show "query is not legal" kind of message in search result tab which is showing in 6.7 and 1811 version but in 1905 version it doesn't show any error message and shows red color bar with below exception message in console log which I am not seeing in 6.7 version.

Sep 20,20199:15:45 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service()for servlet [springmvc]incontextwith path [/hac] threw exception[Requestprocessing failed;nestedexceptionis de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: Missing FROM clause in'select * fro {Product}']with root cause
de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: Missing FROM clause in'select * fro {Product}'[HY-0]at de.hybris.platform.persistence.flexiblesearch.ParsedQuery.splitQuerySections(ParsedQuery.java:703)

If it is a bug in 1905 version, could you please tell me where I can report it ?

Note : Red color bar shows in hac when something wrong happened (usually seen during platform update and initialization)

[crescenzorega]

the problem is the query

Missing FROM clause in 'select * fro {Product}'] with root cause

try with

select * from {Product}

[aoppelt]

Supposedly fixed in 2011 via

https://cxjira.sap.com/browse/ECP-5041

[nicolabeghin]

thanks Achim.

[nicolabeghin]

Any update on this? still experiencing the same issue on 2005

[pavanmarla]

Any fix for this issue?

[former_member670738]

select * from {product}. you are missing "from" in query

[former_member655326]

We have same issue ...