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

Email Generation rule causes ArrayIndexOutOfBoundsException

nvachhani
Regular Contributor
Regular Contributor

Below is the email generation rule, first statement works. However, when testing duplicate where incrementation should occur we are seeing the below error:

2024-05-01T17:10:46-04:00-ecm-worker--null-wkk28--java.lang.ArrayIndexOutOfBoundsException: 1 at com.saviynt.ecm.services.WorkflowService.getPropertyFromRule(WorkflowService.groovy:8080) at com.saviynt.ecm.services.WorkflowService$_generateUserProperty_closure96.doCall(WorkflowService.groovy:8667) at com.saviynt.ecm.services.WorkflowService.generateUserProperty(WorkflowService.groovy:8656) at com.saviynt.ecm.services.WorkflowService.$tt__generateEmail(WorkflowService.groovy:8785) at com.saviynt.ecm.services.changeaction.UserChangeActionService.generateUpdateUserEmail(UserChangeActionService.groovy:3008) at com.saviynt.ecm.services.changeaction.UserChangeActionService$_excuteFinal_closure7.doCall(UserChangeActionService.groovy:590) at com.saviynt.ecm.services.changeaction.UserChangeActionService.excuteFinal(UserChangeActionService.groovy:458) at com.saviynt.rulerun.RuleRunService$_runRulesWithTrail_closure11_closure33_closure34.doCall(RuleRunService.groovy:725) at com.saviynt.rulerun.RuleRunService$_runRulesWithTrail_closure11_closure33.doCall(RuleRunService.groovy:637) at com.saviynt.rulerun.RuleRunService$_runRulesWithTrail_closure11.doCall(RuleRunService.groovy:635) at com.saviynt.rulerun.RuleRunService.runRulesWithTrail(RuleRunService.groovy:634) at com.saviynt.rulerun.RuleRunService.runRules(RuleRunService.groovy:63) at RuleRunJob.executeRules(RuleRunJob.groovy:147) at RuleRunJob.execute(RuleRunJob.groovy:60) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)

 

 

CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,'@company.com'), ' ', '')
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,1,'@company.com'), ' ', '')
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,1,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,1,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,2,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,2,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,2,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,3,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,3,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,3,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,4,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,4,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,4,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,5,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,5,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,5,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,6,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,6,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,6,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,7,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,7,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,7,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,8,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,8,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,8,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,9,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,9,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,9,'@company.com'), ' ', '') ELSE '' END ### CASE WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY29,10,'@company.com'), ' ', '') WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,10,'@company.com'), ' ', '') 
WHEN CUSTOMPROPERTY7 = 'Yes' AND CUSTOMPROPERTY27 is not null AND CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(CUSTOMPROPERTY27,'.',CUSTOMPROPERTY29,10,'@company.com'), ' ', '') ELSE '' END 

 

 

Any idea why this error is occurring?  

16 REPLIES 16

Raghu
Valued Contributor III
Valued Contributor III

@nvachhani  please below article it will help full

https://forums.saviynt.com/t5/identity-governance/email-generation-rule-for-duplicate-email/m-p/8643...

and looks passing direct column name , need users object please modify and check again

Example:

CASE WHEN Users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'@company.com'), ' ', '')


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

nvachhani
Regular Contributor
Regular Contributor

Thanks for the reply, I have made the following changes but still seeing the same error, ArrayIndexOutOfBoundsException when testing increment.

 

CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'1@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'1@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'2@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'2@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'2@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'3@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'3@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'3@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'4@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'4@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'4@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'5@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'5@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'5@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'6@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'6@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'6@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'7@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'7@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'7@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'8@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'8@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'8@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'9@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'9@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'9@company.com'), ' ', '') ELSE '' END ### 
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'10@company.com'), ' ', '') WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'10@company.com'), ' ', '') 
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'10@company.com'), ' ', '') ELSE '' END 

Please run query from data analyzer and validate issue


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

nvachhani
Regular Contributor
Regular Contributor

I do not see any errors when running the query from data analyzer, it is able to generate email with incrementing number

Reduce number of line items and find issue causing


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

nvachhani
Regular Contributor
Regular Contributor

I have reduced to 2 statements, it is failing for the second statement:

 

CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'@company.com'), ' ', '') ELSE '' END ###
CASE WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 is null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 is not null AND users.CUSTOMPROPERTY29 is not null THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'1@company.com'), ' ', '') ELSE '' END

CASE
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NULL AND users.CUSTOMPROPERTY29 IS NULL THEN REPLACE(CONCAT('1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 IS NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NOT NULL AND users.CUSTOMPROPERTY29 IS NOT NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'1@company.com'), ' ', '')
ELSE ''
END


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

nvachhani
Regular Contributor
Regular Contributor

This statement by itself works, but when multiple statements for incrementation are put together separated by ### I am seeing the error

CASE
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NULL AND users.CUSTOMPROPERTY29 IS NULL THEN REPLACE(CONCAT('@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 IS NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NOT NULL AND users.CUSTOMPROPERTY29 IS NOT NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'@company.com'), ' ', '')
ELSE ''
END ###
CASE
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NULL AND users.CUSTOMPROPERTY29 IS NULL THEN REPLACE(CONCAT('1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY29 IS NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'1@company.com'), ' ', '')
WHEN users.CUSTOMPROPERTY7 = 'Yes' AND users.CUSTOMPROPERTY27 IS NOT NULL AND users.CUSTOMPROPERTY29 IS NOT NULL THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'1@company.com'), ' ', '')
ELSE ''
END

 

Please share logs in txt file


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

nvachhani
Regular Contributor
Regular Contributor

I have attached the logs

CASE
WHEN users.CUSTOMPROPERTY7 = 'Indirect Labor' AND users.CUSTOMPROPERTY27 IS NULL AND users.CUSTOMPROPERTY29 IS NULL
THEN REPLACE(CONCAT('@companytest.com'), ' ', '')

WHEN users.CUSTOMPROPERTY7 = 'Indirect Labor' AND users.CUSTOMPROPERTY27 IS NULL
THEN REPLACE(CONCAT(users.CUSTOMPROPERTY29,'@companytest.com'), ' ', '')

WHEN users.CUSTOMPROPERTY7 = 'Indirect Labor' AND users.CUSTOMPROPERTY29 IS NULL
THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'@companytest.com'), ' ', '')

WHEN users.CUSTOMPROPERTY7 = 'Indirect Labor' AND users.CUSTOMPROPERTY27 IS NOT NULL AND users.CUSTOMPROPERTY29 IS NOT NULL
THEN REPLACE(CONCAT(users.CUSTOMPROPERTY27,'.',users.CUSTOMPROPERTY29,'@companytest.com'), ' ', '')

ELSE ''
END


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

nvachhani
Regular Contributor
Regular Contributor

This is producing the same error

nvachhani
Regular Contributor
Regular Contributor

Do I need to raise a support ticket for this?

did you validated from data analyzer ?


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

nvachhani
Regular Contributor
Regular Contributor

Each statement works separately in data analyzer

Error is occurring when moving from first statement to the next in the rule

You can raise support ticket


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