Getting system error on main Questions page when in Oracle and user has access to more than 1000 spaces

XMLWordPrintable

    • Severity 3 - Minor

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      If a user can view more than a 1000 spaces CQ crashes when in Oracle due to "ORA-01795: maximum number of expressions in a list is 1000"

      The initial cause of this is the query created in ContentTypeQuestionRepository.getRecentQuestionsIds although there could be others.

        1. Screen Shot 2015-04-14 at 5.17.16 pm.png
          461 kB
          Xavier Sanchez

            Assignee:
            Duy Truong Luong
            Reporter:
            Xavier Sanchez (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: