Resource deletion

The characters to be used when creating resources are limited, see Allowed characters and Internationalization. The same limitation applies to the deletion of resources. In the past, the creation of resources was less restrictive. When trying to delete these old resources, an error occurs.

Execute the following SQL statement on your database to identify such invalid resources. It may be necessary to modify [master-data-database] in the statement.

SELECT [IAM_APP02_RESOURCE].[RESOURCE_ID] AS ResourceID,
    [IAM_APP02_RESOURCE].[TYPE] AS ResourceType,
    [IAM_APP02_RESOURCE].[NAME] AS ResourceName,
    [IAM_ORG01_TENANT].[NAME] AS TenantName,
    [IAM_ORG01_TENANT].[ID] AS TenantID
FROM [master-data-database].[dbo].[IAM_APP02_RESOURCE]
    LEFT JOIN [master-data-database].[dbo].[IAM_ORG01_TENANT]
        ON [IAM_APP02_RESOURCE].[ORG01_ID_OWNER] = [IAM_ORG01_TENANT].[ID]
WHERE [IAM_APP02_RESOURCE].[RESOURCE_ID] LIKE '%[^A-Za-z0-9()+,-.:=@;$_!*''%/?#]%'
    OR LEN([IAM_APP02_RESOURCE].[RESOURCE_ID]) > 255
    OR [IAM_APP02_RESOURCE].[TYPE] LIKE '%[^A-Za-z0-9()+,-.:=@;$_!*''%/?#]%'
    OR LEN([IAM_APP02_RESOURCE].[TYPE]) > 255;

Contact the support with the invalid resources for further steps.