Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-79628

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

XMLWordPrintable

      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

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

                Created:
                Updated:
                Resolved: