Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/19/2023 05:39 AM
Hi team,
I have created one dynamic attribute with type multi select from SQL Query for custom user form.
while creating user i have selected few values in DA .
But in user update form I remove all values for the DA and submitted the request
No request ID generated.
What can be the reason for this?
It is working as expected when we keep at least on value in DA.
Any help would be appreciated.
10/20/2023 12:49 AM
10/20/2023 12:51 AM
@Dhruv_S I have used dataset for this
select distinct attribute1 as ID from dataset_values where dataset_values.datasetname ='AD Groups'
10/20/2023 01:42 AM - edited 10/20/2023 01:44 AM
Replicated the scenario with below queries. I got the same error firs time when there was one value and then removed it and submitted the request. However next time it worked.
Test Query in multi select dynamic attribute
select distinct city as ID from users where country in ('US', 'India', 'China')
Test case 1: User created with one value in dynamic attribute. Removed the value during modification. Kept no values in selection. Got same error.
Test case 2: User created with three values in dynamic attribute. Removed one value during modification. Worked successfully.
Test case 3: User existing with two values in dynamic attribute. Removed both values during modification. Worked successfully.
There is no bug/misconfiguration, but it intermittently gives error if submitted immediately. As per my analysis, it expects some time before submitting post emptying the values from DA.
Please try again multiple times to validate if you get an error.
Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.
10/25/2023 02:27 AM
@Dhruv_S i have tried multiple times still getting the same, no request created.
Working as expected when I keep atleast one value.
@rushikeshvartak No error in the logs
10/20/2023 04:46 AM
Do you see any error in logs
10/25/2023 02:51 AM
I tried twice without any values, and it gave the same error in 1st attempt and worked fine in 2nd attempt. The version I had tried tested it was V23.10. Is it possible for you to test in another version? Also please check if you get any error in logs. Else I would recommend you raise a support ticket.
Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.
10/25/2023 02:55 AM
@Dhruv_S I have only one version i.e V23.7.
I will raise support ticket.
10/25/2023 04:24 AM
@Dhruv_S I have raised support ticket.