Issue with UPDATEUSERJSON in DB Connection

[Pavan16]

Hi Everyone,

I am trying to write few attributes back to my DB, but facing an error while running the provisioning job I have provided my connection details below. and I am getting below error, please check and help me with resolving the error as I am not able to find this ')' in my connection.

UPDATEUSERJSON:{
"UpdateUserQry": ["CALL testproc( ) ",
"UPDATE dbo.test SET lan_id=${user.customproperty10}, email=${user.email}, companyname=${user.companyname} WHERE emi_id=${user.employeeid}"]
}

MODIFYUSERDATAJSON:

{
"ADDITIONALTABLES": {
"USERS": "SELECT * FROM USERS"
},
"COMPUTEDCOLUMNS": [
"email", "customproperty10"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET email = concat(substring(NEWUSERDATA.lastname,1,1),NEWUSERDATA.firstname,'@gmail.com')",
"UPDATE NEWUSERDATA SET customproperty10 = concat(substring(NEWUSERDATA.lastname,1,1),'XS',NEWUSERDATA.employeeid)"

]
}

Error:
SAV - Error while updating user - Incorrect syntax near ')'.

[rushikeshvartak]

Is it working from database ?

[Pavan16]

Yes, I am able to import users from database. 

[rushikeshvartak]

What is issue  ? Provisioning ? 

Share task screenshot /logs?

[Pavan16]

Yes, I am trying to update user details in my DB from update user task with few attributes from Saviynt.

[Pavan16 · Accepted solution]

Able to solve the problem by removing the CALL TestProc(), now I can write back to DB.