Migration Tool error during export data process

News Knowledge Base
1

How to solve the Duende.IdentityServer.Validation.ClientSecretValidator Client secret validation failed for client: xxxxxx when using migration tool?

Error Details:

The error indicates that the Client Secret provided in the Orchestrator configuration does not match the hashed value stored in the database. This discrepancy prevents successful client secret validation.

Resolution:

Verify and update the Client Secret in the database to match the one configured in orchestrator.dll.config.

Follow these steps:

  1. Retrieve the Hashed Value:
    1. Perform the following SQL query to retrieve the hashed value of the Client Secret:

DECLARE @secret varchar(MAX) = 'your_actual_client_secret'; SELECT HASHBYTES('SHA2_256', @secret) AS 'HashedSecret' FOR XML PATH('');

  1. Replace 'your_actual_client_secret' with the Client Secret value configured in Orchestrator.dll.config.

  1. Update the Database ( Take a backup of your database before making any changes):
    1. Compare the retrieved hashed value with the one stored in the database
    2. If they do not match, update the database entry to reflect the correct hashed value.

  1. Restart the migration tool.