Unable to upload Bulk Enterprise roles

[IGAQ]

Hello All,

I am trying to upload Enterprise Role through UI , Its failing with "red screen error - unexpected error", I have attached csv file as well, any idea what i am missing ?

Logs

=======

2024-03-27T22:43:10-05:00-ecm-services.RoleversionService-http-nio-8080-exec-24-8trvz-ERROR-Problem occured while uploading role-associations -- null

2024-03-27T22:43:10-05:00-ecm-errors.GrailsExceptionResolver-http-nio-8080-exec-24-8trvz-ERROR-UnexpectedRollbackException occurred when processing request: [POST] /ECM/roles/uploadRoleTcodes

2024-03-27T22:43:10-05:00-ecm--null-8trvz--Transaction rolled back because it has been marked as rollback-only. Stacktrace follows:

2024-03-27T22:43:10-05:00-ecm--null-8trvz--org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only at com.saviynt.ecm.identitywarehouse.controllers.RolesController$_closure160.doCall(RolesController.groovy:8051) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:155) 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.lang.Thread.run(Thread.java:750)

[rushikeshvartak]

Refer sample

[IGAQ]

Thank you @rushikeshvartak for the response.

 For Enterprise Role - Security System and Endpoint is mandatory ?

[rushikeshvartak]

No. Its for entitlement underline Enterprise role

[IGAQ]

Hello @rushikeshvartak I have tried your file without SS and EP, still its failing, file also attached.

[rushikeshvartak]

Please share logs and also confirm 

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Impor...

[pmahalle]

Hi @IGAQ ,

Use bulk upload option using below steps and check once.

1. Navigate to Request Home --> Request Access for Others - Multi Users -->Actions -->Bulk Upload Request.

2. Browse and attach the excel file. Attached the sample file (do not change the format of the file) to assign enterprise roles, update it with your data.

3. Select "What type of request do you want to upload?" : Access

4. Click Run Now.

[rushikeshvartak]

@pmahalle  This is role creation from Admin and not adding roles to user

[pmahalle]

@rushikeshvartak Ohh okay. Since subject line is Bulk upload the enterprise roles I thought to bulk assignment of roles to user.

@IGAQ Can you share the steps you followed to upload the roles?

[IGAQ]

Hello @pmahalle - Created sample file with roles - uploaded here -> Identity Repository -> Roles -> role upload via Role managent -> uploaded the file.

Now I am seeing another issue - if my file has 10 records it only creates first record as enterpriserole

Thanks,

[rushikeshvartak · Accepted solution]

You have to use Upload Role Associations option