javax.servlet.ServletException: javax.servlet.ServletException: org.support.project.common.exception.SystemException:

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • PO very slow on zkwebui
    via adempiere by bma99
    ,
  • Obscure error reporting
    via GitHub by omj
    ,
    • javax.servlet.ServletException: javax.servlet.ServletException: org.support.project.common.exception.SystemException: at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:309) at org.support.project.knowledge.listener.CloseAbleAuthenticationFilter.doFilter(CloseAbleAuthenticationFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.LoggingFilter.doFilter(LoggingFilter.java:62) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.EncodingFilter.doFilter(EncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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: org.support.project.common.exception.SystemException: at org.support.project.web.filter.ControlManagerFilter.doFilter(ControlManagerFilter.java:214) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.MultipartFilter.doFilter(MultipartFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.support.project.web.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:193) ... 25 more Caused by: org.support.project.common.exception.SystemException at org.support.project.common.util.ObjectUtils.invoke(ObjectUtils.java:136) at org.support.project.web.common.InvokeTarget.invoke(InvokeTarget.java:106) at org.support.project.web.filter.ControlManagerFilter.doInvoke(ControlManagerFilter.java:360) at org.support.project.web.filter.ControlFilter.invoke(ControlFilter.java:31) at org.support.project.web.filter.ControlManagerFilter.doFilter(ControlManagerFilter.java:181) ... 31 more Caused by: java.lang.reflect.InvocationTargetException at org.support.project.common.util.ObjectUtils.invoke(ObjectUtils.java:132) ... 35 more Caused by: org.support.project.ormapping.exception.ORMappingException: ERROR: 列"tags.tag_name"はGROUP BY句で出現しなければならないか、集約関数内で使用しなければなりません ポジション: 8 [cause] ERROR: 列"tags.tag_name"はGROUP BY句で出現しなければならないか、集約関数内で使用しなければなりません ポジション: 8 ----- SQL Infomation ----- [sql]SELECT TAGS.*, COUNT(KNOWLEDGE_TAGS.KNOWLEDGE_ID) AS KNOWLEDGE_COUNT FROM TAGS INNER JOIN KNOWLEDGE_TAGS ON (TAGS.TAG_ID = KNOWLEDGE_TAGS.TAG_ID) WHERE EXISTS ( SELECT KNOWLEDGES.KNOWLEDGE_ID FROM KNOWLEDGES INNER JOIN KNOWLEDGE_USERS ON (KNOWLEDGES.KNOWLEDGE_ID = KNOWLEDGE_USERS.KNOWLEDGE_ID) LEFT OUTER JOIN KNOWLEDGE_GROUPS ON (KNOWLEDGES.KNOWLEDGE_ID = KNOWLEDGE_GROUPS.KNOWLEDGE_ID) WHERE KNOWLEDGE_TAGS.KNOWLEDGE_ID = KNOWLEDGES.KNOWLEDGE_ID AND KNOWLEDGES.DELETE_FLAG = 0 AND ( KNOWLEDGE_USERS.USER_ID IN (0,?) OR KNOWLEDGE_GROUPS.GROUP_ID IN (?) ) ) AND TAGS.DELETE_FLAG = 0 GROUP BY TAGS.TAG_ID ORDER BY KNOWLEDGE_COUNT DESC, TAG_NAME LIMIT ? OFFSET ? [0]-2147483648 [1]-1 [2]10 [3]0 [execute]SELECT TAGS.*, COUNT(KNOWLEDGE_TAGS.KNOWLEDGE_ID) AS KNOWLEDGE_COUNT FROM TAGS INNER JOIN KNOWLEDGE_TAGS ON (TAGS.TAG_ID = KNOWLEDGE_TAGS.TAG_ID) WHERE EXISTS ( SELECT KNOWLEDGES.KNOWLEDGE_ID FROM KNOWLEDGES INNER JOIN KNOWLEDGE_USERS ON (KNOWLEDGES.KNOWLEDGE_ID = KNOWLEDGE_USERS.KNOWLEDGE_ID) LEFT OUTER JOIN KNOWLEDGE_GROUPS ON (KNOWLEDGES.KNOWLEDGE_ID = KNOWLEDGE_GROUPS.KNOWLEDGE_ID) WHERE KNOWLEDGE_TAGS.KNOWLEDGE_ID = KNOWLEDGES.KNOWLEDGE_ID AND KNOWLEDGES.DELETE_FLAG = 0 AND ( KNOWLEDGE_USERS.USER_ID IN (0,-2147483648) OR KNOWLEDGE_GROUPS.GROUP_ID IN (-1) ) ) AND TAGS.DELETE_FLAG = 0 GROUP BY TAGS.TAG_ID ORDER BY KNOWLEDGE_COUNT DESC, TAG_NAME LIMIT 10 OFFSET 0 at org.support.project.ormapping.dao.AbstractDao.executeQuery(AbstractDao.java:402) at org.support.project.ormapping.dao.AbstractDao.executeQueryList(AbstractDao.java:440) at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48) at org.support.project.knowledge.dao.TagsDao.selectWithKnowledgeCount(TagsDao.java:123) at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48) at org.support.project.knowledge.logic.TagLogic.selectTagsWithCount(TagLogic.java:44) at org.support.project.knowledge.control.open.KnowledgeControl.setSublistInformations(KnowledgeControl.java:247) at org.support.project.knowledge.control.open.KnowledgeControl.list(KnowledgeControl.java:449) ... 36 more Caused by: org.postgresql.util.PSQLException: ERROR: 列"tags.tag_name"はGROUP BY句で出現しなければならないか、集約関数内で使用しなければなりません ポジション: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305) at org.support.project.ormapping.dao.AbstractDao.executeQuery(AbstractDao.java:393) ... 43 more

    Users with the same issue

    Unknown visitor1 times, last one,
    jokester
    jokester1 times, last one,
    Unknown visitor2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    94 more bugmates