V24.4 || Register User Rule Issue

[Manu269]

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')"

[rushikeshvartak]

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

[Manu269]

@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

[rushikeshvartak]

Did you trying changing CP19 to other CP ?

[Manu269]

Validated with country its working.

[rushikeshvartak]

Maybe some data issue.

[Manu269]

i tried with 5-6 cp but same issue 😞

[rushikeshvartak]

try 65

[Manu269]

Issue persists.

Not sure if cp is actually exposed.

[rushikeshvartak]

Working as expected in v24.5