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.

        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: