java.sql.SQLException: Three part identifiers prohibited in statement [select max(PUBLIC.changegroup.CREATED) from PUBLIC.changegroup, PUBLIC.changeitem where PUBLIC.changegroup.issueid = ? and PUBLIC.changegroup.ID = PUBLIC.changeitem.groupid and (PUBLIC.changeitem.FIELD = 'resolution' or PUBLIC.changeitem.FIELD = 'Resolution') and NEWSTRING is not null]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Bernard Davison, 1 year ago
Three part identifiers prohibited in statement [select max(PUBLIC.changegroup.CREATED) from PUBLIC.changegroup, PUBLIC.changeitem where PUBLIC.changegroup.issueid = ? and PUBLIC.changegroup.ID = PUBLIC.changeitem.groupid and (PUBLIC.changeitem.FIELD = 'resolution' or PUBLIC.changeitem.FIELD = 'Resolution') and NEWSTRING is not null]
via Atlassian JIRA by Bernard Davison, 1 year ago
Three part identifiers prohibited in statement [select max(PUBLIC.changegroup.CREATED) from PUBLIC.changegroup, PUBLIC.changeitem where PUBLIC.changegroup.issueid = ? and PUBLIC.changegroup.ID = PUBLIC.changeitem.groupid and (PUBLIC.changeitem.FIELD = 'resolution' or PUBLIC.changeitem.FIELD = 'Resolution') and NEWSTRING is not null]
via Atlassian JIRA by Riaz Khanmohamed, 1 year ago
Table not found in statement [select instantmes0_.IMSERVER_ID as IMSERVER1_, instantmes0_.TITLE as TITLE, instantmes0_.HOST as HOST, instantmes0_.PORT as PORT, instantmes0_.USERNAME as USERNAME, instantmes0_.PASSWORD as PASSWORD, instantmes0_.SSL as SSL from IMSERVER instantmes0_]
via Atlassian JIRA by Riaz Khanmohamed, 1 year ago
Table not found in statement [select instantmes0_.IMSERVER_ID as IMSERVER1_, instantmes0_.TITLE as TITLE, instantmes0_.HOST as HOST, instantmes0_.PORT as PORT, instantmes0_.USERNAME as USERNAME, instantmes0_.PASSWORD as PASSWORD, instantmes0_.SSL as SSL from IMSERVER instantmes0_]
via Coderanch by Migrated From Jforum.net, 10 months ago
S1000 General error java.util.NoSuchElementException in statement [SELECT post_time, p.topic_id, t.topic_replies, post_id, u.user_id, username FROM jforum_posts p, jforum_users u, jforum_topics t , jforum_forums f WHERE t.forum_id = f.forum_id AND
via Atlassian JIRA by Daniel Hurst, 1 year ago
Three part identifiers prohibited in statement [select distinct(PUBLIC.jiraaction.AUTHOR) from PUBLIC.jiraaction where PUBLIC.jiraaction.issueid = ? and PUBLIC.jiraaction.actiontype = 'comment' and (PUBLIC.jiraaction.actionlevel is null or PUBLIC.jiraaction.actionlevel in ('jira-administrators','jira-developers','jira-users'))]
java.sql.SQLException: Three part identifiers prohibited in statement [select max(PUBLIC.changegroup.CREATED) from PUBLIC.changegroup, PUBLIC.changeitem where PUBLIC.changegroup.issueid = ? and PUBLIC.changegroup.ID = PUBLIC.changeitem.groupid and (PUBLIC.changeitem.FIELD = 'resolution' or PUBLIC.changeitem.FIELD = 'Resolution') and NEWSTRING is not null]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:327)
at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:302)
at com.atlassian.jira.ext.charting.field.AbstractSingleDateDAO.calculateDate(AbstractSingleDateDAO.java:54)
at com.atlassian.jira.ext.charting.field.ResolutionDate.getValueFromIssue(ResolutionDate.java:32)
at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:266)
at com.atlassian.jira.issue.customfields.searchers.DateRangeSearcher$1.addIndex(DateRangeSearcher.java:102)
at com.atlassian.jira.issue.index.IssueDocument.getDocument(IssueDocument.java:34)
at com.atlassian.jira.issue.index.IssueDocumentBuilderImpl.get(IssueDocumentBuilderImpl.java:14)
at com.atlassian.jira.issue.index.SingleThreadedIssueIndexer.indexIssue(SingleThreadedIssueIndexer.java:187)
at com.atlassian.jira.issue.index.SingleThreadedIssueIndexer.indexIssuesAndComments(SingleThreadedIssueIndexer.java:140)
at com.atlassian.jira.issue.index.MultiThreadedIssueIndexer.indexIssuesAndComments(MultiThreadedIssueIndexer.java:39)
at com.atlassian.jira.issue.index.SingleThreadedIssueIndexer$5$1.perform(SingleThreadedIssueIndexer.java:362)
at com.atlassian.bonnie.ConcurrentLuceneConnection.withWriter(ConcurrentLuceneConnection.java:296)
at com.atlassian.jira.issue.index.SingleThreadedIssueIndexer$5.perform(SingleThreadedIssueIndexer.java:356)
at com.atlassian.bonnie.ConcurrentLuceneConnection.withWriter(ConcurrentLuceneConnection.java:296)
at com.atlassian.bonnie.ConcurrentLuceneConnection.withDeleteAndWrites(ConcurrentLuceneConnection.java:325)
at com.atlassian.jira.issue.index.SingleThreadedIssueIndexer.reindexIssues(SingleThreadedIssueIndexer.java:332)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssues(DefaultIndexManager.java:287)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssues(DefaultIndexManager.java:244)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssueObjects(DefaultIndexManager.java:252)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndex(DefaultIndexManager.java:257)
at com.atlassian.jira.workflow.SimpleWorkflowManager.doWorkflowAction(SimpleWorkflowManager.java:277)
at com.atlassian.jira.workflow.WorkflowTransitionUtilImpl.progress(WorkflowTransitionUtilImpl.java:264)
at com.atlassian.jira.web.action.issue.CommentAssignIssue.doExecute(CommentAssignIssue.java:218)
at webwork.action.ActionSupport.execute(ActionSupport.java:153)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:209)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:25)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at java.lang.Thread.run(Thread.java:534)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
7 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.