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 Service Pack Request
    • Status: Closed Closed (View Workflow)
    • Priority: Blocker 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.

        Issue Links

          Activity

          Hide
          Alfresco QA Team added a comment -

          Completely reproducible with 2.2.7 (build 531) on Windows installation:
          Windows 2003 x32, Tomcat 6.0.18, Oracle 11.1.0.7.0, JDK 6u16,
          JDBC driver: ojbc6.jar.

          Fails after creating 83 users upon 84th user creation on the clean installation.

          Show
          Alfresco QA Team added a comment - Completely reproducible with 2.2.7 (build 531) on Windows installation: Windows 2003 x32, Tomcat 6.0.18, Oracle 11.1.0.7.0, JDK 6u16, JDBC driver: ojbc6.jar. Fails after creating 83 users upon 84th user creation on the clean installation.
          Hide
          dward added a comment -

          Now required as a hotfix on 2.2.7 as they missed the service pack.

          Show
          dward added a comment - Now required as a hotfix on 2.2.7 as they missed the service pack.
          Hide
          jcohorn added a comment -

          Also seen in ACT 17268 and is blocking an upgrade. Tested fixing HibernateNodeDaoServiceImpl.java which allowed the upgrade to succeed. Hoping for this to be packaged soon.

          Show
          jcohorn added a comment - Also seen in ACT 17268 and is blocking an upgrade. Tested fixing HibernateNodeDaoServiceImpl.java which allowed the upgrade to succeed. Hoping for this to be packaged soon.
          Hide
          Jan Vonka added a comment -

          SVN r19833 (BRANCHES/V2.2) - targeted for 2.2 build 543

          Show
          Jan Vonka added a comment - SVN r19833 (BRANCHES/V2.2) - targeted for 2.2 build 543
          Hide
          Steve Rigby added a comment -

          For retest in 2.2.7.1

          Show
          Steve Rigby added a comment - For retest in 2.2.7.1
          Hide
          Alfresco QA Team added a comment -

          Successfully verified against Alfresco Enterprise 2.2.7.1 build 6 (standalone installation) on MS Windows 2003 Enterprise SP2 32bit, Tomcat 6.0.18 (JDK 1.6.0_11-b03), Oracle 11.1.0.7.0.
          JDBC driver: ojbc6.jar.

          1000 users, 50 group-users in 5 groups, 2 groups each with 2 sub-groups each with 10 users were successfully generated and verified.

          Show
          Alfresco QA Team added a comment - Successfully verified against Alfresco Enterprise 2.2.7.1 build 6 (standalone installation) on MS Windows 2003 Enterprise SP2 32bit, Tomcat 6.0.18 (JDK 1.6.0_11-b03), Oracle 11.1.0.7.0. JDBC driver: ojbc6.jar. 1000 users, 50 group-users in 5 groups, 2 groups each with 2 sub-groups each with 10 users were successfully generated and verified.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: