Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/12/2022 01:06 PM
Hello All,
Can we remove the special characters while generating the system user name? We tried using the mysql function REGEXP '[_]' however it does not work in rule config.
Following error is seen the logs:
2020-11-25 19:06:12,517 [https-jsse-nio-443-exec-10] ERROR services.SaviyntCommonUtilityService - Error in running Advanced Config Query rule:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(case when (users.employeetype = 'Managed Service') AND (users.lastname REGEXP '' at line 5
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
Thanks,
Pallavi
Solved! Go to Solution.
04/12/2022 02:21 PM
While configuring the systemusernamrule there is an textbox where in you provide the list of allowed special characters.This would enable to have systemusername with list of special characters required.
Thanks
Ajay
04/12/2022 02:22 PM
04/12/2022 02:22 PM
I would suggest to use inline-preprocessor which enables you to use mysql functions and custom jar.
Thanks
Ajay
04/12/2022 02:22 PM
Can we invoke mysql functions from system user name generation rules config to check for special characters?
04/12/2022 02:22 PM
Hi, Yes My sql functions like concat,substring are supported.
Thanks
Ajay