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

User update rule doesn't get triggered post upgrade.

Gavula
New Contributor
New Contributor

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 .

Gavula_0-1715001289551.png

Technical rule

Gavula_1-1715001403129.png

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.

 

 

16 REPLIES 16

Raghu
Valued Contributor III
Valued Contributor III

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

or use in like customproperty23 -in-   (Campain)


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

rushikeshvartak
All-Star
All-Star

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


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

Hi Rushikesh,

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

And we are ruuning it from UI.

Please make sure

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

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

Saathvik
All-Star
All-Star

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

Saathvik_0-1715020738173.png

 

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Hi Saathvik,

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

Gavula_0-1715068985268.png

 




@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

Saathvik_0-1715094456507.png

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Aparna
New Contributor III
New Contributor III

Hi All,

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

Aparna_0-1715169951527.png

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

Please share logs


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

Hi Rushi,

Please find the attched logs.

Thanks,
Gangi Reddy A

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"


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

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.

What is MB?


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

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
New Contributor
New Contributor

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.

Gavula_0-1715942257159.png

Thanks,
Gangi Reddy A.


Thanks,



@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?

Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.