More than 1000 expressions in a list are not allowed on Oracle

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version: 21.0.2
Operating system and version: CentOs 7.9
Apache or nginx version: Apache 2.4.6
PHP version: 7.4.25

The issue you are facing:

Is this the first time you’ve seen this error?: Y

Steps to replicate it:

Perform operation which include more than 1000 expressions.

The output of your config.php file in /var/www/html/nextcloud/config (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'passwordsalt' => '*******',
  'secret' => '*******',
  'trusted_domains' => 
  array (
    0 => '*******',
    1 => '*******',
  ),
  'datadirectory' => '/var/nc_data/data',
  'dbtype' => 'mysql',
  'version' => '21.0.2.1',
  'overwrite.cli.url' => 'http://localhost',
  'htaccess.RewriteBase' => '/',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => '*******',
  'dbpassword' => '*******',
  'installed' => true,
  'instanceid' => '*******',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'redis' => 
  array (
    'host' => 'localhost',
    'port' => 6379,
  ),
  'log_type' => 'file',
  'loglevel' => '2',
  'log.condition' => 
  array (
    'apps' => 
    array (
      0 => 'admin_audit',
    ),
  ),
  'log_rotate_size' => '10485760',
  'remember_login_cookie_lifetime' => '3600',
  'trashbin_retention_obligation' => 'auto, 15',
  'versions_retention_obligation' => 'auto, 31',
  'defaultapp' => 'apporder',
  'maintenance' => false,
  'theme' => '',
  'enable_previews' => false,
  'aiio_plf_instance_id' => '*******',
  'data-fingerprint' => '*******',
  'mail_from_address' => '*******',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => '*******',
  'mail_smtphost' => '*******',
  'mail_smtpport' => '25',
  'mail_smtpauth' => 1,
  'mail_smtpname' => '******',
  'mail_smtppassword' => '****,
);

Log in nextcloud.log:

{
  "reqId": "YaoTU5yCDmoiVtDypEa9fQAAAJY",
  "level": 3,
  "time": "2021-12-03T12:53:40+00:00",
  "remoteAddr": "49.205.113.96",
  "user": "OSM_02",
  "app": "core",
  "method": "POST",
  "url": "/apps/aiio_gexp_app/datasets/bulk/export",
  "message": {
    "Exception": "Doctrine\\DBAL\\Query\\QueryException",
    "Message": "More than 1000 expressions in a list are not allowed on Oracle.",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/html/nextcloud/apps/aiio_gexp_app/lib/Db/DatasetMapper.php",
        "line": 253,
        "function": "execute",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/apps/aiio_gexp_app/lib/Db/DatasetMapper.php",
        "line": 178,
        "function": "fetchDatasets",
        "class": "OCA\\AIIO_GExP_App\\Db\\DatasetMapper",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/apps/aiio_gexp_app/lib/Service/DatasetExport/DatasetExportService.php",
        "line": 137,
        "function": "getEnabled",
        "class": "OCA\\AIIO_GExP_App\\Db\\DatasetMapper",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/apps/aiio_gexp_app/lib/Controller/DatasetApiController.php",
        "line": 597,
        "function": "bulkExportRequest",
        "class": "OCA\\AIIO_GExP_App\\Service\\DatasetExport\\DatasetExportService",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 218,
        "function": "bulkExport",
        "class": "OCA\\AIIO_GExP_App\\Controller\\DatasetApiController",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 127,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/lib/private/AppFramework/App.php",
        "line": 157,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/lib/private/Route/Router.php",
        "line": 302,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::"
      },
      {
        "file": "/var/www/html/nextcloud/lib/base.php",
        "line": 993,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->"
      },
      {
        "file": "/var/www/html/nextcloud/index.php",
        "line": 37,
        "function": "handleRequest",
        "class": "OC",
        "type": "::"
      }
    ],
    "File": "/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
    "Line": 268,
    "CustomMessage": "More than 1000 expressions in a list are not allowed on Oracle."
  },
  "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.54 Safari/537.36",
  "version": "21.0.2.1",
  "id": "61aa137ab81ab"
}

Have a look at GitHub issues, like the following `Doctrine\DBAL\Query\QueryException`: More than 1000 expressions in a list are not allowed on Oracle · Issue #26493 · nextcloud/server · GitHub
There are some reports about this error, some already fixed. Also there are a few versions after 21.0.2 already. You might want to look into these.