Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Can we update existing orphaned accounts via an Account Upload?

umang28
Regular Contributor
Regular Contributor

Hello, 

I am trying to upload an accounts via a CSV file but it always fails to link and update an existing account in Saviynt. There is also no column to add in the accountkey.

In the upload account preview it shows:

total skipped duplicate entries: 1 

Total Record In File: 1 

So I am wondering by design does it not link and update an existing account or am I missing something?

14 REPLIES 14

rushikeshvartak
All-Star
All-Star

can you share import sheet & preview of import sheet from Saviynt

Account Namecustom property 24owner userowner typeOwner rankendpointAccount typeOperation
serviceaccountService - InterfacervartakUser1App1Service AccountAdd

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

umang28
Regular Contributor
Regular Contributor
 

Remove accountid and try

 


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

It worked, however, the owner name is not getting populated and the owner type is populated as 'User Group' when in file the owner name is provided along with the type being User. 

Try usergroup & share file if it does not work


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

 

Rank 26 can be user only not user group try other rank other than 26/27


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

Yes that worked but my aim is to update the following:

ownertype - user 

ownerrank - 26

owneruser - UW9

 

 

Account Namecustom property 24owner userowner typeOwner rankendpointAccount typeOperation
serviceaccountService - InterfaceUW9User26App1Service AccountAdd

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

This seems like a bug in our system. Owner name is not getting populated and the owner type is getting incorrectly populated. Attaching Screenshots. 

Are you able to add from UI ?

Can you share logs when you import from file.

Can you try file as comma separated instead of tab & take account where  account name does not contain special characters  


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

From the UI it works just fine. 

Tried as comma separated and account name without any special chars but with no luck.

2022-10-06 19:22:37,517 [https-jsse-nio-8443-exec-9] TRACE services.ImportReqsysDataService - Opration: Add, Query: insert into accountowners (accountkey, rank, updatedate, updateuser, owneruserkey) values (562164, 26, '2022-10-06 19:22:37', 'iamadmin', null)

 

Does UW9 user exist ? if yes its issue in your environment

rushikeshvartak_0-1665108672477.pngrushikeshvartak_1-1665108701928.pngrushikeshvartak_2-1665108715465.png

Logs

