Error logged when opening Admin Page

[LotusAxt]

Hey,

The following error got logged, when I open the Recognize Admin Page.
Please let me know, if you need any other information in order to solve the Issue.

Thank you for your work!

{
  "reqId": "ILvjSRqWYyKKDqgGzZjK",
  "level": 3,
  "time": "2021-08-18T14:47:51+00:00",
  "remoteAddr": "172.17.0.1",
  "user": "Admin",
  "app": "core",
  "method": "GET",
  "url": "/index.php/apps/recognize/admin/countMissed",
  "message": "More than 1000 expressions in a list are not allowed on Oracle.",
  "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.91 Safari/537.36",
  "version": "22.1.0.1",
  "exception": {
    "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/lib/private/SystemTag/SystemTagObjectMapper.php",
        "line": 90,
        "function": "execute",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/recognize/lib/Service/TagManager.php",
        "line": 64,
        "function": "getTagIdsForObjects",
        "class": "OC\\SystemTag\\SystemTagObjectMapper",
        "type": "->",
        "args": [
          [
            "10",
            "12",
            [very long list of IDs, shortened by me],   
            "124878",
            "94403"
          ],
          "files"
        ]
      },
      {
        "file": "/var/www/html/apps/recognize/lib/Controller/AdminController.php",
        "line": 33,
        "function": "findMissedClassifications",
        "class": "OCA\\Recognize\\Service\\TagManager",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 217,
        "function": "countMissed",
        "class": "OCA\\Recognize\\Controller\\AdminController",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 126,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->",
        "args": [
          {
            "__class__": "OCA\\Recognize\\Controller\\AdminController"
          },
          "countMissed"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/App.php",
        "line": 156,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->",
        "args": [
          {
            "__class__": "OCA\\Recognize\\Controller\\AdminController"
          },
          "countMissed"
        ]
      },
      {
        "file": "/var/www/html/lib/private/Route/Router.php",
        "line": 301,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::",
        "args": [
          "OCA\\Recognize\\Controller\\AdminController",
          "countMissed",
          {
            "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
          },
          {
            "_route": "recognize.admin.count_missed"
          }
        ]
      },
      {
        "file": "/var/www/html/lib/base.php",
        "line": 1000,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->",
        "args": [
          "/apps/recognize/admin/countMissed"
        ]
      },
      {
        "file": "/var/www/html/index.php",
        "line": 36,
        "function": "handleRequest",
        "class": "OC",
        "type": "::",
        "args": []
      }
    ],
    "File": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
    "Line": 268,
    "CustomMessage": "More than 1000 expressions in a list are not allowed on Oracle."
  },
  "id": "611d1dec9cc41"
}

System:

NC 22.1.0 (Debian Buster Docker image)
DB: MariaDB 10
Recognize: 1.5.2 (But I think I got the error with 1.4.x too)

[marcelklehr]

Hi, sorry for your troubles and thank you for reporting! The new version seems to have some toothing problems. I'll investigate and release patches soon.