Uploaded image for project: 'Atlassian Cloud'
  1. Atlassian Cloud
  2. CLOUD-11865

Exception while attempting to open a burndown chart show internal query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • Security
    • None

    Description

      Issue Summary

      This is reproducible on Data Center: (yes) / (no)

      Steps to Reproduce

      1. Try to open a burndown chart with an overly complicated query
      2. Wait for the exception

      Expected Results

      Show sanitized error.

      Actual Results

      Show the following error in screen:

      Uncaught exception thrown by REST service: Caught PSQLException for select "CHANGE_GROUP"."issueid", "CHANGE_ITEM"."fieldtype", "CHANGE_ITEM"."fieldid", "CHANGE_ITEM"."field", "CHANGE_ITEM"."oldvalue", "CHANGE_ITEM"."newvalue", "CHANGE_GROUP"."created"
      from "public"."jiraissue" "ISSUE"
      inner join "public"."changegroup" "CHANGE_GROUP"
      on "ISSUE"."id" = "CHANGE_GROUP"."issueid"
      inner join "public"."changeitem" "CHANGE_ITEM"
      on "CHANGE_GROUP"."id" = "CHANGE_ITEM"."groupid"
      where /* com.atlassian.jira.jql.dbquery.IssueTypeClauseDbQueryFactory */ ("ISSUE"."issuetype" = ANY (?)) and (/* com.atlassian.jira.jql.dbquery.ProjectClauseDbQueryFactory */ ("ISSUE"."project" = ANY (?)) and /* com.atlassian.jira.jql.dbquery.AssigneeClauseDbQueryFactory */ ("ISSUE"."assignee" = ANY (?) and not exists (select 1
      from "public"."invertedfieldscope" "INVERTED_FIELD_SCOPE_1"
      where "INVERTED_FIELD_SCOPE_1"."field_id" = ? and "INVERTED_FIELD_SCOPE_1"."issue_type_id" = "ISSUE"."issuetype" and "INVERTED_FIELD_SCOPE_1"."project_id" = "ISSUE"."project")) and (/* com.atlassian.greenhopper.customfield.epiclink.EpicLinkClauseDbQueryFactory */ (exists (select 1
      from "public"."issue_parent_association" "ISSUE_PARENT_ASSOCIATION"
      left join "public"."issuetype" "ISSUE_TYPE"
      on "ISSUE"."issuetype" = "ISSUE_TYPE"."id"
      inner join "public"."jiraissue" "parentIssue"
      on "ISSUE_PARENT_ASSOCIATION"."parent_id" = "parentIssue"."id"
      where "ISSUE_PARENT_ASSOCIATION"."parent_id" is not null and ("ISSUE"."id" = "ISSUE_PARENT_ASSOCIATION"."issue_id" and "ISSUE_TYPE"."hierarchy_level" != ?) and "ISSUE_TYPE"."project_configuration_id" is null and "parentIssue"."issuetype" = ?) and not exists (select 1
      from "public"."invertedfieldscope" "INVERTED_FIELD_SCOPE_2"
      where "INVERTED_FIELD_SCOPE_2"."field_id" = ? and "INVERTED_FIELD_SCOPE_2"."issue_type_id" = "ISSUE"."issuetype" and "INVERTED_FIELD_SCOPE_2"."project_id" = "ISSUE"."project")) or /* com.atlassian.jira.jql.dbquery.IssueTypeClauseDbQueryFactory */ ("ISSUE"."issuetype" = ANY (?)))) and /* com.atlassian.jira.jql.search.space.SearchSpacePredicateBuilder */ ("ISSUE"."soft_archived" = ? or "ISSUE"."soft_archived" is null) and "CHANGE_ITEM"."field" = ?
      order by "ISSUE"."pkey" desc nulls first, "ISSUE"."issuenum" desc nulls first, "CHANGE_ITEM"."id" asc 
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

      Attachments

        Activity

          People

            Unassigned Unassigned
            56014c3f73df Alexandre Pezzini
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: