Background
We are using Jira to manage our interview/hiring process. As such we have created a workflow to manage all the phases of this process.
Need
I need to be able to report metrics that show how many people (tasks) have been in a particular phase for a particular period of time.
Example (simplified workflow)
In Resume Review -> In Screening Interview -> In Live Interview
Give this workflow I am looking for a way to report how many people have been in each phase on a weekly basis. I.e. how many resume we have reviewed in the period, how many we people we have screened and how many we have interviewed.
Summary
I was hoping for this graph plugin to provide this functionality but I do not think it does nor do I think that any other plugin avaiable for Jira does provide it.
From what I understand is that I have no way to create a filter that returns to me the number of issues that have been in a particular workflow phase in the period, the best I can do is to retrieve how many are currently in a particular phase. One plugin we have installed allows to query how many issues have been created in a particular period but beside this I am not finding a way to get similar counts for each of my workflow phases.
Your assistance and feedback on this matter is much appreciated.
Regards,
Sylvain
Jira Version: Enterprise Edition, Version: 3.12.2-#300
Current Working Directory /opt/atlassian-jira-enterprise-3.12.2-standalone/bin
Java Version 1.5.0_08
JVM Version 1.0
JVM Implementation Version 1.5.0_08-b03
User Name jira
System Encoding UTF-8
Operating System Linux 2.6.18-8.1.10.el5
OS Architecture i386
Application Server Container Apache Tomcat/5.5.20
Database type mssql
Database JNDI address java:comp/env/jdbc/JiraDS
Database URL jdbc:jtds:sqlserver://sqljira312pro.db.zed.local:1433/JIRA_312
Database version 09.00.3042
Database driver jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2
Labels:
Description
Hello,
When I try to get a timechart report, I get this error:
Unable to produce timechart
Message: Failed to find valid field named: customfield_10110
If you want to file an issue, please add the configuration settings for this timechart report, the Summary of the filter used as shown on the left-hand side of FIND ISSUES, View and Hide for the filter, and the following stack trace.
com.consultingtoolsmiths.jira.plugins.timecharts.LocalIssue.updateFieldValue(LocalIssue.java:156) com.consultingtoolsmiths.jira.plugins.timecharts.Snapshot.updateIssue(Snapshot.java:122) com.consultingtoolsmiths.jira.plugins.timecharts.TimeChart.processChangeset(TimeChart.java:403)
...and much more
—
Indeed there's no field with the name customfield_10110, but with ID 10110 there sure is. I installed the timecharts-3.12.1 and jira-charting-plugin-1.3.13 according to instructions, but I probably have missed something (i.e. this is probably a user error), but I just can't figure out what went wrong.
This extension / Plugin is very vulnerable for robot-attacs as data can be entered without any additional verification.
The list of repliers can easily be generated automatically, and currently (october 2008) some persons are currently trying to hang up the list of attendees of the atlassian user group meeting in Berlin.
Automatically entered entries will eventually fill up the system causing a crash
It definately makes it very difficult to find the 'real' attendees in such a long list.
Suggestion: modify the plugin so it knows about this captcha setting in Confluence, and act accordingly.
I tested the version 1.2Beta1 both locally on Windows and on our Linux server and noticed (on Linux) due to permission problems that the folders for statistics and log files terracotta-2.7.0 creates on the nodes do not go to the defined places. tc-config.xml tries to define them to go to the terracotta_conf directory but in my standalone version (Windows) it goes to jira's bin folder and in Linux to the home folder. I have not had time to check the reason for this or how to fix this yet. On the terracotta server this problem does not exist. Statistics and log folders go to their correct places - to the terracotta_conf directory.
The existence of these folders should also be documented.
System Information
System Date Thursday, 09 Oct 2008
System Time 11:55:55
System Favourite Colour Sangria
Java Version 1.6.0_07
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 10.0-b23
Java Runtime Java(TM) SE Runtime Environment
Java VM Java HotSpot(TM) Server VM
User Name SYSTEM
User Timezone America/Los_Angeles
Operating System Windows XP 5.1
OS Architecture x86
Filesystem Encoding Cp1252
Java VM Memory Statistics
Total Memory 175 MB
Free Memory 64 MB
Used Memory 110 MB
Memory Graph [Used Memory (63 %)][Free Memory (37 %)]
37 % Free
Runtime Information
Database Dialect net.sf.hibernate.dialect.SQLServerIntlDialect
Database Connection URL jdbc:jtds:sqlserver://AZ:1433/CDICONFLUENCE
Database Driver Name net.sourceforge.jtds.jdbc.Driver
Database Driver Version 1.2
Database Connection Transaction Isolation Read committed
Database name Microsoft SQL Server
Database version 09.00.3042
Database Latency 0 ms
Application Server Apache Tomcat/5.5.23
Servlet Version 2.4
Server Base Url http://www.privateaction.com:8080
Confluence Home c:/confluence/data
Uptime 6 minutes, 55 seconds
Confluence Version 2.9.1
Build Number 1418
Labels:
Description
A system error has occurred — our apologies!
Please ask your Confluence administrator to create a support issue on Atlassian's support system at http://support.atlassian.com with the following information:
1. a description of your problem and what you were doing at the time it occurred
2. a copy of the error and system information found below
3. a copy of the application logs (if possible).
Your Confluence administrator can use the support request form to create a support ticket which will include this information.
We will respond as promptly as possible.
Thank you!
Return to site homepage...
Cause
org.apache.velocity.exception.ParseErrorException: Invalid arg #0 in directive #tag at line 36, column 33 of /templates/config.vm
at org.apache.velocity.Template.process(Template.java:137)
Stack Trace:[hide]
org.apache.velocity.exception.ParseErrorException: Invalid arg #0 in directive #tag at line 36, column 33 of /templates/config.vm
at org.apache.velocity.Template.process(Template.java:137)
at com.atlassian.confluence.util.velocity.ConfigurableResourceManager.loadResource(ConfigurableResourceManager.java:363)
at com.atlassian.confluence.util.velocity.ConfigurableResourceManager.getResource(ConfigurableResourceManager.java:304)
at org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.java:1102)
at org.apache.velocity.runtime.RuntimeInstance.getTemplate(RuntimeInstance.java:1077)
at org.apache.velocity.app.VelocityEngine.getTemplate(VelocityEngine.java:528)
at com.opensymphony.webwork.dispatcher.VelocityResult.getTemplate(VelocityResult.java:146)
at com.atlassian.xwork.results.ProfiledVelocityResult.getTemplate(ProfiledVelocityResult.java:34)
at com.opensymphony.webwork.dispatcher.VelocityResult.doExecute(VelocityResult.java:75)
at com.atlassian.xwork.results.ProfiledVelocityResult.doExecute(ProfiledVelocityResult.java:21)
at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:116)
at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:263)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:187)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.security.interceptors.CaptchaInterceptor.intercept(CaptchaInterceptor.java:46)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:48)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.CancellingInterceptor.intercept(CancellingInterceptor.java:23)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:54)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.CommentAwareInterceptor.intercept(CommentAwareInterceptor.java:43)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:120)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:97)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229)
at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:153)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:109)
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.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.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.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192)
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.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120)
at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:28)
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:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35)
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.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
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:142)
at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
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:94)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64)
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.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
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:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
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.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
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:685)
at java.lang.Thread.run(Thread.java:619)
Total Memory: 148 MB
Used Memory: 114 MB
Free Memory: 34 MB
System Information
favouriteColour: Sangria
javaRuntime: Java(TM) SE Runtime Environment
jvmVersion: 1.0
operatingSystem: Windows XP 5.1
fileSystemEncoding: Cp1252
javaVm: Java HotSpot(TM) Server VM
javaVendor: Sun Microsystems Inc.
userTimezone: America/Los_Angeles
jvmImplementationVersion: 10.0-b23
appServer: Apache Tomcat
date: Thursday, 09 Oct 2008
time: 11:51:23
jvmVendor: Sun Microsystems Inc.
userName: SYSTEM
javaVersion: 1.6.0_07
operatingSystemArchitecture: x86
Cluster Information
That's a weird one... did it happened right after installing it? it is possible that the plugin did not get loaded properly... could you try re-starting the server?
The documentation says that "entityengine.xml : it shows how to modify the original entity-model-reader in JIRA entityengine.xml", but is not present at all:
Files provided by jira-plugin-kaamelot-settings-3.13.1.33.jar in edit-webapp folder are only :
new files to install (some JSPs and entitymodel.Kaamelot.AddOn.xml)
sample file without conflict with JIRA (i.e. entitygroup.kaamelot.xml)
All other modifications to perform on JIRA installation are described in the file properties/replacement.properties
For example, changes to apply in entityengine.xml are described as follow :
This file is used by the automated build process Kaamelot JIRA Build Kit. It usage may be interesting if you are already using Maven, and have too plugins available in a Maven Repository.
Note that entityengine.xml is not the only file to update. Are also concerned :
It seems that the plugin is not handling date-transfers correctly. Salesforce.com knows that it is in the Eastern time zone. And JIRA knows that it is in the same timezone. But if I sync a date between a JIRA record and my salesforce record, one of them is 4 hours off (GMT-5 + 1 for daylight savings).