Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. 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'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.0
    • Fix Version/s: 7.3
    • Component/s: Content Views, Elasticsearch

      Description

      How to reproduce:

      • define a content view with use elasticsearch index
      • set nuxeo.pageprovider.default-max-page-size to a value higher than 1000 in nuxeo.conf
      • deploy to a Nx Platform with an Oracle DB
      • Navigate to a folderish using the content view
      • Click on Excel export icon

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-16874 Number of returned documents by an Elasticsearch query is limited

          • 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: