Migrate KeyCloak to Auth0 error with Password Change Required message

Help
,
1

With reference to this post Migrate Keycloak user to Auth0 problems

I have managed to import users from KeyCloak to Auth0. However, upon login, it said “Password change required”. When checking on Auth0 Logs, the reason is "Verification failed for the provided custom_password_hash.

Can you please help? Thanks!

Script to export from KeyCloak:

select FIRST_NAME, LAST_NAME, EMAIL, USERNAME, EMAIL_VERIFIED, U.ID as ID,
REPLACE(json_extract(SECRET_DATA,'$.value'),'\"','') as PASSWORDHASH,
TO_BASE64(REPLACE(json_extract(SECRET_DATA, '$.salt'),'\"','')) AS B64SALT,
json_extract(CREDENTIAL_DATA, '$.hashIterations') as HASHITERATIONS,
json_extract(CREDENTIAL_DATA, '$.algorithm') as ALGORITHM,
CREATED_TIMESTAMP, REALM_ID
from USER_ENTITY U, CREDENTIAL C
where U.ID = C.USER_ID

Sample json for importing:

[
{
    "email": "user@email.com",
    "email_verified":  true,
    "name": "Full Name",
    "given_name": "First",
    "family_name": "Last",
    "custom_password_hash": {
      "algorithm": "pbkdf2",
      "hash": {
         "value":  "$pbkdf2-sha256$i=27500,l=32$B64SALT$PASSWORDHASH",
	 "encoding": "utf8"
      }
    }  
}
]