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

Number of returned documents by an Elasticsearch query is limited

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8.0-HF32, 6.0-HF09, 7.2
    • Fix Version/s: 6.0-HF12, 7.3
    • Component/s: Elasticsearch

      Description

      Even when asking for all documents (limit(-1)) there is a limitation depending on the db backend when fetching document from VCS.

      For instance Oracle will not allow to load more than 1000 docs:

       Caused by: org.nuxeo.ecm.core.api.ClientRuntimeException: org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ORA-01795: maximum number of expressions in a list is 1000

        Attachments

          Issue Links

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-16850 Excel export of 1000+ documents from an elasticsearch-enabled content view fails with error 'ORA-01795: maximum number of expressions in a list is 1000'

          • Major - Major loss of function.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: