Uploaded image for project: 'nFeed'
  1. nFeed
  2. NFEED-103

Followed "Select data based on native customfield" use case but encountered an issue getting parent field value on load

    Details

    • Type: Bug
    • Status: Closed (View workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.3.2.3
    • Fix Version/s: None
    • Labels:
      None

      Description

      Hi,
      I followed the use case here to create an SQLFeed field with a native "select" custom field.

      The selection seems to be working... I save the issue but when I reopen the issue to edit the SQLFeed field is empty.

      Looking at the logs when loading the EditIssue!default.jspa page the query does not know the parent field value. Once I click on the SQLFeed field it gets the parent field value and works...

      2012-01-19 07:02:53,856 http-8080-6 DEBUG jsword 422x706x1 1fr4b5j 1.220.3.119 /secure/EditIssue!default.jspa [plugins.sql.utils.DefaultSQLQueryFinderImpl] JNDI : java:comp/env/jdbc/JIRAAUX
      2012-01-19 07:02:53,856 http-8080-6 DEBUG jsword 422x706x1 1fr4b5j 1.220.3.119 /secure/EditIssue!default.jspa [plugins.sql.utils.DefaultSQLQueryFinderImpl] query : SELECT TEMP.CHILDVALUE as DisplayText, TEMP.CHILDID AS ID,0 FROM JIRAAUX.SQLFEED_PROPOSEDRESOL_VIEW TEMP WHERE TEMP.CHILDFIELDID = 11702 and PROPOSEDRESOLUTIONID = '' UNION SELECT TEMP.CHILDVALUE as DisplayText, TEMP.CHILDID AS ID, 1 FROM JIRAAUX.SQLFEED_PROPOSEDRESOL_VIEW TEMP WHERE TEMP.CHILDFIELDID = 11702 and PROPOSEDRESOLUTIONID = 0 ORDER BY 3,1 
      java.lang.NullPointerException
      	at com.valiantys.jira.plugins.sql.customfield.SQLCustomFieldViewHelper.getFormattedDatabaseRow(SQLCustomFieldViewHelper.java:185)
      	at com.valiantys.jira.plugins.sql.customfield.SQLCustomFieldViewHelper.getFormattedDatabaseRow(SQLCustomFieldViewHelper.java:90)
      	at com.valiantys.jira.plugins.sql.customfield.SQLCustomFieldViewHelper.getUpdatedHtmlForView(SQLCustomFieldViewHelper.java:264)
      	at sun.reflect.GeneratedMethodAccessor344.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:234)
      	at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:203)
      	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
      	at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
      	at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:51)
      	at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:95)
      	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
      	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
      	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
      	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
      	at org.apache.velocity.Template.merge(Template.java:256)
      	at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:422)
      	at com.atlassian.velocity.DefaultVelocityManager.getEncodedBody(DefaultVelocityManager.java:77)
      	at com.atlassian.velocity.DefaultVelocityManager.getEncodedBody(DefaultVelocityManager.java:61)
      	at com.atlassian.velocity.DefaultVelocityManager.getEncodedBody(DefaultVelocityManager.java:56)
      	at com.atlassian.jira.plugin.JiraResourcedModuleDescriptor.getHtml(JiraResourcedModuleDescriptor.java:109)
      	at com.atlassian.jira.plugin.customfield.CustomFieldTypeModuleDescriptorImpl.getEditHtml(CustomFieldTypeModuleDescriptorImpl.java:82)
      	at com.atlassian.jira.issue.fields.CustomFieldImpl.getEditHtml(CustomFieldImpl.java:890)
      	at com.atlassian.jira.issue.fields.screen.AbstractFieldScreenLayoutItem.getEditHtml(AbstractFieldScreenLayoutItem.java:78)
      	at com.atlassian.jira.issue.fields.screen.FieldScreenRenderLayoutItemImpl.getEditHtml(FieldScreenRenderLayoutItemImpl.java:62)
      	at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)
      	at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)
      	at webwork.util.ValueStack.findValue(ValueStack.java:514)
      	at webwork.util.ValueStack.findValue(ValueStack.java:213)
      	at webwork.view.taglib.WebWorkBodyTagSupport.findValue(WebWorkBodyTagSupport.java:62)
      	at webwork.view.taglib.BasicPropertyTag.doStartTag(BasicPropertyTag.java:54)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspx_meth_ww_005fproperty_005f4(issuefields_jsp.java:623)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspx_meth_ww_005felse_005f0(issuefields_jsp.java:594)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspx_meth_ww_005fif_005f5(issuefields_jsp.java:511)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspx_meth_ww_005fiterator_005f2(issuefields_jsp.java:472)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspx_meth_ww_005fiterator_005f1(issuefields_jsp.java:381)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspx_meth_ww_005fif_005f0(issuefields_jsp.java:159)
      	at org.apache.jsp.template.standard.issuefields_jsp._jspService(issuefields_jsp.java:94)
      	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
      	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
      	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
      	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
      	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
      	at webwork.view.taglib.IncludeTag.include(IncludeTag.java:64)
      	at webwork.view.taglib.ui.ComponentTag.doEndTag(ComponentTag.java:269)
      	at org.apache.jsp.secure.views.issue.editissue_jsp._jspx_meth_ww_005fcomponent_005f0(editissue_jsp.java:1178)
      	at org.apache.jsp.secure.views.issue.editissue_jsp._jspx_meth_ww_005fif_005f3(editissue_jsp.java:1075)
      	at org.apache.jsp.secure.views.issue.editissue_jsp._jspx_meth_page_005fapplyDecorator_005f0(editissue_jsp.java:698)
      	at org.apache.jsp.secure.views.issue.editissue_jsp._jspx_meth_ww_005fif_005f2(editissue_jsp.java:632)
      	at org.apache.jsp.secure.views.issue.editissue_jsp._jspService(editissue_jsp.java:157)
      	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
      	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
      	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	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.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
      	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:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:75)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150)
      	at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
      	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
      	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
      	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
      	at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.dispatchView(JiraWebworkActionDispatcher.java:286)
      	at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:188)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	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.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
      	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:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:103)
      	at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:87)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:54)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
      	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
      	at com.atlassian.jira.web.filters.PathExclusionFilter.doFilter(PathExclusionFilter.java:118)
      	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150)
      	at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	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:71)
      	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:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
      	at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:19)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:75)
      	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	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.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25)
      	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:77)
      	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	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:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
      	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
      	at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49)
      	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346)
      	at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463)
      	at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      	at java.lang.Thread.run(Thread.java:662)
      2012-01-19 07:02:53,862 http-8080-6 ERROR jsword 422x706x1 1fr4b5j 1.220.3.119 /secure/EditIssue!default.jspa [velocity] RHS of #set statement is null. Context will not be modified. templates/field/edit-sqlcombofield.vm [line 66, column 9]
      2012-01-19 07:10:26,719 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] in ComboServlet
      2012-01-19 07:10:26,722 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] parents list : 51200
      2012-01-19 07:10:26,723 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.component.SQLPLuginCacheManager] Le parameter com.valiantys.jira.plugins.sql.business.SQLCustomfieldInstanceBean@534afbb0 a été retrouvé du cach avec la clé customfield_11702
      2012-01-19 07:10:26,723 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [customfield.link.component.CustomFieldLinkConfigurationManagerImpl] CustomFieldLinkConfigurationManagerImpl - Retrieve configuration.
      2012-01-19 07:10:26,724 http-8080-4 INFO jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [customfield.link.component.CustomFieldLinkConfigurationManagerImpl] Configuration already in memory
      2012-01-19 07:10:26,724 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] Return Parsed param for query : SELECT TEMP.CHILDVALUE as DisplayText, TEMP.CHILDID AS ID,0 FROM JIRAAUX.SQLFEED_PROPOSEDRESOL_VIEW TEMP WHERE TEMP.CHILDFIELDID = 11702 and PROPOSEDRESOLUTIONID = '51200' UNION SELECT TEMP.CHILDVALUE as DisplayText, TEMP.CHILDID AS ID, 1 FROM JIRAAUX.SQLFEED_PROPOSEDRESOL_VIEW TEMP WHERE TEMP.CHILDFIELDID = 11702 and PROPOSEDRESOLUTIONID = 0 ORDER BY 3,1 
      2012-01-19 07:10:26,724 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] edit type
      2012-01-19 07:10:26,724 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] Filter retrieved
      2012-01-19 07:10:26,725 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.utils.DefaultSQLQueryFinderImpl] isUseCache : false
      2012-01-19 07:10:26,725 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.utils.DefaultSQLQueryFinderImpl] The result for this query will not be searched in cache
      2012-01-19 07:10:26,725 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.component.DataBaseManager] datasourceContext : java:comp/env/jdbc/JIRAAUX
      2012-01-19 07:10:26,725 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.utils.DefaultSQLQueryFinderImpl] JNDI : java:comp/env/jdbc/JIRAAUX
      2012-01-19 07:10:26,725 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.utils.DefaultSQLQueryFinderImpl] query : SELECT TEMP.CHILDVALUE as DisplayText, TEMP.CHILDID AS ID,0 FROM JIRAAUX.SQLFEED_PROPOSEDRESOL_VIEW TEMP WHERE TEMP.CHILDFIELDID = 11702 and PROPOSEDRESOLUTIONID = '51200' UNION SELECT TEMP.CHILDVALUE as DisplayText, TEMP.CHILDID AS ID, 1 FROM JIRAAUX.SQLFEED_PROPOSEDRESOL_VIEW TEMP WHERE TEMP.CHILDFIELDID = 11702 and PROPOSEDRESOLUTIONID = 0 ORDER BY 3,1 
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1590 with label Fix Cost Too High
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1429 with label Fix Introduces Excessive Risk
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1427 with label Fix Not Available Within Project Timeframe
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1589 with label Lack Of Business Case
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1072 with label Product Nearing End Of Life
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1071 with label Product Past End Of Life
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1431 with label Workaround Provided
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] adding value 1251 with label Other
      2012-01-19 07:10:26,727 http-8080-4 DEBUG jsword 430x744x1 1fr4b5j 1.220.3.119 /plugins/servlet/sqlComboServlet [plugins.sql.servlet.SQLComboServlet] xml : <optionList><option><value>1590</value><label>Fix Cost Too High</label></option><option><value>1429</value><label>Fix Introduces Excessive Risk</label></option><option><value>1427</value><label>Fix Not Available Within Project Timeframe</label></option><option><value>1589</value><label>Lack Of Business Case</label></option><option><value>1072</value><label>Product Nearing End Of Life</label></option><option><value>1071</value><label>Product Past End Of Life</label></option><option><value>1431</value><label>Workaround Provided</label></option><option><value>1251</value><label>Other</label></option></optionList>
      

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                alice.paillard@valiantys.com alice.paillard@valiantys.com
                Reporter:
                jsword Jon Sword (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: