[Bug]: Key Manager deletion is blocked when linked to applications by adding client ID

Please select the area the issue is related to

Developer Portal

Please select the aspect the issue is related to

Aspect/API (API backends, definitions, contracts, interfaces, OpenAPI)

Description

The warning message when trying to delete key manager indicates that you can delete while the KM is linked to applications. (warning that those will also get deleted in the process).
However, this action gets blocked

api-portal-1    | [2026-08-05 16:38:22][error][task_queues:270] Error deleting key manager {"error":{"code":"SQLITE_CONSTRAINT_FOREIGNKEY"}}
api-portal-1    | [2026-08-05 16:38:22][error][task_queues:277] Error while deleting key manager {"error":{"code":"SQLITE_CONSTRAINT_FOREIGNKEY"}}

either we should fix to delete the client id links or fix the warning message.

Steps to Reproduce

as above

Severity Level of the Issue

Severity/Major (Important functionality is broken. Should be prioritized. Doesn't need immediate attention)

Environment Details (with versions)

API Portal 1.0.0 RC3 pack

Start by reproducing key manager deletion in the API Portal using the SQLite setup and trace the deletion entry point through the client ID link handling. Confirm whether linked application records are removed or the warning is corrected, then verify that the chosen behavior completes without a SQLITE_CONSTRAINT_FOREIGNKEY error.