Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/23/2024 04:58 AM - edited 04/23/2024 04:58 AM
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.
04/23/2024 05:44 AM
04/29/2024 06:49 AM - last edited on 04/30/2024 08:08 AM by Sunil
@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]
04/29/2024 08:20 PM
Adding triple quotes should be managed in stored procedure
04/30/2024 05:06 AM
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.
04/30/2024 08:54 PM
{
"CreateAccountQry": "EXEC [SVNT_LMS].[sp_UserCustomAccess_Insert] '${user.username}','${Country_Name}','${Org_Name}','${Group_Name}','${Tag_Name}';"
}
05/01/2024 08:45 AM - last edited on 05/01/2024 11:53 PM by Sunil
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.
05/01/2024 07:54 PM
Which DA is causing issue ?
05/02/2024 08:47 AM
@rushikeshvartak country name (Country_Name) was causing the issue.
05/02/2024 08:25 PM
Does stored Procedure accepts comma separated Country_Name