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


Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


7 months ago
Expert tip

Solutions on the web13

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
via GitHub by tac0x2a
, 2 days ago
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Solution icon of github
javax.servlet.ServletException: org.support.project.common.exception.SystemException:

Stack trace

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

Write tip

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

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
16 times, 2 months ago
Once, 4 months ago
Samebug visitor profile picture
Unknown user
2 times, 8 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
101 more bugmates