Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

V24.4 || Register User Rule Issue

Manu269
All-Star
All-Star

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

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.
9 REPLIES 9

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

@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

 

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Did you trying changing CP19 to other CP ?


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

Validated with country its working.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Maybe some data issue.


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

i tried with 5-6 cp but same issue 😞

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

try 65


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

Issue persists.

Not sure if cp is actually exposed.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Working as expected in v24.5 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.