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.