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

[Thushani-Jayasekera]

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