Issue Summary

In Confluence Team Calendars, when deleting a custom event type results in all reminders for other custom event types being reset to 'no reminder'. This behaviour has been observed in Confluence versions 8.9.8, 9.2.5 and 9.2.6.

Steps to Reproduce

1. Access the Confluence Team Calendar.
2. Create multiple custom event types with reminders.
3. Create a couple of new events from different custom events.
4. Delete one of the custom event types, and thus the events only for that type will be deleted.
5. Check if the reminders for the remaining custom event types have been reset to 'no reminder'.

Expected Results

The reminders for the remain Custom Types should maintain their values

Actual Results

All the reminders for the Custom Types are deleted. 

I am sharing a lab testing with my HAR file, where I can see the custom type deletion:

DELETE https://linux-105849.prod.atl-cd.net/confluence/rest/calendar-services/1.0/calendar/eventtype/custom.json

request: subCalendarId=e1752279-b993-4190-a621-b8c49c3de68d&customEventTypeId=058eeb1f-9cab-4ae9-acf0-391ce5880b31

And then a disable request:

PUT https://linux-105849.prod.atl-cd.net/confluence/rest/calendar-services/1.0/calendar/eventtype/disable.json
request: subCalendarId=e1752279-b993-4190-a621-b8c49c3de68d

Also, here is the DB output when reproducing the issue:

• AO_950DC#_TC_REMINDER_USERS has the same info before and after deletion:
  • 

• AO_950DC#_TC_REMINDER_SETTINGS has info before, but is empty after the custom deletion:
  • 

• Run the following query that shows the users with reminders. Before deletion shows the following. After deletion, there are no records:
    

• select 
  	"AO_950DC3_TC_SUBCALS"."NAME" AS "Calendar Name", 
  	user_mapping."lower_username" as "User who has reminder set",
  	"AO_950DC3_TC_EVENTS"."DESCRIPTION" as "Event description",
  	"AO_950DC3_TC_EVENTS"."SUMMARY" AS "Event Summary Field", 
  	"AO_950DC3_TC_EVENTS"."ALL_DAY" AS "All day event?(t=true/f=false)", 
  	LTRIM("AO_950DC3_TC_SUBCALS"."STORE_KEY", 'com.atlassian.confluence.extra.calendar3.calendarstore.generic.') AS "Event type (Generic/Travel/Birthday etc.)", 
  	("AO_950DC3_TC_REMINDER_SETTINGS"."PERIOD")/(1000*60) AS "Minutes before event to send reminder" 
  from 
  	"AO_950DC3_TC_REMINDER_USERS", 
  	user_mapping, 
  	"AO_950DC3_TC_SUBCALS", 
  	"AO_950DC3_TC_EVENTS", 
  	"AO_950DC3_TC_REMINDER_SETTINGS"
  where 
  	"AO_950DC3_TC_REMINDER_USERS"."USER_KEY" = user_mapping.user_key 
  and 
  	"AO_950DC3_TC_REMINDER_USERS"."SUB_CALENDAR_ID" = "AO_950DC3_TC_SUBCALS"."ID" 
  and 
  	"AO_950DC3_TC_EVENTS"."SUB_CALENDAR_ID" = "AO_950DC3_TC_SUBCALS"."ID" 
  and 
  	"AO_950DC3_TC_REMINDER_SETTINGS"."SUB_CALENDAR_ID" = "AO_950DC3_TC_SUBCALS"."PARENT_ID"
  

Workaround

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