User update rule doesn't get triggered post upgrade.

[Gavula]

Hi Team,

We tried to assign sav role for 1 user but it didn't get assign and we have uploaded user using CSV file and we could see the user in saviynt 

we have created User update rule and Technical rule but this rule didn't get triggered .

Technical rule

can you please check let us know that do we need change something in sav role or any changes that we need to do.

Thanks,
Gangi Reddy A.

[Raghu]

@Gavula  can you try instead of equals use contains try it

or use in like customproperty23 -in-   (Campain)

[rushikeshvartak]

When this rule is triggered ? from UI or Import Please share logs

[Gavula]

Hi Rushikesh,

We havn't schduled this rule we have manually ran it. 

And we are ruuning it from UI.

[rushikeshvartak]

Please make sure

1. customproperty is blank before uploading user import file
2. Check Rules is marked as Yes during import.

[Saathvik]

@Gavula : What is your Trigger Action for user update rule?

[Gavula]

Hi Saathvik,

PFB,
We didn't gave anything over the filed.

[Saathvik]

@Gavula : Hopefully the user you are uploading does already exist in Saviynt and you just trying to update CP65 because update rule is configured such a way it should trigger only for updated users through import and csv upload is considered as import, Also make sure you did select below option while uploading

[Aparna]

Hi All,

It just triggers that User Update rule :  but not mapping the exact rule to trigger for the condition 

[This message has been edited by moderator to mask email address]

[rushikeshvartak]

Please share logs

[Gavula]

Hi Rushi,

Please find the attched logs.

Thanks,
Gangi Reddy A

[rushikeshvartak]

You have error in user update rule please fix same.

"2024-05-10T13:16:17.454+00:00","ecm-worker","","null-jpgxh","","org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: null near line 1, column 136 [select a.id from com.saviynt.ecm.identitywarehouse.domain.Users a where a.id=52270 AND (( a.customproperty2 = 'MBCREATED' AND 1=1 )]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: null near line 1, column 136 [select a.id from com.saviynt.ecm.identitywarehouse.domain.Users a where a.id=52270 AND (( a.customproperty2 = 'MBCREATED' AND 1=1 )] at com.saviynt.ecm.services.changeaction.UserChangeActionService$_getMatchRuleForuser_closure71.doCall(UserChangeActionService.groovy:3303) at com.saviynt.ecm.services.changeaction.UserChangeActionService.getMatchRuleForuser(UserChangeActionService.groovy:3147) at com.saviynt.ecm.services.changeaction.UserChangeActionService.checkAndExecuteRules(UserChangeActionService.groovy:291) at com.saviynt.rulerun.RuleRunService$_runRulesWithTrail_closure11_closure33_closure34.doCall(RuleRunService.groovy:696) 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)Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: null near line 1, column 136 [select a.id from com.saviynt.ecm.identitywarehouse.domain.Users a where a.id=52270 AND (( a.customproperty2 = 'MBCREATED' AND 1=1 )] ... 12 more"

[Gavula]

Hi Rushi,

We could see MB CREATED in the but we have updated CP65 as CAMPAIGN .

I'm attaching the logs again, Could you please check and revert us.

Thanks,
Gangi Reddy A.

[rushikeshvartak · Accepted solution]

What is MB?

[Gavula]

Hi Rushi,

As you mentioned in the logs I could see MB CREATED and it's not related to our issue.

I have uploaded logs again, can you please check the latest logs.

Thanks,
Gangi Reddy A.

[Gavula]

Hi Rushi,

We could see task is getting created but it is not completed and we could see the ZERODAY in the commnets.
Please find the attched screen shot and Rule logs as well.

Thanks,
Gangi Reddy A.

Thanks,

[Saathvik]

@Gavula :

• Do you see any provisioning retries count?
• Did the provisioning job(WSRetryJob) ran successfully? 
• Also does the provisioning job have any filters?
• Does that task have future start date?