Getting error while updating role in Saviynt

[supriya_singh]

Hi team,

Wile creating new role we added entitlement and sent it for approval and getting below error.

We also tried auto approval and also user is having ROLE_ADMIN savrole still we are getting below error

Can someone help ?

Regards,

Supriya

[Srinivas]

Hi @supriya_singh 

What does the logs say.

[supriya_singh]

Hi Srinivas,

Below are the logs 

2022-11-11 07:13:25,436 [https-jsse-nio-443-exec-399] ERROR jdbc.AbstractBatcher  - Exception executing batch:
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    at com.saviynt.ecm.services.RoleversionService.sendRequest(RoleversionService.groovy:1681)
    at com.saviynt.ecm.identitywarehouse.controllers.RolesController$_closure80.doCall(RolesController.groovy:4384)
    at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53)
    at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145)
    at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62)
    at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59)
    at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69)
    at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
2022-11-11 07:13:25,436 [https-jsse-nio-443-exec-399] ERROR events.PatchedDefaultFlushEventListener  - Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    at com.saviynt.ecm.services.RoleversionService.sendRequest(RoleversionService.groovy:1681)
    at com.saviynt.ecm.identitywarehouse.controllers.RolesController$_closure80.doCall(RolesController.groovy:4384)
    at

Regards,

Supriya

[rushikeshvartak]

Did you attached role management workflow in global configuration? 

Does workflow working?

[supriya_singh]

yes I tried. It was throwing the same error.

Regards,

Supriya

[rushikeshvartak]

Please share screenshot of global configuration 

[supriya_singh]

Please find the below configuration

Regards,

Supriya

[rushikeshvartak]

Since auto approve is configured it should not go for approval. Can you attach logs