Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-9817

Remove size limit on read acl for Oracle

    XMLWordPrintable

    Details

    • Tags:
    • Upgrade notes:
      Hide

      If you are subject to this bug (ORA-06502), you need to drop the ACLR table before starting Nuxeo.
      The ACLR table will be populated at startup, if you have lots of documents it can take time and you may need to either increase the startup delay (launcher.start.max.wait in the nuxeo.conf) either run the following SQL command:
      DROP TABLE ACLR;
      CREATE TABLE ACLR (acl_id VARCHAR2(34) NOT NULL, acl NCLOB);
      BEGIN nx_rebuild_read_acls; END;

      Show
      If you are subject to this bug (ORA-06502), you need to drop the ACLR table before starting Nuxeo. The ACLR table will be populated at startup, if you have lots of documents it can take time and you may need to either increase the startup delay (launcher.start.max.wait in the nuxeo.conf) either run the following SQL command: DROP TABLE ACLR; CREATE TABLE ACLR (acl_id VARCHAR2(34) NOT NULL, acl NCLOB); BEGIN nx_rebuild_read_acls; END;

      Description

      The size of the read acl field used by the ACL optimization must be configurable like it is in PostgreSQL since NXP-6004.

      When the size of the acl is bigger than 4k it raises:

      Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: java.sql.SQLException. message: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "NUXEO.NX_GET_READ_ACL", line 40
ORA-06512: at "NUXEO.NX_TRIG_HIER_READ_ACL_MOD", line 2
ORA-04088: error during execution of trigger 'NUXEO.NX_TRIG_HIER_READ_ACL_MOD'
ORA-06512: at "NUXEO.NX_UPDATE_READ_ACLS", line 36

        Attachments

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. NXP-6004 Canonicalize read acl to by pass 4k db limits

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: