Minyaa JIRA is now upgraded to JIRA 4.3.4 + Minyaa 3.1 !

Minyaa Suite

Workload Report Project: java.lang.IllegalStateException

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: 2.0
  • Fix Version/s: 2.4.1
  • Component/s: Minyaa Suite
  • Security Level: Public
  • Labels:
    None
  • Rank:
    Issue can not be ranked. 
  • Workers:
  • JIRA Release:
    4.0.2

Description

No results displayed and following exception is raised.
See also attached screenshots.

java.lang.IllegalStateException: Trying to combine JQL expressions without logical operator. The current JQL is '{project = 10140}'.
at com.atlassian.jira.jql.builder.PrecedenceSimpleClauseBuilder$OperatorState.add(PrecedenceSimpleClauseBuilder.java:703)
at com.atlassian.jira.jql.builder.PrecedenceSimpleClauseBuilder.clause(PrecedenceSimpleClauseBuilder.java:102)
at com.atlassian.jira.jql.builder.PrecedenceSimpleClauseBuilder.clause(PrecedenceSimpleClauseBuilder.java:28)
at com.atlassian.jira.jql.builder.DefaultJqlClauseBuilder.addTermialClause(DefaultJqlClauseBuilder.java:924)
at com.atlassian.jira.jql.builder.DefaultJqlClauseBuilder.addNumberCondition(DefaultJqlClauseBuilder.java:809)
at com.atlassian.jira.jql.builder.DefaultConditionBuilder.eq(DefaultConditionBuilder.java:39)
at com.atlassian.jira.plugin.report.workload.WorkloadHelper.getQueryIssues(WorkloadHelper.java:223)
at com.atlassian.jira.plugin.report.workload.WorkloadHelper.getMockWorkLogs(WorkloadHelper.java:134)
at com.atlassian.jira.plugin.report.workload.AWorkloadReport.getWorkLogs(AWorkloadReport.java:167)
at com.atlassian.jira.plugin.report.workload.AWorkloadReport.generateReport(AWorkloadReport.java:113)
at com.atlassian.jira.plugin.report.workload.AWorkloadReport.generateReportHtml(AWorkloadReport.java:58)
at com.atlassian.jira.web.action.browser.ConfigureReport.doExecute(ConfigureReport.java:112)
at webwork.action.ActionSupport.execute(ActionSupport.java:153)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141)
at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:154)
at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:133)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:40)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:206)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:53)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:581)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Vincent Thoulé added a comment - 24/Jun/10 9:47 AM

Note that criteria Category, Project and Developper are in most case exclusive.
If you select more than one of them, you have to be sure that there is no conflict.

With the name of your project REACH-IT Main, I suppose that it is in the Category REACH-IT !

  • Try without selecting the Category.
  • Check that your project is visible in the Category in Projects View.

Give me more details ...

Vincent

Show
Vincent Thoulé added a comment - 24/Jun/10 9:47 AM Note that criteria Category, Project and Developper are in most case exclusive. If you select more than one of them, you have to be sure that there is no conflict. With the name of your project REACH-IT Main, I suppose that it is in the Category REACH-IT !
  • Try without selecting the Category.
  • Check that your project is visible in the Category in Projects View.
Give me more details ... Vincent
Hide
Permalink
Ioannis Oikonomou added a comment - 24/Jun/10 12:48 PM

I know what you mean. However my selection should NOT give a conflict.
"REACH-IT Main" is a project under category "REACH-IT".
In any case, I would expect zero results and NOT an exception.
I tried with some other combinations, like not using the category, and in some cases it works, in some others not.
By the way, the very same query using the Kaamelot plugins on JIRA v3.11 runs without any problem and returns correct results (see attached screenshots).
Any ideas what can be the problem?

Thank you,
Ioannis

Show
Ioannis Oikonomou added a comment - 24/Jun/10 12:48 PM I know what you mean. However my selection should NOT give a conflict. "REACH-IT Main" is a project under category "REACH-IT". In any case, I would expect zero results and NOT an exception. I tried with some other combinations, like not using the category, and in some cases it works, in some others not. By the way, the very same query using the Kaamelot plugins on JIRA v3.11 runs without any problem and returns correct results (see attached screenshots). Any ideas what can be the problem? Thank you, Ioannis
Hide
Permalink
Vincent Thoulé added a comment - 25/Jun/10 9:16 AM

Did you notice that criteria in Minyaa Workload Reports are categorised as follow :

  • Agregation Criteria : Report Type, Display Mode
  • Filtering Criteria : Start and End Date of Worklogs, Category, Project and Developper
  • Display Criteria : Time format, Display Key and Summary

Excepted the Worklog Date, all other Filtering Criteria are used only if they are present in the Report Type.
If you use a report type "Project, Developer, Issue" and a filter on Category, the category would be ignored.

Can you also described how you process in the JIRA and Minyaa installation ?
Does the installation of all modules is correct : check state in Minyaa License (http://www.minyaa.com/documentation/latest/licenses/Minyaa.License.Registration.html#Plugins%20Installation).

Are your JIRA Dev. instance is available from Internet ?

V.

Show
Vincent Thoulé added a comment - 25/Jun/10 9:16 AM Did you notice that criteria in Minyaa Workload Reports are categorised as follow :
  • Agregation Criteria : Report Type, Display Mode
  • Filtering Criteria : Start and End Date of Worklogs, Category, Project and Developper
  • Display Criteria : Time format, Display Key and Summary
Excepted the Worklog Date, all other Filtering Criteria are used only if they are present in the Report Type. If you use a report type "Project, Developer, Issue" and a filter on Category, the category would be ignored. Can you also described how you process in the JIRA and Minyaa installation ? Does the installation of all modules is correct : check state in Minyaa License (http://www.minyaa.com/documentation/latest/licenses/Minyaa.License.Registration.html#Plugins%20Installation). Are your JIRA Dev. instance is available from Internet ? V.
Hide
Permalink
Ioannis Oikonomou added a comment - 31/Jan/11 11:09 AM

Hello Vincent,

Just a few days ago we bought and installed Minyaa on our JIRA v4.1.2.
Unfortunately this problem still persists
As I said in my last comment, I tried different combinations and in some cases it works, in some others not.
For e.g. it works if I don't select a category and I select only the project, while it doesn't work if I select both the category and project (see screenshot-1.jpg).
The problem is that I cannot understand the logic. Could you please help me on that?
Reading the documentaiton (http://www.minyaa.com/documentation/latest/Features/ModuleTime/WorklogReports/report-WorkloadProject.html) I understand that my selection in screenshot-1.jpg is valid and should normally work. What can be the problem?

Thank you,
Ioannis

Show
Ioannis Oikonomou added a comment - 31/Jan/11 11:09 AM Hello Vincent, Just a few days ago we bought and installed Minyaa on our JIRA v4.1.2. Unfortunately this problem still persists As I said in my last comment, I tried different combinations and in some cases it works, in some others not. For e.g. it works if I don't select a category and I select only the project, while it doesn't work if I select both the category and project (see screenshot-1.jpg). The problem is that I cannot understand the logic. Could you please help me on that? Reading the documentaiton (http://www.minyaa.com/documentation/latest/Features/ModuleTime/WorklogReports/report-WorkloadProject.html) I understand that my selection in screenshot-1.jpg is valid and should normally work. What can be the problem? Thank you, Ioannis
Hide
Permalink
Vincent Thoulé added a comment - 31/Jan/11 11:20 AM

The initial logic is that the criteria Category, Project and Developer are generally used as exclusive parameters.
In practice, before that JQL appears, it will be possible to use any combination until they are consistent (The selectd Project has to be in the selected Category).

The test I made since your last comment were done without using a combination of these 3 criteria.
I will perform today the test against 4.2.2 and 4.1.2 using the same type of value, and come back to you.

V.

Show
Vincent Thoulé added a comment - 31/Jan/11 11:20 AM The initial logic is that the criteria Category, Project and Developer are generally used as exclusive parameters. In practice, before that JQL appears, it will be possible to use any combination until they are consistent (The selectd Project has to be in the selected Category). The test I made since your last comment were done without using a combination of these 3 criteria. I will perform today the test against 4.2.2 and 4.1.2 using the same type of value, and come back to you. V.
Hide
Permalink
Vincent Thoulé added a comment - 31/Jan/11 11:28 AM

Errror confirmed

Show
Vincent Thoulé added a comment - 31/Jan/11 11:28 AM Errror confirmed

People

Vote (0)
Watch (1)

Dates

  • Created:
    24/Jun/10 5:18 AM
    Updated:
    31/Jan/11 11:35 AM
    Resolved:
    31/Jan/11 11:35 AM
Bug tracking and project tracking for software development powered by Atlassian JIRA (v4.3.4#620-r152668) | Report a problem
This JIRA site is for demonstration purposes only. Evaluate JIRA - bug tracking software for your team.