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

            Hide
            alfrescoqa 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
            alfrescoqa 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 Dave Ward [X] (Inactive) added a comment -

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

            Show
            dward Dave Ward [X] (Inactive) added a comment - Now required as a hotfix on 2.2.7 as they missed the service pack.
            Hide
            jcohorn 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 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
            jvonka Jan Vonka added a comment -

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

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

            For retest in 2.2.7.1

            Show
            srigby Steve Rigby added a comment - For retest in 2.2.7.1
            Hide
            alfrescoqa 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
            alfrescoqa 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:
                closedbugs Closed Bugs
                Reporter:
                alfrescoqa Alfresco QA Team
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: