Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/30/2024 10:13 AM - edited 05/30/2024 10:25 AM
Hello Team,
We are using Register User Rule in username generation.
For this we are using sequence generator provided by Saviynt as part of dataset.
We are using a case statement which utilizes users.customproperty19 to use the sequence generator.
Can someone let us know if cp19 is actually exposed as part of register user rule?
We are always getting an error with syntax issue..
Register User Name Rule :
case when (users.customproperty19 IN ('ABC','DEF')) then FN_EIC_SEQGEN('FormAUser')
when (users.customproperty19 IN ('GHI','KHI')) then CONCAT('KPCI-', FN_EIC_SEQGEN('FormAUser')) end
Error :
"2024-05-30T15:36:53.066+00:00","ecm","services.WorkflowService","http-nio-8080-exec-6-l9fvz","DEBUG","Error in running Advanced Config Query rule: "
"2024-05-30T15:36:53.215+00:00","ecm","","null-l9fvz","","java.sql.SQLSyntaxErrorException: 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 '9 IN ('ABC','DEF')) then FN_EIC_SEQGEN('FormAUser')"
05/30/2024 12:45 PM
CASE
WHEN users.customproperty19 IN ('ABC', 'DEF') THEN FN_EIC_SEQGEN('FormAUser')
WHEN users.customproperty19 IN ('GHI', 'KHI') THEN CONCAT('KPCI-', FN_EIC_SEQGEN('FormAUser'))
END
05/30/2024 09:25 PM
@rushikeshvartak the same error persists.
Is there an issue with attribute cp19 not exposed?
Also we are capturing this details from end user while filling the form and mapping to cp19.
The data type is ENUM.
Also we see 1 more error everytime we submit the form :
24.4 Version Upgrade - Getting error occurred pop ... - Saviynt Forums - 87549
05/30/2024 09:39 PM
Did you trying changing CP19 to other CP ?
05/30/2024 09:48 PM
Validated with country its working.
05/30/2024 10:17 PM
Maybe some data issue.
05/30/2024 10:36 PM
i tried with 5-6 cp but same issue 😞
05/30/2024 10:37 PM
try 65
06/02/2024 08:47 PM
Issue persists.
Not sure if cp is actually exposed.
06/03/2024 07:50 PM
Working as expected in v24.5