Add user to Role with csv using Upload Role Association

[tim_watson]

I am trying to bulk update user is a Role using the Upload Role Association.

The File format below

ROLE NAME,SECURITY SYSTEM,ENDPOINT,ROLE USERS
Finance,AD,AD,45698
Finance,AD,AD,32145

I ran the import for the first time with one user and it worked, the users was added to the Role.  I added another user to test again and nothing happens.  I took all users out of the Role and ran the original user that worked and now that does not even work.  

Does the Upload Role Association support adding users?  It worked once, but now nothing happens.

[sundas7]

Hi Tim,

Can you please confirm the version?  Are you seeing any error in logs?

Thanks

Shyam

[tim_watson]

v 5.5 sp3 .11  Here are the logs after the import. There is an error below.

2022-05-26 18:47:08,729 [https-jsse-nio-443-exec-35] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:08,729 [https-jsse-nio-443-exec-35] INFO services.UsersService - Auditing for list of Roles
2022-05-26 18:47:08,739 [https-jsse-nio-443-exec-35] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:08,751 [https-jsse-nio-443-exec-35] INFO controllers.RolesController - Entering roles association upload functionality.
2022-05-26 18:47:08,968 [https-jsse-nio-443-exec-51] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:08,968 [https-jsse-nio-443-exec-51] INFO services.UsersService - Auditing for list of Roles
2022-05-26 18:47:08,977 [https-jsse-nio-443-exec-51] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:09,124 [quartzScheduler_Worker-4] ERROR listeners.ExceptionPrinterJobListener - Exception occured in job: REPORTS.UploadJob
org.quartz.JobExecutionException [See nested exception: java.lang.ArrayIndexOutOfBoundsException]
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused by: java.lang.ArrayIndexOutOfBoundsException
2022-05-26 18:47:10,441 [https-jsse-nio-443-exec-47] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:10,441 [https-jsse-nio-443-exec-47] INFO services.UsersService - Auditing for list of Roles
2022-05-26 18:47:10,441 [https-jsse-nio-443-exec-47] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:15,783 [https-jsse-nio-443-exec-49] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:15,788 [https-jsse-nio-443-exec-49] INFO services.UsersService - Auditing for roleUsers action
2022-05-26 18:47:15,796 [https-jsse-nio-443-exec-49] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:16,005 [https-jsse-nio-443-exec-40] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:16,010 [https-jsse-nio-443-exec-40] INFO services.UsersService - Auditing for roleuserslist action
2022-05-26 18:47:16,017 [https-jsse-nio-443-exec-40] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:16,118 [https-jsse-nio-443-exec-22] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:16,123 [https-jsse-nio-443-exec-22] INFO services.UsersService - Auditing for usersRoleJson action
2022-05-26 18:47:16,123 [https-jsse-nio-443-exec-22] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:17,031 [https-jsse-nio-443-exec-47] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:17,038 [https-jsse-nio-443-exec-47] INFO services.UsersService - Auditing for roleTcodes action
2022-05-26 18:47:17,045 [https-jsse-nio-443-exec-47] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:17,270 [https-jsse-nio-443-exec-35] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:17,275 [https-jsse-nio-443-exec-35] INFO services.UsersService - Auditing for getEntitlementValuesJson action
2022-05-26 18:47:17,275 [https-jsse-nio-443-exec-35] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:17,280 [https-jsse-nio-443-exec-51] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:17,285 [https-jsse-nio-443-exec-51] INFO services.UsersService - Auditing for roletcodeentitlementslist action
2022-05-26 18:47:17,293 [https-jsse-nio-443-exec-51] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:18,850 [https-jsse-nio-443-exec-54] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:18,855 [https-jsse-nio-443-exec-54] INFO services.UsersService - Auditing for roleUsers action
2022-05-26 18:47:18,864 [https-jsse-nio-443-exec-54] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:19,059 [https-jsse-nio-443-exec-29] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:19,060 [https-jsse-nio-443-exec-49] INFO services.UsersService - starting to process roles auditing
2022-05-26 18:47:19,065 [https-jsse-nio-443-exec-49] INFO services.UsersService - Auditing for roleuserslist action
2022-05-26 18:47:19,065 [https-jsse-nio-443-exec-29] INFO services.UsersService - Auditing for usersRoleJson action
2022-05-26 18:47:19,065 [https-jsse-nio-443-exec-29] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:19,072 [https-jsse-nio-443-exec-49] INFO services.UsersService - Auditing process completed for entitlement
2022-05-26 18:47:25,969 [https-jsse-nio-443-exec-40] INFO domain.JobcontrolController - Auditing for list of JobControl
2022-05-26 18:47:25,970 [https-jsse-nio-443-exec-40] INFO domain.JobcontrolController - Auditing process completed for JobControl

[rushikeshvartak]

Does below option was enabled while uploading

[tim_watson]

The Existing Role Users is turned off when the import runs.

The only buttons on are Role Users and First row as heading

[Srinivas]

Hi Tim Watson, 

Thank you for reaching out to us, 

Please follow our official product documentation,   

Link: https://saviynt.freshdesk.com/a/solutions/articles/43000618941

Please look into the below section in the above documentation.

"Existing Role Users"

Let us know if this helps!

Thanks

Srinivas

[tim_watson]

I have made user the Existing Role users is on the correct setting.

I looked at the logs and see the error below when I run the import.  Looks like a backend job can not be found.

[quartzScheduler_Worker-2] ERROR listeners.ExceptionPrinterJobListener - Exception occured in job: REPORTS.UploadJob
org.quartz.JobExecutionException [See nested exception: java.lang.ArrayIndexOutOfBoundsException]
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused by: java.lang.ArrayIndexOutOfBoundsException

[Srinivas]

Hello,

I have ran the Upload Role Association with the sample available in the fresh desk , which is working as expected attached the outputs & logs for the same. Hope this sample helps!

Thanks & Regards

Srinivas

[tim_watson]

Do you need to keep all the attributes in the Sample file?  I just want associate users to the Roles.

ROLE NAME,SECURITY SYSTEM,ENDPOINT,ROLE USERS
Finance,AD,AD,45698
Finance,AD,AD,32145

[Sandeep · Accepted solution]

Try with below fields in your file. It worked for me

Role Name	Security System	Endpoint	Entitlement Type	Entitlement Value	Role users
SampleTest					T-PZS

[tim_watson]

This did work with the file format provided.  I also tried below and it worked, but it did not work previously.  Thanks for the help all.

Role Name,Role USERS

SampleRole, 1234