nFeed
  1. nFeed
  2. SQLFEED-103

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

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major 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>
      

        Issue Links

          Activity

          Hide
          alice.paillard@valiantys.com
          added a comment -

          Hi Jon,

          I forward the issue to the development team.

          Alice

          Show
          alice.paillard@valiantys.com
          added a comment - Hi Jon, I forward the issue to the development team. Alice
          Hide
          alice.paillard@valiantys.com
          added a comment -

          Hi Jon,

          I attached a snapshot that should fix this issue.
          Can you try it and let me know?

          Thanks,

          Show
          alice.paillard@valiantys.com
          added a comment - Hi Jon, I attached a snapshot that should fix this issue. Can you try it and let me know? Thanks,
          Hide
          Jon Sword
          added a comment -

          Hi Alice,
          A quick test on my dev system and it looks good.

          Thanks!
          Jon

          Show
          Jon Sword
          added a comment - Hi Alice, A quick test on my dev system and it looks good. Thanks! Jon
          Hide
          alice.paillard@valiantys.com
          added a comment -

          Hi,

          We are currently migrating our support to an external JIRA and up to tomorrow 15th you won't be able to comment nor create in this Studio project.
          That's why I created a copy of this issue on our new JIRA: https://jira.valiantys.com/browse/SSQLFEED-1

          Could you please sign up into that new JIRA with the same username as your Studio's one and leave a comment on the issue so that I change the reporter?
          The rest of the existing issues will be imported next week.

          Thanks,
          Alice

          Show
          alice.paillard@valiantys.com
          added a comment - Hi, We are currently migrating our support to an external JIRA and up to tomorrow 15th you won't be able to comment nor create in this Studio project. That's why I created a copy of this issue on our new JIRA: https://jira.valiantys.com/browse/SSQLFEED-1 Could you please sign up into that new JIRA with the same username as your Studio's one and leave a comment on the issue so that I change the reporter? The rest of the existing issues will be imported next week. Thanks, Alice
          Hide
          alice.paillard@valiantys.com
          added a comment -

          Dear customers,

          We are currently migrating our support to an external JIRA and up to today 12AM you won't be able to comment nor create in this Studio project.

          Url of that new JIRA is https://jira.valiantys.com/
          Could you please sign up into that new JIRA with the same username as your Studio's one?

          • For outstanding bugs and Support Requests: copy of these issues have been created, please leave a comment on the issue so that I change the reporter.
          • For resolved issues, improvements and new features: the rest of the existing issues will be imported next week.

          Thanks,
          Alice

          Show
          alice.paillard@valiantys.com
          added a comment - Dear customers, We are currently migrating our support to an external JIRA and up to today 12AM you won't be able to comment nor create in this Studio project. Url of that new JIRA is https://jira.valiantys.com/ Could you please sign up into that new JIRA with the same username as your Studio's one? For outstanding bugs and Support Requests : copy of these issues have been created, please leave a comment on the issue so that I change the reporter. For resolved issues, improvements and new features : the rest of the existing issues will be imported next week. Thanks, Alice

            People

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

              Dates

              • Created:
                Updated:
                Resolved: