Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-1335

ORA-01795 (maximum number of expressions in a list is 1000) appears on attempt to create new user

    Details

    • Type: Service Pack Request
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.2.7
    • Fix Version/s: 2.2.7 HF, 2.2.8
    • Component/s: Repository
    • Labels:
      None
    • Environment:
      Stack 3: Solaris 10 Sparc x64, Weblogic 10.3.2.0 (JDK 1.6.0_17-b04), Oracle 11.2.0.1.0 x64.
    • ACT Numbers:

      17268

      Description

      Both for 2.2 SP6 (build 514) and SP7 (build 531) used with Oracle database ORA-01795 (maximum number of expressions in a list is 1000) exception appears on attempt to create new user as soon as certain number of users was created (83 for all the tests performed; creation of the 84th fails).

      09:14:18,199 ERROR [org.alfresco.web.ui.common.Utils] Failed to create Person due to error: could not execute query
      org.hibernate.exception.SQLGrammarException: could not execute query
      . . .
      Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

      (please find screen and full log in attach)

      As well it seems to be regression since 2.2 SP5: the same tested against 2.2.5.483 worked fine (including upgrade-to-3.2.0 testing performed in December 2009).

      Alfresco versions: 2.2 SP5 (build 483) / 2.2 SP6 (build 514) / 2.2 SP7 (build 531)
      JDBC driver: ojdbc14.jar.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs
                Reporter:
                alfrescoqa Alfresco QA Team
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: