The new account request is not allowed because the user already has an account

[Thriller]

I am getting the above error when trying to request for an account in the target application which is a disconnectedapplication. The status of the account 'PRAJEN2' is 'Manually Suspended' and since we have the account name rule set for unique accounts inside the endpoint, I changed the account name using Enhanced Query Execution to include the word '-Deleted' but I am still getting the same error. What can be done to fix this? Thank you for taking a look

[rushikeshvartak]

change account status to SUSPENDED FROM IMPORT SERVICE

[Thriller]

I changed the status to SUSPENDED FROM IMPORT SERVICE, but I am still getting the same error

[rushikeshvartak · Accepted solution]

Disable below option as shown below

[Thriller]

We have a usecase to leave this button ON. Is there a way to write a custom query at endpoint level or elsewhere that would allow creation of new accounts when they are in 'Manually Suspended' or 'Suspended from Import Service' status

[rushikeshvartak]

Use enhanced query 

SELECT accountkey as accounts__primarykey,
CONCAT(name, ' -Deleted on ', timestamp) AS accounts__name,
'SUSPENDED FROM IMPORT SERVICE' As accounts__status
FROM
accounts
WHERE
status = 'Manually Suspended' AND
Endpointkey = '1';

change endpointkey as per need

[Thriller]

Thank you for your help

[rushikeshvartak]

Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.

[Mareetta]

I'm facing the same issue. Status and name is updated properly from import as *deleted* and suspended from import. Also have the endpoint config "Disable New Account Request if Account Already Exists" ON. But when user goes to request again, gets error. Any suggestions?

[rushikeshvartak]

Remove mapping from user to account from User -- Account - Remove Mapping

[Mareetta]

without removing the user from account it should work correct?