could not translate value expression 'session.catalogversions'

[former_member790939]

Hello Everyone,

I received the below error message while checking the logs on server, any assistance will be appreciate.


[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

@robin.vezina - if you identified the cause and solution for the same.

[former_member790939]

I found the issue due to null value was passing into baseSiteId.

POST /commercewebservices/v2/null/products/classifications

If you find similar issue, please also check access log and console log within same time.

Best | Ashish Vyas