Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-39193

ORA-01795 in Bulk User action when selecting more than 1000 users

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Deferred
    • 2.4, 2.7.2
    • None
    • Database SQL/XMLDB
    • Oracle
    • MOODLE_24_STABLE, MOODLE_27_STABLE
    • Hide

      To get rid of the error, logout and login again, so the user selection setting in bulk user actions is lost.

      Show
      To get rid of the error, logout and login again, so the user selection setting in bulk user actions is lost.
    • Moderate

    Description

      In Bulk User action, when selecting more than 1000 users the ORA-01795 errors appears.

      Thi issue as a direct relation with MDL-27071

      Attachments

        Issue Links

          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-27071 Oracle cannot cope withan IN operator with more than 1000 conditions in it

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-47227 User bulk selection results in Orable database errors when more than 1000 users are selected

          • Major - Major loss of function, incorrect output
          • Closed

          Activity

            People

              Unassigned Unassigned
              andreabix Andrea Bicciolo
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: