Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/02/2024 06:28 AM
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?
05/02/2024 06:35 AM
@nvachhani please below article it will help full
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'), ' ', '')
05/02/2024 07:06 AM
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
05/02/2024 09:38 PM
Please run query from data analyzer and validate issue
05/03/2024 05:32 AM
I do not see any errors when running the query from data analyzer, it is able to generate email with incrementing number
05/04/2024 08:29 AM
Reduce number of line items and find issue causing
05/06/2024 08:47 AM
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
05/06/2024 08:50 AM
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
05/06/2024 01:25 PM - edited 05/06/2024 01:27 PM
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
05/06/2024 06:24 PM
Please share logs in txt file
05/07/2024 11:54 AM
05/07/2024 06:54 PM
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
05/08/2024 06:16 AM
This is producing the same error
05/10/2024 09:52 AM
Do I need to raise a support ticket for this?
05/10/2024 09:53 AM
did you validated from data analyzer ?
05/10/2024 10:00 AM
Each statement works separately in data analyzer
Error is occurring when moving from first statement to the next in the rule
05/10/2024 10:02 AM
You can raise support ticket