Problem statement
We are unable to delete a field in the app_metadata section in one of our connections DB. We get a successful message, but it is not really deleted.
Cause
The tenant has users with identical user_id.
Solution
The user_id field should be considered ‘unique’ per tenant. This can be circumvented with a Custom Database connection, which allows the flexibility to import user_id from an external system without constraint. However, this causes problems for many API endpoints calling user_id, which includes the metadata delete action.
Removing duplicate user_id fields will allow the normal operation of all APIs to be restored.