API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 5th, 2014
223
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.22 KB | None | 0 0
raw download clone embed print report
  1.  
  2. ERREUR: la colonne « _F1.source » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'agrégat Position : 32
  3.  
  4. javax.servlet.ServletException: On requestURL: https://nuxeo.u-bordeaux.fr/nuxeo/view_documents.faces
  5. at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:145)
  6. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  7. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  8. at org.nuxeo.ecm.platform.wi.filter.WIRequestFilter.doFilter(WIRequestFilter.java:114)
  9. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  10. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  11. at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoRequestControllerFilter.doFilter(NuxeoRequestControllerFilter.java:145)
  12. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  13. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  14. at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilterInternal(NuxeoAuthenticationFilter.java:614)
  15. at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:35)
  16. at org.nuxeo.ecm.platform.ui.web.auth.oauth.NuxeoOAuthFilter.doFilter(NuxeoOAuthFilter.java:119)
  17. at org.nuxeo.ecm.platform.ui.web.auth.service.NuxeoAuthFilterChain.doFilter(NuxeoAuthFilterChain.java:33)
  18. at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilter(NuxeoAuthenticationFilter.java:410)
  19. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  20. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  21. at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoCorsFilter.doFilter(NuxeoCorsFilter.java:51)
  22. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  23. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  24. at org.nuxeo.ecm.platform.web.common.exceptionhandling.NuxeoExceptionFilter.doFilter(NuxeoExceptionFilter.java:79)
  25. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  26. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  27. at org.nuxeo.ecm.platform.web.common.encoding.NuxeoEncodingFilter.doFilter(NuxeoEncodingFilter.java:69)
  28. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  29. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  30. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  31. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  32. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  33. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  34. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
  35. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  36. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  37. at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
  38. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
  39. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
  40. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  41. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  42. at java.lang.Thread.run(Thread.java:744)
  43. Caused by: javax.servlet.ServletException: exception invoking: getPopularCloudOnAllDocuments
  44. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
  45. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  46. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  47. at org.nuxeo.wss.servlet.BaseWSSFilter.doFilter(BaseWSSFilter.java:137)
  48. at org.nuxeo.wss.servlet.FailSafeWSSFilter.doFilter(FailSafeWSSFilter.java:55)
  49. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  50. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  51. at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
  52. at org.nuxeo.ecm.platform.ui.web.multipart.MultipartFilter.doFilter(MultipartFilter.java:73)
  53. at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  54. at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
  55. at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  56. at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
  57. at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  58. at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
  59. at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
  60. at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368)
  61. at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495)
  62. at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
  63. at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
  64. at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
  65. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  66. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  67. at org.nuxeo.ecm.core.management.jtajca.internal.Log4jWebFilter.doFilter(Log4jWebFilter.java:64)
  68. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  69. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  70. at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:129)
  71. ... 37 more
  72. Caused by: java.lang.RuntimeException: exception invoking: getPopularCloudOnAllDocuments
  73. at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:148)
  74. at org.jboss.seam.Component.callComponentMethod(Component.java:2216)
  75. at org.jboss.seam.Component.getInstanceFromFactory(Component.java:2048)
  76. at org.jboss.seam.Component.getInstance(Component.java:1978)
  77. at org.jboss.seam.Component.getInstance(Component.java:1950)
  78. at org.jboss.seam.Component.getInstance(Component.java:1944)
  79. at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:55)
  80. at org.jboss.seam.Namespace.getComponentInstance(Namespace.java:50)
  81. at org.jboss.seam.el.SeamELResolver.resolveBase(SeamELResolver.java:166)
  82. at org.jboss.seam.el.SeamELResolver.getValue(SeamELResolver.java:53)
  83. at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)
  84. at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
  85. at org.jboss.el.parser.AstIdentifier.getValue(AstIdentifier.java:44)
  86. at org.jboss.el.parser.AstEmpty.getValue(AstEmpty.java:29)
  87. at org.jboss.el.parser.AstNot.getValue(AstNot.java:26)
  88. at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
  89. at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
  90. at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:390)
  91. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:924)
  92. at javax.faces.render.Renderer.encodeChildren(Renderer.java:148)
  93. at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
  94. at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:277)
  95. at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:258)
  96. at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:78)
  97. at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
  98. at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:277)
  99. at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:166)
  100. at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:83)
  101. at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:157)
  102. at org.ajax4jsf.renderkit.AjaxContainerRenderer.encodeAjax(AjaxContainerRenderer.java:123)
  103. at org.ajax4jsf.component.UIAjaxRegion.encodeAjax(UIAjaxRegion.java:263)
  104. at org.ajax4jsf.component.AjaxViewRoot$4.invokeContextCallback(AjaxViewRoot.java:489)
  105. at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:711)
  106. at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:675)
  107. at javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:720)
  108. at javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:675)
  109. at org.ajax4jsf.component.AjaxViewRoot.encodeChildren(AjaxViewRoot.java:543)
  110. at javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
  111. at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
  112. at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:100)
  113. at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:176)
  114. at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
  115. at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
  116. at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
  117. at org.nuxeo.ecm.platform.ui.web.lifecycle.NuxeoLifeCycleImpl.render(NuxeoLifeCycleImpl.java:98)
  118. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
  119. ... 63 more
  120. Caused by: org.nuxeo.ecm.core.api.ClientException: Failed to execute query: NXTAG: COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging: ERREUR: la colonne « _F1.source » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'agrégat
  121. Position : 32
  122. at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1677)
  123. at sun.reflect.GeneratedMethodAccessor514.invoke(Unknown Source)
  124. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  125. at java.lang.reflect.Method.invoke(Method.java:606)
  126. at org.nuxeo.ecm.core.api.TransactionalCoreSessionWrapper.invoke(TransactionalCoreSessionWrapper.java:136)
  127. at com.sun.proxy.$Proxy101.queryAndFetch(Unknown Source)
  128. at org.nuxeo.ecm.platform.tag.TagServiceImpl$UnrestrictedGetDocumentCloud.run(TagServiceImpl.java:531)
  129. at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:115)
  130. at org.nuxeo.ecm.platform.tag.TagServiceImpl.getTagCloud(TagServiceImpl.java:471)
  131. at org.nuxeo.ecm.platform.tag.web.TagActionsBean.getPopularCloudOnAllDocuments(TagActionsBean.java:228)
  132. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  133. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  134. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  135. at java.lang.reflect.Method.invoke(Method.java:606)
  136. at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
  137. at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
  138. at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
  139. at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
  140. at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  141. at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:68)
  142. at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  143. at org.nuxeo.ecm.platform.ui.web.util.NuxeoExceptionInterceptor.aroundInvoke(NuxeoExceptionInterceptor.java:79)
  144. at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  145. at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
  146. at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
  147. at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
  148. at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
  149. at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
  150. at org.nuxeo.ecm.platform.tag.web.TagActionsBean_$$_javassist_84.getPopularCloudOnAllDocuments(TagActionsBean_$$_javassist_84.java)
  151. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  152. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  153. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  154. at java.lang.reflect.Method.invoke(Method.java:606)
  155. at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
  156. at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:138)
  157. ... 108 more
  158. Caused by: org.nuxeo.ecm.core.query.QueryException: Invalid query: NXTAG: COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging
  159. at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.executeAndFetch(SQLSession.java:626)
  160. at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.queryAndFetch(SQLSession.java:540)
  161. at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1672)
  162. ... 142 more
  163. Caused by: org.nuxeo.ecm.core.storage.StorageException: Invalid query: NXTAG: COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging
  164. at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.queryAndFetch(JDBCMapper.java:921)
  165. at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.queryAndFetch(SoftRefCachingMapper.java:107)
  166. at org.nuxeo.ecm.core.storage.sql.SessionImpl.queryAndFetch(SessionImpl.java:1263)
  167. at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.queryAndFetch(ConnectionImpl.java:374)
  168. at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.executeAndFetch(SQLSession.java:623)
  169. ... 144 more
  170. Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « _F1.source » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'agrégat
  171. Position : 32
  172. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
  173. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
  174. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  175. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
  176. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
  177. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
  178. at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  179. at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  180. at org.nuxeo.ecm.core.storage.sql.jdbc.ResultSetQueryResult.(ResultSetQueryResult.java:74)
  181. at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.queryAndFetch(JDBCMapper.java:917)
  182. ... 148 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!