-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 9.0.2, 9.2.6
-
Component/s: Apps - Team Calendar
-
None
-
1
-
Severity 3 - Minor
-
0
Issue Summary
Events created in Confluence Team Calendar more than two months before the Subscription Date in Microsoft Outlook Calendar are not synced with Microsoft Outlook through CalDAVSynchronizer.
When subscribing to the Confluence Team Calendar from Microsoft Outlook using the CalDAVSynchronizer, Confluence searches for events with the following condition:
where ("AO_950DC3_TC_EVENTS"."UTC_START" < 1786579200000 and "AO_950DC3_TC_EVENTS"."UTC_END" > 1749772800000 or "AO_950DC3_TC_EVENTS"."UTC_START" = "AO_950DC3_TC_EVENTS"."UTC_END" and "AO_950DC3_TC_EVENTS"."UTC_END" >= 1749772800000 or "AO_950DC3_TC_EVENTS"."VEVENT_UID" in (select "AO_950DC3_TC_EVENTS"."VEVENT_UID" from "AO_950DC3_TC_EVENTS" "AO_950DC3_TC_EVENTS" where ("AO_950DC3_TC_EVENTS"."UTC_START" < 1786579200000 and "AO_950DC3_TC_EVENTS"."UTC_END" > 1749772800000 or "AO_950DC3_TC_EVENTS"."UTC_START" = "AO_950DC3_TC_EVENTS"."UTC_END" and "AO_950DC3_TC_EVENTS"."UTC_END" >= 1749772800000) and "AO_950DC3_TC_EVENTS"."RECURRENCE_ID_TIMESTAMP" is not null) and "AO_950DC3_TC_EVENTS"."RECURRENCE_ID_TIMESTAMP" is null) and "AO_950DC3_TC_EVENTS"."SUB_CALENDAR_ID" = '<SUB_CALENDAR_ID>'
- The UTC_START < 1786579200000 converted to Thu Aug 13 2026 00:00:00 GMT+0000
- The UTC_END > 1749772800000 converted to Fri Jun 13 2025 00:00:00 GMT+0000
This is how it looks from the DEBUG logs on com.atlassian.confluence.extra.calendar3 log package:
2025-08-12 14:29:42,087 INFO [http-nio-8090-exec-1] [calendar3.caldav.impl.DefaultCalDavCollectionManager] getCollection CalDav path /b0aa8acd-4b0a-49f0-a6c9-349ccb353002 ... 2025-08-12 14:29:42,109 DEBUG [http-nio-8090-exec-1] [calendar3.calendarstore.generic.ParentSubCalendarDataStore] fromStorageFormat Loaded ParentSubCalendar XXX Test Calendar with ID 8b439a9b-175e-4546-8c2b-931dab0d82c0 | traceId: 0e8e03fb7af71b3a 2025-08-12 14:29:42,138 DEBUG [http-nio-8090-exec-1] [extra.calendar3.calendarstore.AbstractCalendarDataStore] lambda$query$15 SQL query generate for query event method :select \"AO_950DC3_TC_EVENTS\".\"ID\", \"AO_950DC3_TC_EVENTS\".\"SUB_CALENDAR_ID\", \"AO_950DC3_TC_EVENTS\".\"UTC_START\", \"AO_950DC3_TC_EVENTS\".\"UTC_END\", null, \"AO_950DC3_TC_EVENTS\".\"RECURRENCE_RULE\", \"AO_950DC3_TC_EVENTS\".\"SUMMARY\", \"AO_950DC3_TC_EVENTS\".\"DESCRIPTION\", \"AO_950DC3_TC_EVENTS\".\"LOCATION\", \"AO_950DC3_TC_EVENTS\".\"URL\", \"AO_950DC3_TC_EVENTS\".\"ORGANISER\", \"AO_950DC3_TC_EVENTS\".\"RECURRENCE_ID_TIMESTAMP\", \"AO_950DC3_TC_EVENTS\".\"CREATED\", \"AO_950DC3_TC_EVENTS\".\"LAST_MODIFIED\", \"AO_950DC3_TC_EVENTS\".\"SEQUENCE\", null, \"AO_950DC3_TC_EVENTS\".\"ALL_DAY\", \"AO_950DC3_TC_EVENTS\".\"START\", \"AO_950DC3_TC_EVENTS\".\"END\", \"AO_950DC3_TC_SUBCALS\".\"TIME_ZONE_ID\", \"AO_950DC3_TC_EVENTS\".\"VEVENT_UID\", \"AO_950DC3_TC_SUBCALS\".\"NAME\", \"AO_950DC3_TC_SUBCALS\".\"PARENT_ID\", \"AO_950DC3_TC_SUBCALS\".\"USING_CUSTOM_EVENT_TYPE_ID\", \"AO_950DC3_TC_CUSTOM_EV_TYPES\".\"TITLE\", \"AO_950DC3_TC_SUBCALS\".\"SUBSCRIPTION_ID\"\nfrom \"AO_950DC3_TC_EVENTS\" \"AO_950DC3_TC_EVENTS\"\ninner join \"AO_950DC3_TC_SUBCALS\" \"AO_950DC3_TC_SUBCALS\"\non \"AO_950DC3_TC_EVENTS\".\"SUB_CALENDAR_ID\" = \"AO_950DC3_TC_SUBCALS\".\"ID\"\nleft join \"AO_950DC3_TC_CUSTOM_EV_TYPES\" \"AO_950DC3_TC_CUSTOM_EV_TYPES\"\non \"AO_950DC3_TC_CUSTOM_EV_TYPES\".\"ID\" = \"AO_950DC3_TC_SUBCALS\".\"USING_CUSTOM_EVENT_TYPE_ID\"\nwhere (\"AO_950DC3_TC_EVENTS\".\"UTC_START\" < 1786579200000 and \"AO_950DC3_TC_EVENTS\".\"UTC_END\" > 1749772800000 or \"AO_950DC3_TC_EVENTS\".\"UTC_START\" = \"AO_950DC3_TC_EVENTS\".\"UTC_END\" and \"AO_950DC3_TC_EVENTS\".\"UTC_END\" >= 1749772800000 or \"AO_950DC3_TC_EVENTS\".\"VEVENT_UID\" in (select \"AO_950DC3_TC_EVENTS\".\"VEVENT_UID\"\nfrom \"AO_950DC3_TC_EVENTS\" \"AO_950DC3_TC_EVENTS\"\nwhere (\"AO_950DC3_TC_EVENTS\".\"UTC_START\" < 1786579200000 and \"AO_950DC3_TC_EVENTS\".\"UTC_END\" > 1749772800000 or \"AO_950DC3_TC_EVENTS\".\"UTC_START\" = \"AO_950DC3_TC_EVENTS\".\"UTC_END\" and \"AO_950DC3_TC_EVENTS\".\"UTC_END\" >= 1749772800000) and \"AO_950DC3_TC_EVENTS\".\"RECURRENCE_ID_TIMESTAMP\" is not null) and \"AO_950DC3_TC_EVENTS\".\"RECURRENCE_ID_TIMESTAMP\" is null) and \"AO_950DC3_TC_EVENTS\".\"SUB_CALENDAR_ID\" = '6653c19b-51d0-4de1-a8d2-aea8a96ec0f2' | traceId: 0e8e03fb7af71b3a 2025-08-12 14:29:42,138 DEBUG [http-nio-8090-exec-1] [extra.calendar3.calendarstore.AbstractCalendarDataStore] lambda$query$15 Number of event has been found -> 7 | traceId: 0e8e03fb7af71b3a
In this case, only 7 out of hundreds of events are found and sync to Microsoft Outlook Calendar.
Steps to Reproduce
- Add a New Calendar in Confluence or import CalendarFileForReplication.ics
to create a new Calendar in Confluence. - Create a new recurring Event similar to the following on 14th May 2025.
- Subscribe to the Team Calendar from Microsoft Outlook via CalDAV (using the CalDAVSynchronizer) and Synchronise the events.
Expected Results
All of the events from the subscribed Calendar in Confluence will be sync to Microsoft Outlook Calendar.
Actual Results
Only the events created in the past 2-month period in Confluence will sync to Microsoft Outlook Calendar.
Workaround
- In Confluence, for recurring events, Edit one of the latest occurrences of the event and Save the event without making any changes.
- In Microsoft Outlook, click on Synchronise Now to sync the updated event.
- mentioned in
-
Page Loading...