Getting Error: "An error occurred while trying to delete event jira" While trying to edit/delete event in Team Calendar
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When trying to delete or edit an event in Team Calendar, the following error is thrown in the UI:
Diagnosis
Environment
- This calendar was recently imported from a Confluence Cloud instance
- Newly created event or events from newly created Calendar does not exhibit this issue
Cause
It's a variation of this bug, (TEAMCAL-1596 - NPE when saving the modification on the event) where having a / anywhere in the UID section of your calendars causes an issue. In this case, it's likely that there's a string of /jira in the UID section.
In order to confirm this, run the following SQL query to confirm:
select "VEVENT_UID" from "AO_950DC3_TC_EVENTS" where "VEVENT_UID" like '%/jira';Should the SQL query above return some results, please follow the workaround below
Workaround
Perform a "Search and Replace" SQL query to remove the /jira from the UID
UPDATE "AO_950DC3_TC_EVENTS"
SET "VEVENT_UID" = REPLACE("VEVENT_UID",'/jira','');
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.