Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-55592

Deleting a calendar event triggers ORA-01795

    XMLWordPrintable

Details

    Description

      Summary

      Creating an event and inviting over than 1000 users makes it impossible to remove the event

      Environment

      Oracle Database

      Steps to reproduce

      1. Create an event
      2. Add more than 1000 invitees
      3. Save
      4. Try removing the event

      Expected results

      The calendar event is removed

      Actual Restuls

      The calendar event is not removed and Confluence throws an error.

      2018-05-17 17:03:11,700 ERROR [http-nio-8090-exec-6] [calendar3.rest.ExceptionMappers.GeneralExceptionMapper] getResponseError General exception happen on calendar resources
 -- referer: https://portal.onenetwork.com/display/OPS/Operations+Calendar | url: /rest/calendar-services/1.0/calendar/events.json | traceId: 79e6e3cdc6794786 | userName: dchisholm
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
	- name:Oracle
	- version:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
	- minor version:2
	- major version:12
Driver:
	- name:Oracle JDBC driver
	- version:12.2.0.1.0

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

      Workaround

      -

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-54194 Deleting Calendar from Team Calendar with more than 1000 events cause Oracle ORA-01795

          • Medium - Medium priority issues
          • Closed
          mentioned in

          Page Loading...

          Activity

            People

              dluong Duy Truong Luong
              drodrigues@atlassian.com Diego (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: