Events fail to load when a large number of "Single dates" are selected

XMLWordPrintable

    • 2
    • Minor
    • 1

      Issue Summary

      Team Calendars can be used to display Jira events. When we try to display the Jira Date events by choosing multiple "Single Date" from the list, it fails to load and an error is thrown as below

       Unable to load events of <Event Name>

      Steps to Reproduce

      1. Create around 100 issues on Jira that have around 30 custom date picker fields.
      2. On Confluence create a calendar.
      3. Add the "Jira Issue Dates" event and enter a JQL to display the issues created in Jira in step 1.
      4. Choose all the 30 date picker fields in the "Single Date" section for the event.
      Document for adding the Jira event: Jira event on Teams calendar 

      Expected Results

      The events should load on the calendar

      Actual Results

      Error thrown: Unable to load events of <Event Name>

      Error on HAR:

      URL: https://SITENAME.atlassian.net/wiki/rest/calendar-services/1.0/calendar/events.json?subCalendarId=CalendarID&userTimeZoneId=Europe/Amsterdam&start=YYYY-MM-DDTHH:MM:SSZ&end=YYYY-MM-DDTHH:MM:SSZ

Status Code: 500 Internal Server Error

Response: {"empty":false}

      Application error:

      message: Unable to load events of sub-calendar 645xyxyxy-xxxx-yyyy-zzzz-a5479aasdfgh

      message: Exception encountered when retrieving value with a supplier in com.atlassian.confluence.extra.calendar3.calendarstore.generic.JiraIssueDatesSubCalendarDataStore_subcalendar-data for key <user_key>:645xyxyxy-xxxx-yyyy-zzzz-a5479aasdfgh:jira://<applinkID>?jql=project+%3D+%22FR+Test%22+AND+issuetype+%3D+Bug+AND+assignee+%3D+605b0921b18de50071f812f2+AND+created+%3E%3D+startOfYear%28%29+AND+resolution+%3D+Unresolved+order+by+updated+DESC&dateFieldName=customfield_10190&dateFieldName=customfield_10191&dateFieldName=customfield_10192&dateFieldName=customfield_10193&dateFieldName=sprint&dateFieldName=customfield_10194&dateFieldName=customfield_10195&dateFieldName=customfield_10196&dateFieldName=customfield_10197&dateFieldName=customfield_10198&dateFieldName=customfield_10199&dateFieldName=customfield_10210

      Workaround

      • Reduce the number of dates displayed for the event, the events load after a few seconds and don't result in a timeout.
      • The events load when we have lesser number of Single dates selected

            Assignee:
            Unassigned
            Reporter:
            Bharath Kumar
            Votes:
            39 Vote for this issue
            Watchers:
            16 Start watching this issue

              Created:
              Updated:
              Resolved: