# Bug OP-9611 - Try to open OpenProject  API: Failed to load API definition.

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-9611

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 12.0.5 |
| Observed in versions | 12.0.0 |
| Sprint | 12.0.5 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 12.0.x |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### **Environment**:

Your OpenProject Version: **OpenProject 12.0.4** 

Operating System: Ubuntu 20.04.3

### **Logs**

``` log
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.287078 #127717]  INFO -- : Started GET "/api/docs" for 192.168.101.182 at 2021-12-15 17:57:48 +0100
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.288257 #127717]  INFO -- : Processing by APIDocsController#index as HTML
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.289961 #127717] DEBUG -- :   User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."type" NOT IN ($5, $6, $7) AND "users"."status" = $8 AND "users"."id" = $9 LIMIT $10  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["status", 1], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.290501 #127717] DEBUG -- :    (0.2ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.291104 #127717]  INFO -- : OpenProject User: Max Mustermann (Maxs ID: 3 <Mustermann@xxxx.de>)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.292064 #127717] DEBUG -- :   Rendering layout layouts/angular/angular.html.erb
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.292116 #127717] DEBUG -- :   Rendering inline template within layouts/angular/angular
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.292312 #127717]  INFO -- :   Rendered inline template within layouts/angular/angular (Duration: 0.1ms | Allocations: 54)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.292984 #127717] DEBUG -- :   Rendering layouts/base.html.erb
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.294810 #127717] DEBUG -- :   CustomStyle Load (0.2ms)  SELECT "custom_styles".* FROM "custom_styles" ORDER BY created_at DESC LIMIT $1  [["LIMIT", 1]]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.295240 #127717] DEBUG -- :   EnterpriseToken Load (0.1ms)  SELECT "enterprise_tokens".* FROM "enterprise_tokens" ORDER BY created_at DESC LIMIT $1  [["LIMIT", 1]]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.296097 #127717] DEBUG -- :   Rendered common/_favicons.html.erb (Duration: 1.7ms | Allocations: 599)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.296736 #127717] DEBUG -- :    (0.3ms)  SELECT MAX(union_query.max_updated_at)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: FROM ((SELECT MAX(updated_at) AS max_updated_at FROM statuses) UNION (SELECT MAX(updated_at) AS max_updated_at FROM enumerations) UNION (SELECT MAX(updated_at) AS max_updated_at FROM types))
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: AS union_query
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: 
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.297176 #127717] DEBUG -- :   Rendered custom_styles/_inline_css_logo.erb (Duration: 0.2ms | Allocations: 117) [cache hit]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.297363 #127717] DEBUG -- :   Rendered layouts/_common_head.html.erb (Duration: 3.6ms | Allocations: 1968) [cache hit]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.297672 #127717] DEBUG -- :   Rendered modules/auth_plugins/app/views/hooks/login/_providers_css.html.erb (Duration: 0.1ms | Allocations: 95)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.298165 #127717] DEBUG -- :   Rendered warning_bar/_warning_bar.html.erb (Duration: 0.0ms | Allocations: 20)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.300026 #127717] DEBUG -- :   SQL (0.9ms)  SELECT "roles"."id" AS t0_r0, "roles"."name" AS t0_r1, "roles"."position" AS t0_r2, "roles"."assignable" AS t0_r3, "roles"."builtin" AS t0_r4, "roles"."type" AS t0_r5, "roles"."created_at" AS t0_r6, "roles"."updated_at" AS t0_r7, "role_permissions"."id" AS t1_r0, "role_permissions"."permission" AS t1_r1, "role_permissions"."role_id" AS t1_r2, "role_permissions"."created_at" AS t1_r3, "role_permissions"."updated_at" AS t1_r4 FROM "roles" LEFT OUTER JOIN "role_permissions" ON "role_permissions"."role_id" = "roles"."id" WHERE "roles"."id" IN (SELECT "roles"."id" FROM "users" LEFT OUTER JOIN "members" ON "users"."id" = "members"."user_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" ON ("roles"."id" = "member_roles"."role_id" OR "roles"."builtin" = 1) WHERE "users"."id" = 3 GROUP BY "roles"."id")
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.312876 #127717] DEBUG -- :   SQL (3.2ms)  SELECT "types"."id" AS t0_r0, "types"."name" AS t0_r1, "types"."position" AS t0_r2, "types"."is_in_roadmap" AS t0_r3, "types"."is_milestone" AS t0_r4, "types"."is_default" AS t0_r5, "types"."color_id" AS t0_r6, "types"."created_at" AS t0_r7, "types"."updated_at" AS t0_r8, "types"."is_standard" AS t0_r9, "types"."attribute_groups" AS t0_r10, "types"."description" AS t0_r11, "projects"."id" AS t1_r0, "projects"."name" AS t1_r1, "projects"."description" AS t1_r2, "projects"."public" AS t1_r3, "projects"."parent_id" AS t1_r4, "projects"."created_at" AS t1_r5, "projects"."updated_at" AS t1_r6, "projects"."identifier" AS t1_r7, "projects"."lft" AS t1_r8, "projects"."rgt" AS t1_r9, "projects"."active" AS t1_r10, "projects"."templated" AS t1_r11 FROM "types" LEFT OUTER JOIN "projects_types" ON "projects_types"."type_id" = "types"."id" LEFT OUTER JOIN "projects" ON "projects"."id" = "projects_types"."project_id" WHERE "projects"."id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 3 AND "projects"."active" = TRUE INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."active" = TRUE INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('add_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."active" = TRUE AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."public" = TRUE AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE "assigned_roles"."id" IS NOT NULL) ORDER BY position ASC
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.323913 #127717] DEBUG -- :   Rendered search/_mini_form.html.erb (Duration: 0.1ms | Allocations: 44)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.326282 #127717]  INFO -- :   Rendered layouts/base.html.erb (Duration: 33.3ms | Allocations: 40467)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.326330 #127717]  INFO -- :   Rendered layout layouts/angular/angular.html.erb (Duration: 34.2ms | Allocations: 41342)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.326493 #127717]  INFO -- : Completed 200 OK in 38ms (Views: 29.4ms | ActiveRecord: 6.3ms | Allocations: 43471)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.959677 #127717]  INFO -- : Started GET "/custom_style/1629440100/logo/xxxx_Logo_effizienter_wei%C3%9F_transparent_460x110.png" for 192.168.101.182 at 2021-12-15 17:57:48 +0100
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.960773 #127717]  INFO -- : Processing by CustomStylesController#logo_download as PNG
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.960798 #127717]  INFO -- :   Parameters: {"digest"=>"1629440100", "filename"=>"xxxx_Logo_effizienter_weiß_transparent_460x110.png"}
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.962278 #127717] DEBUG -- :   User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."type" NOT IN ($5, $6, $7) AND "users"."status" = $8 AND "users"."id" = $9 LIMIT $10  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["status", 1], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.962812 #127717] DEBUG -- :    (0.1ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.963392 #127717]  INFO -- : OpenProject User: Max Mustermann (Maxs ID: 3 <Mustermann@xxxx.de>)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.963949 #127717] DEBUG -- :   CustomStyle Load (0.1ms)  SELECT "custom_styles".* FROM "custom_styles" ORDER BY created_at DESC LIMIT $1  [["LIMIT", 1]]
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.964370 #127717]  INFO -- : Sent file /var/db/openproject/files/custom_style/logo/2/xxxx_Logo_effizienter_weiß_transparent_460x110.png (0.1ms)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.964449 #127717]  INFO -- : Completed 200 OK in 4ms (ActiveRecord: 0.6ms | Allocations: 1868)
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:48.997003 #127717]  INFO -- : Started GET "/api/v3/capabilities?pageSize=1000&filters=%5B%7B%22principal%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%223%22%5D%7D%7D%5D" for 192.168.101.182 at 2021-12-15 17:57:48 +0100
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:48.999019 #127721]  INFO -- : Started GET "/api/v3/configuration" for 192.168.101.182 at 2021-12-15 17:57:48 +0100
Dez 15 17:57:48 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.999453 #127717] DEBUG -- :    (0.1ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:48.999985 #127717] DEBUG -- :   User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."id" = $5 LIMIT $6  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.002075 #127721] DEBUG -- :    (0.2ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.002673 #127721] DEBUG -- :   User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."id" = $5 LIMIT $6  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:49.005339 #127717] DEBUG -- :   SQL (0.9ms)  SELECT "roles"."id" AS t0_r0, "roles"."name" AS t0_r1, "roles"."position" AS t0_r2, "roles"."assignable" AS t0_r3, "roles"."builtin" AS t0_r4, "roles"."type" AS t0_r5, "roles"."created_at" AS t0_r6, "roles"."updated_at" AS t0_r7, "role_permissions"."id" AS t1_r0, "role_permissions"."permission" AS t1_r1, "role_permissions"."role_id" AS t1_r2, "role_permissions"."created_at" AS t1_r3, "role_permissions"."updated_at" AS t1_r4 FROM "roles" LEFT OUTER JOIN "role_permissions" ON "role_permissions"."role_id" = "roles"."id" WHERE "roles"."id" IN (SELECT "roles"."id" FROM "users" LEFT OUTER JOIN "members" ON "users"."id" = "members"."user_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" ON ("roles"."id" = "member_roles"."role_id" OR "roles"."builtin" = 1) WHERE "users"."id" = 3 GROUP BY "roles"."id")
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.005901 #127721] DEBUG -- :   UserPreference Load (0.4ms)  SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2  [["user_id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.010486 #127721] DEBUG -- :   CACHE User Load (0.0ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."id" = $5 LIMIT $6  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.014784 #127721] DEBUG -- :   NotificationSetting Load (0.6ms)  SELECT "notification_settings".* FROM "notification_settings" WHERE "notification_settings"."user_id" = $1  [["user_id", 3]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.026725 #127721]  INFO -- : duration=25.70 db=6.92 view=18.78 status=200 method=GET path=/api/v3/configuration params={} host=ops.xxxx.de user=3
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.028817 #127721]  INFO -- : Started GET "/api/v3/users/3/avatar" for 192.168.101.182 at 2021-12-15 17:57:49 +0100
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.031050 #127721] DEBUG -- :    (0.2ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.031792 #127721] DEBUG -- :   User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."id" = $5 LIMIT $6  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.033072 #127721] DEBUG -- :   User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND ("users"."id" = $5 OR "users"."login" = $6)  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["login", "3"]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.034638 #127721] DEBUG -- :   Attachment Load (0.5ms)  SELECT "attachments"."id", "attachments"."container_id", "attachments"."container_type", "attachments"."filename", "attachments"."disk_filename", "attachments"."filesize", "attachments"."content_type", "attachments"."digest", "attachments"."downloads", "attachments"."author_id", "attachments"."created_at", "attachments"."description", "attachments"."file", "attachments"."updated_at" FROM "attachments" WHERE "attachments"."container_id" = $1 AND "attachments"."container_type" = $2 AND "attachments"."description" = $3 ORDER BY attachments.created_at LIMIT $4  [["container_id", 3], ["container_type", "Principal"], ["description", "avatar"], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.035301 #127721]  INFO -- : duration=5.27 db=1.47 view=3.80 status=200 method=GET path=/api/v3/users/3/avatar params={} host=ops.xxxx.de user=3
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: D, [2021-12-15T17:57:49.046283 #127717] DEBUG -- :    (15.5ms)  WITH all_elements AS (
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   SELECT DISTINCT capabilities.*, contexts.name context_name, "principals"."firstname", "principals"."lastname", "principals"."login", "principals"."mail", principals.type principal_type FROM (
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   SELECT DISTINCT
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   actions.id "action",
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   users.id principal_id,
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   projects.id context_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: FROM (SELECT actions.* FROM (SELECT id, permission, global, module FROM (VALUES ('projects/create', 'add_project', true, NULL), ('users/create', 'manage_user', true, NULL), ('users/read', 'manage_user', true, NULL), ('users/update', 'manage_user', true, NULL), ('placeholder_users/create', 'manage_placeholder_user', true, NULL), ('placeholder_users/read', 'manage_placeholder_user', true, NULL), ('placeholder_users/update', 'manage_placeholder_user', true, NULL), ('projects/update', 'edit_project', false, NULL), ('memberships/create', 'manage_members', false, NULL), ('memberships/update', 'manage_members', false, NULL), ('memberships/destroy', 'manage_members', false, NULL), ('memberships/read', 'view_members', false, NULL), ('projects/copy', 'copy_projects', false, NULL), ('work_packages/read', 'view_work_packages', false, 'work_package_tracking'), ('ifc_models/read', 'view_ifc_models', false, 'bim'), ('ifc_models/create', 'manage_ifc_models', false, 'bim'), ('ifc_models/update', 'manage_ifc_models', false, 'bim'), ('ifc_models/destroy', 'manage_ifc_models', false, 'bim'), ('bcfs/read', 'view_linked_issues', false, 'bim'), ('bcfs/create', 'manage_bcf', false, 'bim'), ('bcfs/update', 'manage_bcf', false, 'bim'), ('bcfs/destroy', 'delete_bcf', false, 'bim')) AS t(id, permission, global, module)) actions
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ) actions
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN "role_permissions" ON "role_permissions"."permission" = "actions"."permission"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN "roles" ON "roles".id = "role_permissions".role_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN "member_roles" ON "member_roles".role_id = "roles".id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN "members" ON members.id = member_roles.member_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: JOIN (SELECT "users".* FROM "users" WHERE "users"."type" NOT IN ('SystemUser', 'AnonymousUser', 'DeletedUser') AND "users"."type" NOT IN ('SystemUser', 'AnonymousUser', 'DeletedUser') AND "users"."status" != 3) users
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON "users".id = members.user_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN "projects"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON "projects".id = members.project_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN enabled_modules
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:    ON enabled_modules.project_id = projects.id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:    AND actions.module = enabled_modules.name
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHERE (projects.active AND (enabled_modules.project_id IS NOT NULL OR "actions".module IS NULL))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: OR (projects.id IS NULL AND "actions".global)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   UNION
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   SELECT DISTINCT
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   actions.id "action",
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   users.id principal_id,
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   projects.id context_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: FROM (SELECT actions.* FROM (SELECT id, permission, global, module FROM (VALUES ('projects/create', 'add_project', true, NULL), ('users/create', 'manage_user', true, NULL), ('users/read', 'manage_user', true, NULL), ('users/update', 'manage_user', true, NULL), ('placeholder_users/create', 'manage_placeholder_user', true, NULL), ('placeholder_users/read', 'manage_placeholder_user', true, NULL), ('placeholder_users/update', 'manage_placeholder_user', true, NULL), ('projects/update', 'edit_project', false, NULL), ('memberships/create', 'manage_members', false, NULL), ('memberships/update', 'manage_members', false, NULL), ('memberships/destroy', 'manage_members', false, NULL), ('memberships/read', 'view_members', false, NULL), ('projects/copy', 'copy_projects', false, NULL), ('work_packages/read', 'view_work_packages', false, 'work_package_tracking'), ('ifc_models/read', 'view_ifc_models', false, 'bim'), ('ifc_models/create', 'manage_ifc_models', false, 'bim'), ('ifc_models/update', 'manage_ifc_models', false, 'bim'), ('ifc_models/destroy', 'manage_ifc_models', false, 'bim'), ('bcfs/read', 'view_linked_issues', false, 'bim'), ('bcfs/create', 'manage_bcf', false, 'bim'), ('bcfs/update', 'manage_bcf', false, 'bim'), ('bcfs/destroy', 'delete_bcf', false, 'bim')) AS t(id, permission, global, module)) actions
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ) actions
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: JOIN "role_permissions" ON "role_permissions"."permission" = "actions"."permission"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: JOIN "roles" ON "roles".id = "role_permissions".role_id AND roles.builtin = 1
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: JOIN (SELECT "users".* FROM "users" WHERE "users"."type" NOT IN ('SystemUser', 'AnonymousUser', 'DeletedUser') AND "users"."type" NOT IN ('SystemUser', 'AnonymousUser', 'DeletedUser') AND "users"."status" != 3) users
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON 1 = 1
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: JOIN "projects"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON "projects".active = true
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   AND ("projects".public = true OR EXISTS (SELECT 1
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                                            FROM members
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                                            WHERE members.project_id = projects.id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                                            AND members.user_id = users.id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                                            LIMIT 1))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN enabled_modules
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON enabled_modules.project_id = projects.id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   AND actions.module = enabled_modules.name
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHERE enabled_modules.project_id IS NOT NULL OR "actions".module IS NULL
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   UNION
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   SELECT DISTINCT
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   actions.id "action",
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   users.id principal_id,
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   projects.id context_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: FROM (SELECT actions.* FROM (SELECT id, permission, global, module FROM (VALUES ('projects/create', 'add_project', true, NULL), ('users/create', 'manage_user', true, NULL), ('users/read', 'manage_user', true, NULL), ('users/update', 'manage_user', true, NULL), ('placeholder_users/create', 'manage_placeholder_user', true, NULL), ('placeholder_users/read', 'manage_placeholder_user', true, NULL), ('placeholder_users/update', 'manage_placeholder_user', true, NULL), ('projects/update', 'edit_project', false, NULL), ('memberships/create', 'manage_members', false, NULL), ('memberships/update', 'manage_members', false, NULL), ('memberships/destroy', 'manage_members', false, NULL), ('memberships/read', 'view_members', false, NULL), ('projects/copy', 'copy_projects', false, NULL), ('work_packages/read', 'view_work_packages', false, 'work_package_tracking'), ('ifc_models/read', 'view_ifc_models', false, 'bim'), ('ifc_models/create', 'manage_ifc_models', false, 'bim'), ('ifc_models/update', 'manage_ifc_models', false, 'bim'), ('ifc_models/destroy', 'manage_ifc_models', false, 'bim'), ('bcfs/read', 'view_linked_issues', false, 'bim'), ('bcfs/create', 'manage_bcf', false, 'bim'), ('bcfs/update', 'manage_bcf', false, 'bim'), ('bcfs/destroy', 'delete_bcf', false, 'bim')) AS t(id, permission, global, module)) actions
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ) actions
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: JOIN (SELECT "users".* FROM "users" WHERE "users"."type" NOT IN ('SystemUser', 'AnonymousUser', 'DeletedUser') AND "users"."type" NOT IN ('SystemUser', 'AnonymousUser', 'DeletedUser') AND "users"."status" != 3) users
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON "users".admin = true
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN "projects"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON "projects".active = true
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   AND NOT "actions".global
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: LEFT OUTER JOIN enabled_modules
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   ON enabled_modules.project_id = projects.id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   AND actions.module = enabled_modules.name
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHERE (projects.id IS NOT NULL AND (enabled_modules.project_id IS NOT NULL OR "actions".module IS NULL)) OR "actions".global
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ) capabilities
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:  LEFT OUTER JOIN projects contexts ON contexts.id = capabilities.context_id LEFT OUTER JOIN users principals ON principals.id = capabilities.principal_id WHERE (capabilities.principal_id IN ('3')) ORDER BY action ASC, principal_id ASC, capabilities.context_id ASC
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: )
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: , page_elements AS (
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   SELECT * FROM all_elements LIMIT 1000 OFFSET 0
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: )
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: , total AS (
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   SELECT COUNT(*) from all_elements
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: )
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: SELECT
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   json_strip_nulls(json_build_object(
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   '_type', 'Collection', 'count', COUNT(*), 'total', (SELECT * from total), 'pageSize', 1000, 'offset', 1, '_links', json_strip_nulls(json_build_object(
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                    'self', json_build_object('href', '/api/v3/capabilities?filters=%5B%7B%22principal%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%223%22%5D%7D%7D%5D&offset=1&pageSize=1000')
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'jumpTo', json_build_object('href', '/api/v3/capabilities?filters=%5B%7B%22principal%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%223%22%5D%7D%7D%5D&offset=%7Boffset%7D&pageSize=1000', 'templated', true)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'changeSize', json_build_object('href', '/api/v3/capabilities?filters=%5B%7B%22principal%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%223%22%5D%7D%7D%5D&offset=1&pageSize=%7Bsize%7D', 'templated', true)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'previousByOffset',
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  CASE WHEN false THEN
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                    json_build_object('href', '/api/v3/capabilities?filters=%5B%7B%22principal%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%223%22%5D%7D%7D%5D&offset=0&pageSize=1000')
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  ELSE
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                    NULL
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'nextByOffset',
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  CASE WHEN 1000 < (SELECT * FROM total) THEN
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                    json_build_object('href', '/api/v3/capabilities?filters=%5B%7B%22principal%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%223%22%5D%7D%7D%5D&offset=2&pageSize=1000')
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  ELSE
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                    NULL
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: , '_embedded', json_strip_nulls(json_build_object(
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                  'elements', json_agg(json_strip_nulls(json_build_object(
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   '_type', 'Capability', 'id', CASE
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN context_id IS NULL THEN action || '/g-' || principal_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ELSE action || '/p' || context_id || '-' || principal_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: , '_links', json_strip_nulls(json_build_object(
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:                    'self', json_build_object('href', format('/api/v3/capabilities/%s', CASE
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN context_id IS NULL THEN action || '/g-' || principal_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ELSE action || '/p' || context_id || '-' || principal_id
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'action', json_build_object('href', format('/api/v3/actions/%s', action))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'context', json_build_object('href', CASE
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN context_id IS NULL THEN '/api/v3/capabilities/contexts/global'
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ELSE format('/api/v3/projects/%s', context_id)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: , 'title', CASE
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN context_id IS NULL THEN 'Global'
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ELSE context_name
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: )
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ,                  'principal', json_build_object('href', CASE principal_type
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN 'Group' THEN format('/api/v3/groups/%s', principal_id)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN 'PlaceholderUser' THEN format('/api/v3/placeholder_users/%s', principal_id)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ELSE format('/api/v3/users/%s', principal_id)
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: , 'title', CASE principal_type
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN 'Group' THEN lastname
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: WHEN 'PlaceholderUser' THEN lastname
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ELSE firstname || ' ' || lastname
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: END
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: )
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: )
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: ))
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:  AS json
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: FROM
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]:   page_elements
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: 
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127717]: I, [2021-12-15T17:57:49.046544 #127717]  INFO -- : duration=47.93 db=17.72 view=30.21 status=200 method=GET path=/api/v3/capabilities params={"pageSize"=>"1000", "filters"=>"[{\"principal\":{\"operator\":\"=\",\"values\":[\"3\"]}}]"} host=ops.xxxx.de user=3
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.096315 #127721]  INFO -- : Started GET "/api/v3/notifications?pageSize=0&filters=%5B%7B%22readIAN%22%3A%7B%22operator%22%3A%22%3D%22%2C%22values%22%3A%5B%22f%22%5D%7D%7D%5D" for 192.168.101.182 at 2021-12-15 17:57:49 +0100
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.098044 #127721] DEBUG -- :    (0.1ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.098617 #127721] DEBUG -- :   User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."id" = $5 LIMIT $6  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.102622 #127721] DEBUG -- :   Notification Load (1.2ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."resource_type" = $1 AND "notifications"."resource_id" IN (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 3 AND "projects"."active" = TRUE INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."active" = TRUE INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."active" = TRUE AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."public" = TRUE AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE "assigned_roles"."id" IS NOT NULL)) AND "notifications"."read_ian" IS NOT NULL AND "notifications"."recipient_id" = $2 AND (notifications.read_ian IN ('f')) ORDER BY "notifications"."id" DESC LIMIT $3 OFFSET $4  [["resource_type", "WorkPackage"], ["recipient_id", 3], ["LIMIT", 0], ["OFFSET", 0]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.103989 #127721] DEBUG -- :    (0.9ms)  SELECT COUNT(*) FROM "notifications" WHERE "notifications"."resource_type" = $1 AND "notifications"."resource_id" IN (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 3 AND "projects"."active" = TRUE INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."active" = TRUE INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."active" = TRUE AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."public" = TRUE AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE "assigned_roles"."id" IS NOT NULL)) AND "notifications"."read_ian" IS NOT NULL AND "notifications"."recipient_id" = $2 AND (notifications.read_ian IN ('f'))  [["resource_type", "WorkPackage"], ["recipient_id", 3]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.105696 #127721] DEBUG -- :    (1.0ms)  SELECT COUNT(DISTINCT "notifications"."id") FROM "notifications" LEFT OUTER JOIN "projects" ON "projects"."id" = "notifications"."project_id" LEFT OUTER JOIN "users" ON "users"."id" = "notifications"."actor_id" AND "users"."type" IN ($1, $2, $3, $4) WHERE "notifications"."resource_type" = $5 AND "notifications"."resource_id" IN (SELECT "work_packages"."id" FROM "work_packages" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 3 AND "projects"."active" = TRUE INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."active" = TRUE INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."active" = TRUE AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."public" = TRUE AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE "assigned_roles"."id" IS NOT NULL)) AND "notifications"."read_ian" IS NOT NULL AND "notifications"."recipient_id" = $6 AND (notifications.read_ian IN ('f'))  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["resource_type", "WorkPackage"], ["recipient_id", 3]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.106188 #127721]  INFO -- : duration=9.08 db=3.87 view=5.21 status=200 method=GET path=/api/v3/notifications params={"pageSize"=>"0", "filters"=>"[{\"readIAN\":{\"operator\":\"=\",\"values\":[\"f\"]}}]"} host=ops.xxxx.de user=3
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.189713 #127721]  INFO -- : Started GET "/api/v3/spec.json" for 192.168.101.182 at 2021-12-15 17:57:49 +0100
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.191434 #127721] DEBUG -- :    (0.1ms)  SELECT MAX("settings"."updated_at") FROM "settings"
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.192009 #127721] DEBUG -- :   User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."type" IN ($1, $2, $3, $4) AND "users"."id" = $5 LIMIT $6  [["type", "User"], ["type", "SystemUser"], ["type", "AnonymousUser"], ["type", "DeletedUser"], ["id", 3], ["LIMIT", 1]]
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: E, [2021-12-15T17:57:49.192972 #127721] ERROR -- : user=3 Could not find openapi-spec.yml under /opt/openproject/docs/api/apiv3/openapi-spec.yml: Could not find openapi-spec.yml under /opt/openproject/docs/api/apiv3/openapi-spec.yml
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: D, [2021-12-15T17:57:49.192997 #127721] DEBUG -- : [RuntimeError] Could not find openapi-spec.yml under /opt/openproject/docs/api/apiv3/openapi-spec.yml: lib/api/open_api.rb:12:in `spec'; lib/api/v3/root.rb:85:in `block in <class:Root>'
Dez 15 17:57:49 openprojectserver openproject-web-1.service[127721]: I, [2021-12-15T17:57:49.193227 #127721]  INFO -- : duration=2.57 db=0.48 view=2.09 status=500 method=GET path=/api/v3/spec.json params={} host=ops.xxxx.de user=3
```

### **Steps to reproduce:**

1.  Go to page `api/docs`

### **Actual Behavior**

<figure class="image op-uc-figure"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/24552/content"></div></figure>

###