Created
September 12, 2016 20:45
-
-
Save MaximilianoRicoTabo/287ea2dbf57bf201584833f72ad9322e to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ERROR Column 'network6_nodes.c_activeRevision' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. | |
2016-Sep-12 20:30:51,275 TeamHubHandlerExceptionResolver | |
ERROR Error executing request: /topics/test.html | |
org.hibernate.exception.SQLGrammarException: could not extract ResultSet | |
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) | |
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) | |
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) | |
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) | |
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61) | |
at org.hibernate.loader.Loader.getResultSet(Loader.java:2040) | |
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1837) | |
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1816) | |
at org.hibernate.loader.Loader.doQuery(Loader.java:900) | |
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342) | |
at org.hibernate.loader.Loader.doList(Loader.java:2526) | |
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2371) | |
at org.hibernate.loader.Loader.list(Loader.java:2334) | |
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) | |
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) | |
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195) | |
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1275) | |
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) | |
at com.teamhub.dao.generic.impl.DirectQueryDaoHibernate.runSelect(DirectQueryDaoHibernate.java:40) | |
at com.teamhub.dao.generic.impl.DirectQueryDaoHibernate.runSelect(DirectQueryDaoHibernate.java:20) | |
at com.teamhub.managers.generic.impl.DirectQueryManagerImpl.runSelect(DirectQueryManagerImpl.java:40) | |
at com.teamhub.plugins.microsoft.controllers.MicrosoftTopicsController.viewTopic(MicrosoftTopicsController.java:220) | |
at com.teamhub.plugins.microsoft.controllers.MicrosoftTopicsController$$FastClassByCGLIB$$416207c6.invoke(<generated>) | |
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) | |
at com.teamhub.infrastructure.utils.BeanUtils$SecurityInterceptor.intercept(BeanUtils.java:633) | |
at com.teamhub.plugins.microsoft.controllers.MicrosoftTopicsController$$EnhancerByCGLIB$$70a2cef0.viewTopic(<generated>) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | |
at java.lang.reflect.Method.invoke(Unknown Source) | |
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) | |
at com.teamhub.infrastructure.spring.TeamHubAnnotationMethodHandlerAdapter.invokeHandlerMethod(TeamHubAnnotationMethodHandlerAdapter.java:403) | |
at com.teamhub.infrastructure.spring.TeamHubAnnotationMethodHandlerAdapter.handle(TeamHubAnnotationMethodHandlerAdapter.java:384) | |
at com.teamhub.infrastructure.servlet.TeamHubDispatcherServlet.doDispatchInternal(TeamHubDispatcherServlet.java:190) | |
at com.teamhub.infrastructure.servlet.TeamHubDispatcherServlet.doDispatch(TeamHubDispatcherServlet.java:136) | |
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) | |
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) | |
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) | |
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 com.teamhub.infrastructure.filter.HiddenHttpMethodFilter.doFilter(HiddenHttpMethodFilter.java:105) | |
at com.teamhub.infrastructure.filter.HiddenHttpMethodFilter.doFilter(HiddenHttpMethodFilter.java:92) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) | |
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:312) | |
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) | |
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.oauth.provider.filter.OAuthProviderProcessingFilter.doFilter(OAuthProviderProcessingFilter.java:182) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.oauth.provider.filter.OAuthProviderProcessingFilter.doFilter(OAuthProviderProcessingFilter.java:202) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.oauth.provider.filter.OAuthProviderProcessingFilter.doFilter(OAuthProviderProcessingFilter.java:202) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at com.teamhub.infrastructure.security.CSRFTokenInjectionFilter.doFilterInternal(CSRFTokenInjectionFilter.java:49) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at com.teamhub.infrastructure.security.CSRFFilter.doFilterInternal(CSRFFilter.java:144) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:119) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) | |
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:324) | |
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:174) | |
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) | |
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at com.teamhub.infrastructure.spring.FlashScopeFilter.doFilterInternal(FlashScopeFilter.java:32) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) | |
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) | |
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at com.teamhub.infrastructure.themes.TeamHubGzipFilter.doFilterInternal(TeamHubGzipFilter.java:36) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) | |
at com.teamhub.infrastructure.servlet.TeamHubContextFilter$1.call(TeamHubContextFilter.java:97) | |
at com.teamhub.infrastructure.hibernate.SessionFactoryWrapperRunner.run(SessionFactoryWrapperRunner.java:13) | |
at com.teamhub.infrastructure.hibernate.SessionFactoryWrapperRunner$$FastClassByCGLIB$$be05fcab.invoke(<generated>) | |
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) | |
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) | |
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) | |
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) | |
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) | |
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) | |
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) | |
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) | |
at com.teamhub.infrastructure.hibernate.SessionFactoryWrapperRunner$$EnhancerByCGLIB$$e54bd2ad.run(<generated>) | |
at com.teamhub.infrastructure.hibernate.SessionFactoryWrapper.runOnNetworkInternal(SessionFactoryWrapper.java:158) | |
at com.teamhub.infrastructure.hibernate.SessionFactoryWrapper.runWebRequest(SessionFactoryWrapper.java:102) | |
at com.teamhub.infrastructure.servlet.TeamHubContextFilter.doFilterInternal(TeamHubContextFilter.java:93) | |
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) | |
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.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) | |
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) | |
at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:188) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) | |
at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2377) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) | |
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) | |
at java.lang.Thread.run(Unknown Source) | |
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column 'network6_nodes.c_activeRevision' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. | |
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) | |
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635) | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426) | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372) | |
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) | |
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793) | |
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184) | |
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159) | |
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:284) | |
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) | |
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56) | |
... 147 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment