[Z3005] query failed: [-1] ORA-01795: maximum number of expressions in a list is 1000

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Minor
    • 2.2.5rc1, 2.3.2
    • Affects Version/s: 2.2.3
    • Component/s: Server (S)

      If we send in a low-level discovery JSON with 3000 elements, we get this error in the server log:

      [Z3005] query failed: [-1] ORA-01795: maximum number of expressions in a list is 1000 [select key_ from items where hostid=10105 and key_ in ('echo[1]','echo[2]','echo[3]','echo[4]','echo[5]','echo[6]',...,'echo[2998]','echo[2999]','echo[3000]')

            Assignee:
            Unassigned
            Reporter:
            Aleksandrs Saveljevs
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: