Email Generation rule causes ArrayIndexOutOfBoundsException

[nvachhani]

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?  

[Raghu]

@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'), ' ', '')

[nvachhani]

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 

[rushikeshvartak]

Please run query from data analyzer and validate issue

[nvachhani]

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

[rushikeshvartak]

Reduce number of line items and find issue causing

[nvachhani]

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

[rushikeshvartak]

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

[nvachhani]

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

[rushikeshvartak]

Please share logs in txt file

[nvachhani]

I have attached the logs

[rushikeshvartak]

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

[nvachhani]

This is producing the same error

[nvachhani]

Do I need to raise a support ticket for this?

[rushikeshvartak]

did you validated from data analyzer ?

[nvachhani]

Each statement works separately in data analyzer

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

[rushikeshvartak]

You can raise support ticket