We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Add user to Role with csv using Upload Role Association

tim_watson
New Contributor III
New Contributor III

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.

10 REPLIES 10

sundas7
Regular Contributor II
Regular Contributor II

Hi Tim,

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

 

Thanks

Shyam

tim_watson
New Contributor III
New Contributor III

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
All-Star
All-Star

Does below option was enabled while uploading

rushikeshvartak_0-1653588721389.png

 


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

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

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

 

 

Srinivas
Saviynt Employee
Saviynt Employee

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

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
Saviynt Employee
Saviynt Employee

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

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

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

Role NameSecurity SystemEndpointEntitlement TypeEntitlement ValueRole users
SampleTest    T-PZS

tim_watson
New Contributor III
New Contributor III

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