Remove account task is not moving to completed tasks for MSSQL DB connector

[vnambrath]

We are facing an issue with Remove account task. We have created DB connector for MSSQL DB and used the JSON for Delete account

{
"DeleteAccountQry" : [ "USE testdb","DROP USER [${accountName}]","DROP LOGIN [${accountName}]" ]
}

we have also tried with the below JSON

{
"DeleteAccountQry" : [ DROP LOGIN [${accountName}]" ]
}

it is deleting the login and user in the target DB but task in Saviynt is not moving to complete phase. 

It shows provisioning comment as "Error while delete account - sphxs220 -sphxs220-Exception occured while Excecuting Query"

Please let us know if  similar issue has been faced and any solutions found?

[rushikeshvartak]

Please add semicolon after the each query & share logs if not resolved

[vnambrath]

Updated the query as below:

{
"DeleteAccountQry" : [ "USE testdb;","DROP USER [${accountName}];","DROP LOGIN ${accountName};" ]
}

Result:

Remove access task got completed

Remove account task is in Pending task

Provisioning Comments: Error while delete account - spAKS507 -spAKS507-Exception occured while Excecuting Query

Attached the logs

[rushikeshvartak]

Any provisioning comments under remove task in pending tasks section 

[vnambrath]

Provisioning comments: 

Error while delete account - sptestuser15 -sptestuser15-Exception occured while Excecuting Query