FlexibleSearchException: could not translate value expression 'session.branch'

[former_member660769]

Hi Experts ,

I am getting the below error.

1.login to Storefront with b2bcustomer login.

Upon successful login wait for session time out ( 30min) then click on any category link or do some search on the page

. Then i will get the error page.

Logs:

NFO | jvm 1 | main | 2020/01/15 08:11:45.568 | [1;31mERROR [tid:38525] [hCSHTTP55] [10.34.128.46] [FlexibleSearch] Flexible search error occured... INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | [mJan 15, 2020 8:11:45 AM org.apache.catalina.core.StandardWrapperValve invoke INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [] threw exception [Error while processing internal filterchain. Exception occurred at chain position: 4 of 24. Current filter: 'com.erk.b2b.storefront.filters.AutoLoginSSOFilter@4495e360'!; nested exception is de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: could not translate value expression 'session.branch'] with root causeINFO | jvm 1 | main | 2020/01/15 08:11:45.568 | de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: could not translate value expression 'session.branch'[HY-0] INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.jalo.flexiblesearch.SessionParamTranslator.translatePathValueKeys(SessionParamTranslator.java:91) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.translatePathValueKeys(FlexibleSearch.java:2021) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1426) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1385) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$2.execute(DefaultFlexibleSearchService.java:418) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$2.execute(DefaultFlexibleSearchService.java:1) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView(DefaultSessionService.java:89) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.getJaloResult(DefaultFlexibleSearchService.java:396) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.search(DefaultFlexibleSearchService.java:168) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.internal.dao.DefaultGenericDao.find(DefaultGenericDao.java:52) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.user.daos.impl.DefaultUserDao.findUserByUID(DefaultUserDao.java:35) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.user.impl.DefaultUserService.getUserForUID(DefaultUserService.java:92) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at com.erk.b2b.storefront.filters.AutoLoginSSOFilter.refreshSpringSecurity(AutoLoginSSOFilter.java:149) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at com.erk.b2b.storefront.filters.AutoLoginSSOFilter.doFilterInternal(AutoLoginSSOFilter.java:101) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.web.SessionFilter.doFilter(SessionFilter.java:99) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.web.Log4JFilter.doFilter(Log4JFilter.java:44) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:271) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 | at de.hybris.platform.servicelayer.web.session.HybrisSpringSessionFilter.doFilter(HybrisSpringSessionFilter.java:69) INFO | jvm 1 | main | 2020/01/15 08:11:45.568 |

Thanks in a advance

[former_member790939]

Hello vijayabaskar,

did you find the cause for this issue as I am also find the similar issue recently and below is reference.

[FlexibleSearch] Flexible search error occured...
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | [1;31mERROR [ajp-nio-0.0.0.0-8009-exec-142] [192.168.163.56] [AbstractRestHandlerExceptionResolver] de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: could not translate value expression 'session.catalogversions'
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$3.execute(DefaultFlexibleSearchService.java:535)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$3.execute(DefaultFlexibleSearchService.java:1)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.servicelayer.session.impl.DefaultSessionService.executeInLocalView(DefaultSessionService.java:82)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.getJaloResult(DefaultFlexibleSearchService.java:504)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.search(DefaultFlexibleSearchService.java:177)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.servicelayer.internal.dao.DefaultGenericDao.find(DefaultGenericDao.java:44)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.product.daos.impl.DefaultProductDao.findProductsByCode(DefaultProductDao.java:97)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at de.hybris.platform.product.impl.DefaultProductService.getProductForCode(DefaultProductService.java:62)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at com.unic.hybris.abcgroup.facades.products.impl.AbcProductFacadeImpl.lambda$13(AbcProductFacadeImpl.java:280)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at com.unic.hybris.abcgroup.facades.products.impl.AbcProductFacadeImpl.getProductClassificationClasses(AbcProductFacadeImpl.java:282)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at com.unic.hybris.abcgroup.v2.controller.ProductsController.getProductClassificationClasses(ProductsController.java:333)
INFO | jvm 1 | main | 2022/02/17 05:21:38.101 | at com.unic.hybris.abcgroup.v2.controller.ProductsController$$FastClassBySpringCGLIB$$2d56eb44.invoke(<generated>)
INFO | jvm 1 | main | 2022/02/17 05:21:38.104 | at com.unic.hybris.abcgroup.v2.controller.ProductsController$$EnhancerBySpringCGLIB$$7ec57138.getProductClassificationClasses(<generated>)
INFO | jvm 1 | main | 2022/02/17 05:21:38.104 | at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
INFO | jvm 1 | main | 2022/02/17 05:21:38.117 | Caused by: de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: could not translate value expression 'session.catalogversions'[HY-0]
INFO | jvm 1 | main | 2022/02/17 05:21:38.117 | at de.hybris.platform.jalo.flexiblesearch.SessionParamTranslator.translatePathValueKeys(SessionParamTranslator.java:84)
INFO | jvm 1 | main | 2022/02/17 05:21:38.117 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.translatePathValueKeys(FlexibleSearch.java:2343)
INFO | jvm 1 | main | 2022/02/17 05:21:38.118 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearchUsingFlexibleSearchDialect(FlexibleSearch.java:1649)
INFO | jvm 1 | main | 2022/02/17 05:21:38.118 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearchUsingPolyglotDialect(FlexibleSearch.java:1494)
INFO | jvm 1 | main | 2022/02/17 05:21:38.118 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1425)
INFO | jvm 1 | main | 2022/02/17 05:21:38.118 | at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1418)
INFO | jvm 1 | main | 2022/02/17 05:21:38.118 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService$3.execute(DefaultFlexibleSearchService.java:527)
INFO | jvm 1 | main | 2022/02/17 05:21:38.118 | ... 161 more