Click HERE to see how Saviynt Intelligence is transforming the industry. |
01/25/2024 03:41 AM
Hi,
We have created customized user creation form with 3 user types.
Username should be 7 digit number starting from the given series. For example - 0012345 and it should be auto incremented.
Getting "Username already exists and its pending for approval" error while submitting another request when there are requests pending for approval. If there's no request pending then it's working fine.
We are using below advance config for username generation rule.
SELECT LPAD((CAST((CAST(username AS UNSIGNED) +1) AS CHAR)),7,'0') as Id FROM users ORDER BY CAST(username AS UNSIGNED) DESC LIMIT 1
There are few username starting with letters, that's why using CAST in above query. Using hide/show for attributes according to selected user type.
Approval workflow is implemented based on department attribute. It will get auto approved or go for the approval.
Our understanding is username gets generated once we approve the request. Not sure why we are getting error while submitting the user creation request.
Please help us to resolve this issue.
Solved! Go to Solution.
01/25/2024 07:33 PM
Can you share logs
01/29/2024 05:57 AM
There's no error related to this in logs. Getting below error on UI and it's not allowing to submit request.
One observation, not getting error when there's username present in bracket for pending requests or it's null. Getting error in case where only empty brackets are added.
From below shared image, only top row is causing the issue (Harry123 H ()). It's working fine if I keep other requests pending except the top one.
02/04/2024 06:41 PM
Hello Saviynt Team,
Need assistance with the resolution of the above error. Please suggest a meeting time for IST time zone to look into this issue further as it is affecting our delivery.
02/04/2024 09:35 PM
This is expected, if a request is already present for same username then it will not allow you to raise.
You need check for the username from request attrss table as well in the adavance config to exclude the username in any pending requests as well.
Thanks
Darshan
02/08/2024 09:51 PM
Hi Darshan,
Can you please share exact table name and column name where we can check username from pending requests? I tried to find it but didn't find it.
Thanks,
Smita
02/08/2024 10:27 PM - edited 02/08/2024 10:27 PM
Table name : request_access_attrs
Column name raa.attribute_name = 'DYnamic attribute Name'
02/09/2024 03:21 AM
Hi @SmitaSJ
Pls refer to this sample example :
select cast(max(username)+1 as SIGNED) as ID from users where username like '810%'
union all
select cast(max(ATTRIBUTE_VALUE)+1 as SIGNED) as ID from request_access_attrs where ATTRIBUTE_NAME = "username"
and ATTRIBUTE_VALUE like '810%' order by ID desc limit 1 ;
Here username is the dynamic attribute name
Thanks
Darshan
02/11/2024 06:56 PM
Thanks Darshan. Username generation issue is resolved using this query for dynamic attribute.
02/05/2024 12:13 AM
Our understanding is that the username is generated when the request for user creation is approved. Since our requests are in pending state, there are no duplicate usernames, thus there should not be username conflict. Can you please suggest a meeting in IST timezone
02/05/2024 12:24 AM
Hi @tanvi_gaikwad ,
No once a request is already present for approval we shouldnt have ang request for same username as there is a chance that both can get approved.
so we dont allow usernames which are pending for approval.
please add the condition as i said and that should work.
Also we wont be able to setup any call from this platform as its how to questions, if needed please take ES service if you need help around implementation.
we can guide over the suggestions and provide the product behaviour via this platform.
Thanks
Darshan
02/05/2024 08:11 PM
Refer sample :
https://forums.saviynt.com/t5/identity-governance/username-generation-rule/m-p/11630