Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

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

vnambrath
New Contributor
New Contributor

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?

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

vnambrath
New Contributor
New Contributor

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

 

Any provisioning comments under remove task in pending tasks section 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Provisioning comments: 

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