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

User Import Issue when using same Secondary Manager

draut
New Contributor III
New Contributor III

Hi All,

We are facing an issue with user Identity creation while CSV Upload or Using "create user form" when using the same secondary manager for multiple users or the same secondary manager is already assigned as a secondary manager for existing users.

Saviynt is not able to create an identity for such users, we are not getting any error while uploading the file but it is showing 0 users inserted.

Error Logs : 

Service Name	Date Timestamp (UTC)	Message
ecm	2024-02-08T12:21:18.741+00:00	2024-02-08T12:21:18.501968671Z stdout F 2024-02-08 12:21:18,501 [http-nio-8080-exec-21] ERROR util.JDBCExceptionReporter  - Duplicate entry '37' for key 'FK4D495E8D272255C'
ecm	2024-02-08T12:21:18.741+00:00	2024-02-08T12:21:18.503599735Z stdout F Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '37' for key 'FK4D495E8D272255C'

Screenshot 2024-02-08 175131.png

Can you please confirm if any config needs to change to assign the same secondary manager to multiple users?

Thanks,

Dheeraj

Dheeraj
5 REPLIES 5

pmahalle
All-Star
All-Star

Hi @draut ,

Is it working when you are updating same secondary manager for multiple users from UI, I mean Admin --> Identity Repository --> Users?


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

draut
New Contributor III
New Contributor III

Hi @pmahalle ,

No, it is not updating the new secondary manager, tried from UI as well.

Regards,

Dheeraj

Dheeraj

@draut  You mean same secondary manager for multiple user not allowing through UI as well? What error you are getting on UI?


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

draut
New Contributor III
New Contributor III

Hi @pmahalle ,

Getting this error 

 

"ecm","2024-02-08T13:58:19.741+00:00","2024-02-08T13:58:19.097299715Z stdout F 2024-02-08 13:58:19,097 [http-nio-8080-exec-1] DEBUG changeaction.UserChangeActionService  - Calling update user"
"ecm","2024-02-08T13:58:19.741+00:00","2024-02-08T13:58:19.10780291Z stdout F 2024-02-08 13:58:19,107 [http-nio-8080-exec-1] DEBUG changeaction.UserChangeActionService  - Update Fields for User History Tabs : [secondaryManager]"
"ecm","2024-02-08T13:58:19.741+00:00","2024-02-08T13:58:19.117043257Z stdout F 2024-02-08 13:58:19,116 [http-nio-8080-exec-1] ERROR util.JDBCExceptionReporter  - Duplicate entry '21' for key 'FK4D495E8D272255C'"
"ecm","2024-02-08T13:58:18.741+00:00","2024-02-08T13:58:17.851989855Z stdout F 2024-02-08 13:58:17,851 [http-nio-8080-exec-21] DEBUG controllers.UsersController  - Users found : 0"

 

Dheeraj

This seems version issue. I have validated in v24.1 and i am able to set same secondary manager for 2 users.

User 1:

rushikeshvartak_0-1707453737573.png

User 2 :

rushikeshvartak_1-1707453749572.png

 

 

Please upgrade version and retest


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