2022-10-07 02:10:44,787 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Enter in Method importDataFromFile WITH Import File name=accountImport-CPS.csv10-07-2022
2022-10-07 02:10:44,787 [https-jsse-nio-443-exec-65] DEBUG services.ImportUtilityService - Setting Batch Size from config = 500
2022-10-07 02:10:44,787 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - IGNOREFIRSTLINE = YES
2022-10-07 02:10:44,787 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - delimiter = ,
2022-10-07 02:10:44,787 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - FILEIMPORTDELIMETER = ,
2022-10-07 02:10:44,787 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - ACCOUNT_NOT_IN_FILE_ACTION = NO
2022-10-07 02:10:44,788 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - CORRELATEINACTIVEACCOUNTS = NO
2022-10-07 02:10:45,242 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - ACCOUNTNAME found in SAV file
2022-10-07 02:10:45,242 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - OWNERUSER found in SAV file
2022-10-07 02:10:45,242 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - OWNERTYPE found in SAV file
2022-10-07 02:10:45,242 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - OWNERRANK found in SAV file
2022-10-07 02:10:45,242 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - ENDPOINTNAME found in SAV file
2022-10-07 02:10:45,242 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - OPERATION found in SAV file
2022-10-07 02:10:45,243 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Start processing Accounts data
2022-10-07 02:10:45,245 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Executing batch of 500
2022-10-07 02:10:49,318 [https-jsse-nio-443-exec-48] DEBUG println.PrintlnToLogger - Println :: Inside loadUserByUsername of child GormUserDetailsService.
2022-10-07 02:10:49,328 [https-jsse-nio-443-exec-48] DEBUG println.PrintlnToLogger - Println :: Authentication failed: Bad credentials
2022-10-07 02:10:49,329 [https-jsse-nio-443-exec-48] DEBUG println.PrintlnToLogger - Println :: Not authenticated. Rest authentication token not generated.
2022-10-07 02:10:50,750 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Executed 1 records
2022-10-07 02:10:50,760 [https-jsse-nio-443-exec-65] DEBUG services.SaviyntCommonUtilityService - itemIdSetList Size:: 1
2022-10-07 02:10:50,760 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Query: select new Map(a.accountID as accountID, a.endpointkey.id as endpointkeyid, a.name as name, a.id as id) from Accounts a where a.endpointkey.id IN (:endpointIdsInBatch)
2022-10-07 02:10:50,766 [https-jsse-nio-443-exec-65] DEBUG services.SaviyntCommonUtilityService - itemIdSetList Size:: 1
2022-10-07 02:10:50,766 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Query: select new Map(u.username as username, u.id as id) from Users u where u.username IN (:ownerUsers)
2022-10-07 02:10:50,768 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Start processing Account Owners data
2022-10-07 02:10:50,769 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Executing batch of 500
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Unsaved Accounts = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Total Record In File = 1
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Accounts Inserted = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Endpoints Inserted = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Entitlement Types Inserted = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - total skipped duplicate entries = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - End processing Accounts data
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Start processing Entitlements data
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Entitlement Values Inserted = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Account Entitlement Mappings Inserted = 0
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - End processing Entitlements data
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - account_not_in_file_action = NO
2022-10-07 02:10:50,786 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Accounts Deleted/Suspended 0
2022-10-07 02:10:55,144 [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1
2022-10-07 02:10:56,863 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Start processing User-Account and Account-Entitlement mappings
2022-10-07 02:10:56,864 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Executing batch of 500
2022-10-07 02:10:56,864 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - deleteaccountentitlement: false
2022-10-07 02:10:56,867 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - End processing User-Account and Account-Entitlement mappings
2022-10-07 02:10:56,867 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Orphan Accounts Qry - Update Accounts set ORPHAN = 1 where accountkey in (0 )
2022-10-07 02:10:56,867 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Total Orphan Accounts - 0
2022-10-07 02:10:56,867 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - Associating Users and Accounts
2022-10-07 02:10:56,879 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - Orphan Accounts- 80
2022-10-07 02:10:56,879 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - Rule: users.username=accounts.name
2022-10-07 02:10:56,879 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - sql =
SELECT USERS.USERKEY AS USERKEY, ACCOUNTS.ACCOUNTKEY AS ACCOUNTKEY FROM ACCOUNTS ACCOUNTS
LEFT JOIN USER_ACCOUNTS UA ON ACCOUNTS.ACCOUNTKEY = UA.ACCOUNTKEY
LEFT JOIN USERS USERS ON
users.username=accounts.name
WHERE ACCOUNTS.ENDPOINTKEY = 270 AND ACCOUNTS.STATUS IN ('Active','1','Manually Provisioned')
AND ACCOUNTS.ACCOUNTKEY IS NOT NULL AND UA.ACCOUNTKEY IS NULL
AND ACCOUNTS.NAME IS NOT NULL AND USERS.USERNAME IS NOT NULL

2022-10-07 02:10:56,886 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - Total accounts to be correlated = 0
2022-10-07 02:10:56,886 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - User-accounts correlated: 0
2022-10-07 02:10:56,887 [https-jsse-nio-443-exec-65] DEBUG saviynt.ImportExternalDbService - Orphan Accounts remaining- 80
2022-10-07 02:10:56,887 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - User Account Mappings Inserted = 0
2022-10-07 02:10:56,887 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - User Account Mappings Updated = 0
2022-10-07 02:10:56,887 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Total time taken to import = 12100 ms
2022-10-07 02:10:56,888 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - DATA FILE accountImport-CPS.csv10-07-2022 MOVED TO SUCCESS DIR. IMPORT FINISHED = true
2022-10-07 02:10:56,888 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - Exit in Method importDataFromFile
2022-10-07 02:10:56,888 [https-jsse-nio-443-exec-65] DEBUG services.ImportReqsysDataService - temp file deleted successfully

 


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

It does exist and looks like it's case sensitive. It worked when the owner name was updated as lower case "uw9" in the file to match the user name. 

Thanks for your support!