-
Bug
-
Resolution: Fixed
-
Low
-
7.4.0
-
2
-
Severity 3 - Minor
-
1
-
Issue Summary
Attempting to set up a notification on a Jira Release Data event type in Team Calendars results in a SQL exception and fails.
Steps to Reproduce
- Integrate Confluence & Team Calendars with a Jira instance (Bug report written with Confluence 7.4.0 -> Jira 8.5.4 -> Team Calendars )
- Create a Team Calendar in Confluence
- Create a few issues in Jira and also create a Release in Jira.
- Associate the issues with the Release and be sure to set a date on the Release Date. This date is what Team Calendars will display.
- From the Confluence calendar, create an Event and select Jira Release Dates and choose the project & it's release from the drop down. Secondlay, try to choose a reminder interval from the drop down menu.
Expected Results
You will be able to set a reminder interval for a Jira Release event type.
Actual Results
You'll receive the following SQL exception and setting up the reminder fails.
Unable to load events of Jira Named Release (xxxxx-xxxxx-xxxx): PreparedStatementCallback; SQL [INSERT INTO "AO_950DC3_TC_JIRA_REMI_EVENTS" ("KEY_ID", "SUB_CALENDAR_ID", "USER_ID", "JQL", "TICKET_ID", "ASSIGNEE", "STATUS", "TITLE", "DESCRIPTION", "EVENT_TYPE", "UTC_START", "UTC_END", "ALL_DAY", "ISSUE_LINK", "ISSUE_ICON_URL") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; ORA-01400: cannot insert NULL into ("CONF615U"."AO_950DC3_TC_JIRA_REMI_EVENTS"."TICKET_ID") ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONF615U"."AO_950DC3_TC_JIRA_REMI_EVENTS"."TICKET_ID")
Workaround
- Don't set a reminder for a Jira release event and the date of the release will still display correctly.
- Mirror the release date to a custom field and use a different event type to display and notify on the custom date rather than the OOTB release date event type option.
- Issue is not reproduced on Postgres
Notes
We need to validate this fix against all Oracle versions (12c and 19c) and above as supported in the upcoming releases of Confluence Supported Platforms
- mentioned in
-
![[Extranet] Page](/images/icons/generic_link_16.png "[Extranet] Page")
Page
Failed to load
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[CONFSERVER-59941] Setting a reminder on a Jira Release event type fails when using an Oracle database
| Labels | Original: pse-request qko-rating-check-week-34 tc-a | New: pse-request qko-rating-check-week-34 tc-a tc-e |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
| Labels | Original: pse-request qko-rating-check-week-34 | New: pse-request qko-rating-check-week-34 tc-a |
| Fix Version/s | New: TC-6.0.53 [ 92491 ] |
| Status | Original: Awaiting Merge [ 10064 ] | New: Waiting for Release [ 12075 ] |
| Status | Original: In Review [ 10051 ] | New: Awaiting Merge [ 10064 ] |
| Story Points | Original: 2 | New: 3 |
| QA Demo Status | Original: Not Done [ 14330 ] | New: Done [ 14331 ] |
| Labels | Original: pse-request | New: pse-request qko-rating-check-week-34 |
| QA Kickoff Status | Original: Not Done [ 14234 ] | New: Done [ 14235 ] |