Error while calling stored procedure for create account JSON in DB connection

[Rajesh_IAM]

Hello,

I am calling stored procedure with parameters in create account JSON and am passing all the values, but still I am getting syntax error. 

Create account JSON:

{
"CreateAccountQry": [
"EXEC [SVNT_LMS].[sp_UserCustomAccess_Insert]('${user.username}','${Country_Name}','${Org_Name}','${Group_Name}','${Tag_Name}')"
]
}
Here country name,org name,group name and tag name are dynamic attribute values.
Error: 

Please review and help me how to resolve this error.

[rushikeshvartak]

• Does stored procedure works directly on database 
• Does hardcoded values works from saviynt

[Rajesh_IAM]

@rushikeshvartak  Yes, stored procedure worked directly on database and also hardcoded values worked from saviynt.

{
"CreateAccountQry": [
"EXEC [SVNT_LMS].[sp_UserCustomAccess_Insert] '22253183','''Canada'',''India'',''United States''','''REMOVED_Energy-PGCO-2813'',''PG-PGGA-PGGASCM''','''AG-PG-Master-Admin'',''AG-HR-Master-Admin''','''''';"
]

Note:  If you are inserting NULL values for Custom attributes then use '''''' (triple quotes). If Groups value selected then Tags should be NULL, similarly if Tags value selected then Groups should be NULL.

[This message has been edited by moderator to mask sensitive information]

[rushikeshvartak]

Adding triple quotes should be managed in stored procedure

[Rajesh_IAM]

Hi @rushikeshvartak  I have tried with below create account JSON, but getting error while executing task.
{
"CreateAccountQry": [
"EXEC [SVNT_LMS].[sp_UserCustomAccess_Insert] '${user.username}','${Country_Name}','${Org_Name}','${Group_Name}','${Tag_Name}';"
]
}
Attached error logs for reference.

[rushikeshvartak]

{
"CreateAccountQry": "EXEC [SVNT_LMS].[sp_UserCustomAccess_Insert] '${user.username}','${Country_Name}','${Org_Name}','${Group_Name}','${Tag_Name}';"
}

[Rajesh_IAM]

Hi @rushikeshvartak  Still getting error even I used above mentioned create account JSON.
below is the user request form (ARS request) along with error logs.

Attached error logs.

[rushikeshvartak]

Which DA is causing issue ?

[Rajesh_IAM]

@rushikeshvartak  country name (Country_Name) was causing the issue.

[rushikeshvartak]

Does stored Procedure accepts comma separated Country_Name