Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-467

Time Since Gadget configured with a filter using dateCompare throws error

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Done
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.1.17
    • Fix Version/s: None
    • Component/s: JQL Functions
    • Labels:
    • Environment:

      Jira server installed ver 6.2 and Confluence-Data Center ver 5.8.13.
      Script Runner version: 2.1.17. 'Time Since' gadget set up in confluence is viewed in variety of browsers and the error can be seen.

    • Critical Points:
      0

      Description

      Hello,

      We have encountered a weird issue and are seeking your help.
      One of our users has set up a 'Time Since' chart in Confluence which pulls issues from the filter below:
      issueFunction in dateCompare("Project = 'Global Problem Management' AND issuetype = 'Corrective Action' AND assignee in (arroth, kkrohn, ksiering, magherus, eugmarti, maxbecke, efilipov, asurace, wittig, zoet, lisco, mqotb, waechter) AND resolution!= Cancelled AND created > -730d AND 'Action Type' in('Permanent Corrective Action','Preventative Corrective Action') AND \"CA Due Date\" is not EMPTY AND resolved is not EMPTY ", "Resolved > CA Due Date") ORDER BY created DESC

      'Created' is the Date Field configured in the chart. We have seen that this chart throws error message 'An internal server occurred when requesting resource.' intermittently.

      Filter in Jira gives the results with out any error. This has been very weird as error is seen only in the chart set up in confluence and that too intermittently.

      There are no scripted fields here, but only the scripted jql-runction: dateCompare

      Please find the logs and comments from Atlassian support in the files attached.

      I appreciate your time in looking into this.

      Thanks,
      Pavan

        Attachments

        1. Log_1.txt
          3 kB
          Pavan Kumar Venkatasubramanya
        2. Log_2.txt
          1 kB
          Pavan Kumar Venkatasubramanya

          Issue Links

            Activity

              People

              Assignee:
              jechlin Jamie Echlin
              Reporter:
              pavenkat Pavan Kumar Venkatasubramanya
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: