[ 
https://jira.nuxeo.com/browse/NXP-7527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Benoit Delbosc resolved NXP-7527.
---------------------------------

       Resolution: Fixed
    Fix Version/s: 5.4.3

Fixed http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/b349e3efe3f8


> Prevents ORA-06532 on huge read ACL
> -----------------------------------
>
>                 Key: NXP-7527
>                 URL: https://jira.nuxeo.com/browse/NXP-7527
>             Project: Nuxeo Enterprise Platform
>          Issue Type: Bug
>          Components: Core SQL Storage
>    Affects Versions: 5.4.2
>         Environment: oracle
>            Reporter: Benoit Delbosc
>            Assignee: Benoit Delbosc
>             Fix For: 5.4.3
>
>   Original Estimate: 1 minute
>  Remaining Estimate: 1 minute
>
> When having more than 100 principals in a read acls the nx_list_read_acls_for 
> function raises the following error
> {code}
> Failed to execute query: ORA-06532: Subscript outside of limit
> ORA-06512: at "REFERENTIAL.SPLIT", line 13
> ORA-06512: at "REFERENTIAL.NX_LIST_READ_ACLS_FOR", line 18
> ORA-06512: at "REFERENTIAL.NX_GET_READ_ACLS_FOR", line 14
> {code}
> The 100 limit should be increase to something like 300.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets

Reply via email to