2367248 - exception "could not translate value expression 'session.branch'" during b2b storefront login | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2367248 - exception "could not translate value expression 'session.branch'" during b2b storefront login

Symptom

The exception in console while logging into the b2b storefront occurs:

INFO | jvm 1 | main | 2016/05/23 15:01:22.096 | ERROR [hybrisHTTP7] [10.66.199.67] [FlexibleSearch] Flexiblesearch error: could not translate value expression 'session.branch' INFO | jvm 1 | main | 2016/05/23 15:01:22.096 | ERROR [hybrisHTTP7] [10.66.199.67] [FlexibleSearch] query was 'SELECT {c:pk} FROM {User AS c} WHERE {c:uid}=?uid ' INFO | jvm 1 | main | 2016/05/23 15:01:22.096 | ERROR [hybrisHTTP7] [10.66.199.67] [FlexibleSearch] translated query was: SELECT item_t0.PK FROM users item_t0 WHERE ( item_t0.p_uid =?) AND (item_t0.TypePkString IN (?,?,?,?) AND ((item_t0.TypePkString IN ( ?,?,? ) OR (EXISTS (SELECT item_t1.PK FROM pgrels item_t1 WHERE ( item_t1.SourcePK = item_t0.PK AND item_t1.TargetPK IN ( ? )) AND (item_t1.TypePkString=? ) ) AND ( item_t0.p_active = 1 OR EXISTS ( SELECT item_t2.PK FROM usergroups item_t2 WHERE ( item_t2.PK IN (?) and item_t2.p_uid = 'b2badmingroup') AND (item_t2.TypePkString IN (?,?,?,?,?,?,?) AND ((item_t2.TypePkString IN ( ?,?,?,?,?,? ) OR (( SELECT item_t3.PK FROM usergroups item_t3 WHERE ( item_t3.PK IN (?) and item_t3.p_uid = 'b2badmingroup') AND (item_t3.TypePkString IN (?,?,?,?,?,?,?) AND ((item_t3.TypePkString IN ( ?,?,?,?,?,? ) OR (( item_t3.p_active = 1 OR EXISTS ( SELECT item_t4.PK FROM usergroups item_t4 WHERE ( item_t4.PK IN (?) and item_t4.p_uid = 'b2badmingroup') AND (item_t4.TypePkString IN (?,?,?,?,?,?,?) ) ))))) ) ))) AND (item_t2.TypePkString IN ( ?,?,?,?,?,? ) OR (( item_t2.p_active = 1 OR EXISTS ( SELECT item_t5.PK FROM usergroups item_t5 WHERE ( item_t5.PK IN (?) and item_t5.p_uid = 'b2badmingroup') AND (item_t5.TypePkString IN (?,?,?,?,?,?,?) AND ((item_t5.TypePkString IN ( ?,?,?,?,?,? ) OR (( SELECT item_t6.PK FROM usergroups item_t6 WHERE ( item_t6.PK IN (?) and item_t6.p_uid = 'b2badmingroup') AND (item_t6.TypePkString IN (?,?,?,?,?,?,?) ) )))) ) ))))) ) ))))) ) INFO | jvm 1 | main | 2016/05/23 15:01:22.096 | May 23, 2016 3:01:22 PM org.apache.catalina.core.StandardWrapperValve invoke INFO | jvm 1 | main | 2016/05/23 15:01:22.096 | SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [/yb2bacceleratorstorefront] threw exception [Error while processing internal filterchain. Exception occurred at chain position: 8 of 18. Current filter: 'FilterChainProxy[Filter Chains: [[ Ant [pattern='/_ui/**'], []], [ Ant [pattern='/checkout/**'], [org.springframework.security.web.access.channel.ChannelProcessingFilter@6b3feb09, org.springframework.security.web.context.SecurityContextPersistenceFilter@2359e02d, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@753e23d6, org.springframework.security.web.authentication.logout.LogoutFilter@c00866d, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@18f34347, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@74c780fc, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@70632d21, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@7858feae, org.springframework.security.web.session.SessionManagementFilter@7ab36399, org.springframework.security.web.access.ExceptionTranslationFilter@32bbcc53, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@5bd8f500]], [ de.hybris.platform.yb2bacceleratorstorefront.security.ExcludeUrlRequestMatcher@e2b8d8b, [org.springframework.security.web.access.channel.ChannelProcessingFilter@243f3adc, org.springframework.security.web.context.SecurityContextPersistenceFilter@acbd091, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@18ca579a, org.springframework.security.web.authentication.logout.LogoutFilter@4adfc6dd, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@17ebfc80, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@4370f9b4, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@94c00c7, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@3d11c61d, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@75d622c3, org.springframework.security.web.session.SessionManagementFilter@31afc894, org.springframework.security.web.access.ExceptionTranslationFilter@588cac5e, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@6b9eb87c]], [ Ant [pattern='/my-company/**'], [org.springframework.security.web.access.channel.ChannelProcessingFilter@33efbc8c, org.springframework.security.web.context.SecurityContextPersistenceFilter@40309b6e, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@58f04d4d, org.springframework.security.web.authentication.logout.LogoutFilter@11d10bf7, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@5f14ce9d, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@1bbbc5fa, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@41fb79e5, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@586c5c9e, org.springframework.security.web.session.SessionManagementFilter@21f50128, org.springframework.security.web.access.ExceptionTranslationFilter@64a484f9, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@7e8afdd9]]]]'!; nested exception is de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: could not translate value expression 'session.branch'] with root cause


Read more...

Environment

Hybris platform- extensions installation done with or sap_som_b2b receipy for hybris 6.0.0.0 or crm_som_b2b receipy for previous versions of hybris platform

Product

SAP Hybris Commerce 6.0

Keywords

KBA , CEC-COM-CPS , Commerce Platform & Suite (SAP Hybris) , Problem

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.