[NXP-21281] User member of a group which name contains a quote gets an error when navigating to 'HOME > Alerts' - Nuxeo Issue Tracker

XML

Word

Printable

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 7.10-HF18, 8.10
Fix Version/s: 7.10-HF19, 8.10-HF01, 9.1
Component/s: Notifications

Tags:
- SupCom
- rookie
Backlog priority:
500

Description

How to reproduce:

log in as an admin user
create a user user1
create a group named group'a and add user user1 to it
log in as user user1
navigate to HOME > Alerts

An error message is displayed on the screen and the following logs are generated in server.log:

org.nuxeo.ecm.core.query.QueryParseException: Failed to execute query:
SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND ecm:isCheckedInVersion = 0
AND notif:notifications/*/subscribers/* = 'group:group'a'
Syntax error: Invalid token <a> at offset 150

Full log:

2016-12-05 16:59:48,181 ERROR [http-bio-0.0.0.0-8080-exec-7] [org.nuxeo.ecm.platform.web.common.exceptionhandling.DefaultNuxeoExceptionHandler] javax.servlet.ServletException: On requestURL: http://localhost:8080/nuxeo/view_home.faces
	at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:138)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoRequestControllerFilter.doFilter(NuxeoRequestControllerFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.webdav.service.WIRequestFilter.doFilter(WIRequestFilter.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilterInternal(NuxeoAuthenticationFilter.java:591)
	at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:36)
	at org.nuxeo.ecm.platform.ui.web.auth.oauth.NuxeoOAuthFilter.doFilter(NuxeoOAuthFilter.java:120)
	at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:34)
	at org.nuxeo.ecm.platform.ui.web.auth.oauth2.NuxeoOAuth2Filter.doFilter(NuxeoOAuth2Filter.java:68)
	at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:34)
	at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilter(NuxeoAuthenticationFilter.java:401)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.apidoc.filter.BaseApiDocFilter.doFilter(BaseApiDocFilter.java:56)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoCorsFilter.doFilter(NuxeoCorsFilter.java:66)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.exceptionhandling.NuxeoExceptionFilter.doFilter(NuxeoExceptionFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.encoding.NuxeoEncodingFilter.doFilter(NuxeoEncodingFilter.java:73)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.servlet.ServletException: Failed to execute query: SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND ecm:isCheckedInVersion = 0 AND notif:notifications/*/subscribers/* = 'group:group'a', Syntax error: Invalid token <a> at offset 150
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:659)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.apidoc.filter.BaseApiDocFilter.doFilter(BaseApiDocFilter.java:56)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
	at org.nuxeo.elasticsearch.web.sync.UIThreadMarker.doFilter(UIThreadMarker.java:46)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
	at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoThreadTrackerFilter.doFilter(NuxeoThreadTrackerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.core.management.jtajca.internal.Log4jWebFilter.doFilter(Log4jWebFilter.java:67)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:118)
	... 43 more
Caused by: org.nuxeo.ecm.core.query.QueryParseException: Failed to execute query: SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND ecm:isCheckedInVersion = 0 AND notif:notifications/*/subscribers/* = 'group:group'a', Syntax error: Invalid token <a> at offset 150
	at org.nuxeo.ecm.core.query.sql.parser.parser.parseFailed(parser.java:519)
	at org.nuxeo.ecm.core.query.sql.parser.parser.unrecovered_syntax_error(parser.java:510)
	at java_cup.runtime.lr_parser.parse(lr_parser.java:601)
	at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:39)
	at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:48)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker.buildQuery(NXQLQueryMaker.java:281)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:742)
	at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.doInvoke(JDBCMapperConnector.java:24)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:67)
	at com.sun.proxy.$Proxy66.query(Unknown Source)
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.query(SoftRefCachingMapper.java:86)
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1223)
	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:324)
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.query(SQLSession.java:389)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1174)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1120)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1104)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1084)
	at org.nuxeo.ecm.platform.ec.notification.service.UnrestrictedDocFetcher.run(UnrestrictedDocFetcher.java:46)
	at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:139)
	at org.nuxeo.ecm.platform.ec.notification.service.UnrestrictedDocFetcher.query(UnrestrictedDocFetcher.java:64)
	at org.nuxeo.ecm.platform.ec.notification.service.NotificationService.getSubscribedDocuments(NotificationService.java:544)
	at org.nuxeo.ecm.user.center.notification.UserNotificationActions.fetchSubscriptionsFor(UserNotificationActions.java:65)
	at org.nuxeo.ecm.user.center.notification.UserNotificationActions.getUserSubscriptions(UserNotificationActions.java:54)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
	at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
	at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.nuxeo.ecm.platform.ui.web.util.NuxeoExceptionInterceptor.aroundInvoke(NuxeoExceptionInterceptor.java:78)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
	at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196)
	at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114)
	at org.nuxeo.ecm.user.center.notification.UserNotificationActions_$$_javassist_seam_79.getUserSubscriptions(UserNotificationActions_$$_javassist_seam_79.java)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
	at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:144)
	at org.jboss.seam.Component.callComponentMethod(Component.java:2319)
	at org.jboss.seam.Component.createInstanceFromFactory(Component.java:2156)
	at org.jboss.seam.Component.getInstanceFromFactory(Component.java:2127)
	at org.jboss.seam.Component.getInstance(Component.java:2025)
	at org.jboss.seam.Component.getInstance(Component.java:1997)
	at org.jboss.seam.Component.getInstance(Component.java:1991)
	at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
	at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
	at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:148)
	at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:51)
	at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
	at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
	at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
	at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
	at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
	at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:182)
	at javax.faces.component.UIData.getValue(UIData.java:732)
	at javax.faces.component.UIData.getDataModel(UIData.java:1822)
	at javax.faces.component.UIData.setRowIndexWithoutRowStatePreserved(UIData.java:484)
	at javax.faces.component.UIData.setRowIndex(UIData.java:473)
	at javax.faces.component.UIData.invokeOnComponent(UIData.java:1041)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.locateComponentByClientId(FaceletViewHandlingStrategy.java:2068)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.reapplyDynamicAdd(FaceletViewHandlingStrategy.java:2132)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.reapplyDynamicActions(FaceletViewHandlingStrategy.java:2119)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.buildView(FaceletViewHandlingStrategy.java:966)
	at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:99)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647)
	... 68 more

2016-12-05 16:59:48,181 ERROR [http-bio-0.0.0.0-8080-exec-7] [nuxeo-error-log] javax.servlet.ServletException: On requestURL: http://localhost:8080/nuxeo/view_home.faces
	at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:138)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoRequestControllerFilter.doFilter(NuxeoRequestControllerFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.webdav.service.WIRequestFilter.doFilter(WIRequestFilter.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilterInternal(NuxeoAuthenticationFilter.java:591)
	at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:36)
	at org.nuxeo.ecm.platform.ui.web.auth.oauth.NuxeoOAuthFilter.doFilter(NuxeoOAuthFilter.java:120)
	at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:34)
	at org.nuxeo.ecm.platform.ui.web.auth.oauth2.NuxeoOAuth2Filter.doFilter(NuxeoOAuth2Filter.java:68)
	at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:34)
	at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilter(NuxeoAuthenticationFilter.java:401)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.apidoc.filter.BaseApiDocFilter.doFilter(BaseApiDocFilter.java:56)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoCorsFilter.doFilter(NuxeoCorsFilter.java:66)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.exceptionhandling.NuxeoExceptionFilter.doFilter(NuxeoExceptionFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.encoding.NuxeoEncodingFilter.doFilter(NuxeoEncodingFilter.java:73)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: javax.servlet.ServletException: Failed to execute query: SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND ecm:isCheckedInVersion = 0 AND notif:notifications/*/subscribers/* = 'group:group'a', Syntax error: Invalid token <a> at offset 150
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:659)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.apidoc.filter.BaseApiDocFilter.doFilter(BaseApiDocFilter.java:56)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
	at org.nuxeo.elasticsearch.web.sync.UIThreadMarker.doFilter(UIThreadMarker.java:46)
	at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
	at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoThreadTrackerFilter.doFilter(NuxeoThreadTrackerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.core.management.jtajca.internal.Log4jWebFilter.doFilter(Log4jWebFilter.java:67)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:118)
	... 43 more
Caused by: org.nuxeo.ecm.core.query.QueryParseException: Failed to execute query: SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND ecm:isCheckedInVersion = 0 AND notif:notifications/*/subscribers/* = 'group:group'a', Syntax error: Invalid token <a> at offset 150
	at org.nuxeo.ecm.core.query.sql.parser.parser.parseFailed(parser.java:519)
	at org.nuxeo.ecm.core.query.sql.parser.parser.unrecovered_syntax_error(parser.java:510)
	at java_cup.runtime.lr_parser.parse(lr_parser.java:601)
	at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:39)
	at org.nuxeo.ecm.core.query.sql.SQLQueryParser.parse(SQLQueryParser.java:48)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker.buildQuery(NXQLQueryMaker.java:281)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:742)
	at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.doInvoke(JDBCMapperConnector.java:24)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:67)
	at com.sun.proxy.$Proxy66.query(Unknown Source)
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.query(SoftRefCachingMapper.java:86)
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1223)
	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:324)
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.query(SQLSession.java:389)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1174)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1120)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1104)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1084)
	at org.nuxeo.ecm.platform.ec.notification.service.UnrestrictedDocFetcher.run(UnrestrictedDocFetcher.java:46)
	at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:139)
	at org.nuxeo.ecm.platform.ec.notification.service.UnrestrictedDocFetcher.query(UnrestrictedDocFetcher.java:64)
	at org.nuxeo.ecm.platform.ec.notification.service.NotificationService.getSubscribedDocuments(NotificationService.java:544)
	at org.nuxeo.ecm.user.center.notification.UserNotificationActions.fetchSubscriptionsFor(UserNotificationActions.java:65)
	at org.nuxeo.ecm.user.center.notification.UserNotificationActions.getUserSubscriptions(UserNotificationActions.java:54)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
	at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
	at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.nuxeo.ecm.platform.ui.web.util.NuxeoExceptionInterceptor.aroundInvoke(NuxeoExceptionInterceptor.java:78)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
	at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
	at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
	at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196)
	at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114)
	at org.nuxeo.ecm.user.center.notification.UserNotificationActions_$$_javassist_seam_79.getUserSubscriptions(UserNotificationActions_$$_javassist_seam_79.java)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
	at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:144)
	at org.jboss.seam.Component.callComponentMethod(Component.java:2319)
	at org.jboss.seam.Component.createInstanceFromFactory(Component.java:2156)
	at org.jboss.seam.Component.getInstanceFromFactory(Component.java:2127)
	at org.jboss.seam.Component.getInstance(Component.java:2025)
	at org.jboss.seam.Component.getInstance(Component.java:1997)
	at org.jboss.seam.Component.getInstance(Component.java:1991)
	at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
	at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
	at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:148)
	at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:51)
	at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
	at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
	at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
	at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
	at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
	at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:182)
	at javax.faces.component.UIData.getValue(UIData.java:732)
	at javax.faces.component.UIData.getDataModel(UIData.java:1822)
	at javax.faces.component.UIData.setRowIndexWithoutRowStatePreserved(UIData.java:484)
	at javax.faces.component.UIData.setRowIndex(UIData.java:473)
	at javax.faces.component.UIData.invokeOnComponent(UIData.java:1041)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:1504)
	at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:713)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.locateComponentByClientId(FaceletViewHandlingStrategy.java:2068)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.reapplyDynamicAdd(FaceletViewHandlingStrategy.java:2132)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.reapplyDynamicActions(FaceletViewHandlingStrategy.java:2119)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.buildView(FaceletViewHandlingStrategy.java:966)
	at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:99)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647)
	... 68 more

2016-12-05 16:59:48,190 ERROR [http-bio-0.0.0.0-8080-exec-7] [nuxeo-error-log] 
Request Attributes:

org.jboss.seam.core.manager : Manager([0NXMAIN])
configurationService : org.nuxeo.runtime.services.config.ConfigurationServiceImpl@7b4eb079
contentViewService : org.nuxeo.ecm.platform.contentview.jsf.ContentViewServiceImpl@37036eae
org.jboss.seam.faces.validation : org.jboss.seam.faces.Validation@60253e46
currentDomain : DocumentModelImpl(6029820b-49af-404d-9d40-5045630572eb, path=/default-domain, title=6029820b-49af-404d-9d40-5045630572eb)
user_message : An unexpected error occurred. Click on the following links to get more information or go back to the application.
currentUserCenterView : Dashboard
exception_message : Failed to execute query: SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND ecm:isCheckedInVersion = 0 AND notif:notifications/*/subscribers/* = 'group:group'a', Syntax error: Invalid token <a> at offset 150
actionManager : org.nuxeo.ecm.platform.actions.ActionService@721b0e2c
notificationManager : org.nuxeo.ecm.platform.ec.notification.service.NotificationService@7cd8a56e
org.jboss.seam.core.conversationPropagation : org.jboss.seam.core.ConversationPropagation@5002d245
org.jboss.seam.transaction.transaction : org.jboss.seam.transaction.Transaction@199c010d
isInsidePersonalWorkspace : false
messageBundle : java.util.PropertyResourceBundle@33dc067c
select2Converter : org.nuxeo.ecm.platform.ui.select2.Select2Converter@a1626bc
org.jboss.seam.core.events : org.jboss.seam.core.Events@4cc04d41
deleteActions : org.nuxeo.ecm.webapp.action.DeleteActionsBean@35adb9bd
currentDocument : DocumentModelImpl(6029820b-49af-404d-9d40-5045630572eb, path=/default-domain, title=Domain)
requestedUrl : view_home.faces?old_conversationId=0NXMAIN
adminMessageActivated : false
NuxeoExceptionHandlerMarker : true
transientStateCleaner : org.nuxeo.ecm.webapp.context.TransientStateCleaner@6691a692
userManager : org.nuxeo.ecm.multi.tenant.MultiTenantUserManager@5d094f3a
org.jboss.seam.transaction.synchronizations : org.jboss.seam.transaction.SeSynchronizations@13edbb9f
nuxeoAliasBean : org.nuxeo.ecm.platform.ui.web.binding.alias.NuxeoAliasBean@4b55980e
com.sun.faces.context.ExternalContextFactoryImpl_KEY : com.sun.faces.context.ExternalContextImpl@201b02c0
userDomains : [DocumentModelImpl(6029820b-49af-404d-9d40-5045630572eb, path=/default-domain, title=6029820b-49af-404d-9d40-5045630572eb)]
nuxeoWebResourceDispatcher : org.nuxeo.ecm.webapp.resources.NuxeoWebResourceDispatcher@37fcf966
themeStylingService : org.nuxeo.theme.styling.service.ThemeStylingServiceImpl@49338d45
restHelper : org.nuxeo.ecm.platform.ui.web.rest.RestHelper@2e41e985
seamReload : org.nuxeo.ecm.webapp.seam.NuxeoSeamHotReloader@5634e38f
contentViewRestActions : org.nuxeo.ecm.platform.contentview.seam.ContentViewRestActions@6d317e6
lockActions : org.nuxeo.ecm.webapp.edit.lock.LockActionsBean@53dffbdc
nuxeo.disable.redirect.wrapper : true
nuxeoLayoutIdManager : org.nuxeo.ecm.platform.forms.layout.facelets.NuxeoLayoutIdManagerBean@72f32de3
org.jboss.seam.web.servletContexts : org.jboss.seam.web.ServletContexts@32a80a9
repositoryManager : org.nuxeo.ecm.core.api.repository.RepositoryManagerImpl@1d58cb0d
org.jboss.seam.web.requestContextPath : /nuxeo
nxDevModeSet : true
DocumentView : DocumentViewImpl [documentLocation=DocumentLocationImpl [docIdRef=6029820b-49af-404d-9d40-5045630572eb, docPathRef=/default-domain, docRef=6029820b-49af-404d-9d40-5045630572eb, serverName=default], parameters={tabIds=MAIN_TABS:home,TREE_EXPLORER:navtree_CONTENT_TREE,USER_CENTER:Notification}, patternName=home, subURI=null, tabId=null, viewId=view_documents]
org.jboss.seam.web.requestServletPath : /view_home.faces
currentServerLocation : org.nuxeo.ecm.platform.util.RepositoryLocation@5c13d641
securityError : false

Group name should be escaped when building NXQL query.

Attachments

Activity

People

Assignee:

Estelle Giuly

Reporter:

Vincent Dutat

Participants:

Estelle Giuly, Jenkins, Vincent Dutat

Votes:

0 Vote for this issue

Watchers:

3 Start watching this issue

Dates

Created:

2016-12-06 01:24

Updated:

2016-12-07 17:24

Resolved:

2016-12-07 16:25

Time Tracking

Estimated:

Not Specified

Remaining:

Logged: