We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Disable task failing in Databse connection

rajeshg
New Contributor
New Contributor

Hi All,

We have integrated the DB connection with create. modify and disable JOSNS. While executing the Disable account task we are passing the accountID value and task is failing with below error.

Error while disabling account - abc\MRM1278 -Exception occured while Excecuting Query Error while disabling account - abc\MRM1278 -No such property: accountId for class: java.lang.String Error while disabling account - abc\MRM1278 -No such property: accountId for class: java.lang.String Error while disabling account - abc\MRM1278 -No such property: accountID for class: java.lang.String Error while disabling account - abc\MRM1278 -Exception occured while Excecuting Query Error while disabling account - abc\MRM1278 -No such property: accountID for class: java.lang.String Error while disabling account - abc\MRM1278 -Exception occured while Excecuting Query Error while disabling account - abc\MRM1278 -Exception occured while Excecuting Query Error while disabling account - abc\MRM1278 -Exception occured while Excecuting Query Error while disabling account - abc\MRM1278 -Exception occured while Excecuting Query

e have tried with all possible account ID tasks like account.accountId, accounts.accountId, accounts.AccountID, task.accountName,accountname

Still we are facing the same issue to pass the accountID during disable account task. Appreciate if someone provide details if anyone passed the accountID

Regards,
Rajesh

 

8 REPLIES 8

SumathiSomala
All-Star
All-Star

{
"disableaccountqry" : "update users set enabled = 0 where userkey = ${user.id}"
}

Configuring the Integration for Provisioning and Deprovisioning (saviyntcloud.com)

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

rajeshg
New Contributor
New Contributor

Hi Sumati,

Thanks for response. The syntax is a reference and not suitable for DB call and stored procedures. Here I'm using below sample and accountID is unique to set employeenumber as 0.

EXEC TEST.DBO.SP _Update employeenumber=0, AccountId='${accounts.accountID}'

I tried with all related acocuntID to pass but same error.

Regards,
Rajesh

@rajeshg  did you try below

account.accountID

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

@SumathiSomala 

We tried and same error and refer below

Exception occured while Excecuting Query Error while disabling account - abc\NEW1279 -No such property: accountID for class: java.lang.String

{"DisableAccountQry":"EXEC TEST.DBO.SP _Update employeenumber=0, AccountId= ${account.accountID.replace('\\','\\\\')} "}


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

rajeshg
New Contributor
New Contributor

Hi Rushikesh,

Thanks for response. here accountID is number and we tried the same without replace. getting below error. its showing that there is a no such property accountID.

rajeshg_0-1702495697652.png

 

Error while disabling account - abc\test1284 -No such property: accountID for class: java.lang.String

 

{
"disableaccountqry" :"EXEC TEST.DBO.SP _Update employeenumber=0, AccountId= ${task.accountKey.accountID}"
}


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

rajeshg
New Contributor
New Contributor

@rushikeshvartak 

Tried with the given solution and refer below error

Error while disabling account - abc\test1284 -Exception occurred while Executing Query

Regards,
Rajesh