2022-10-06 19:22:22,388 [https-jsse-nio-8443-exec-7] INFO  services.UsersService  - starting to process Accounts auditing
2022-10-06 19:22:22,389 [https-jsse-nio-8443-exec-7] INFO  services.UsersService  - Auditing process completed for Accounts
2022-10-06 19:22:36,879 [https-jsse-nio-8443-exec-9] INFO  services.UsersService  - starting to process Accounts auditing
2022-10-06 19:22:36,879 [https-jsse-nio-8443-exec-9] INFO  services.UsersService  - Auditing process completed for Accounts
2022-10-06 19:22:36,884 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Enter in Method importDataFromFile WITH Import File name=Account_Import2.csv10-06-2022
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportUtilityService  - Setting Batch Size from config = 1000
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - IGNOREFIRSTLINE = YES
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - delimiter = ,
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - FILEIMPORTDELIMETER = ,
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - DELETEACCOUNTENTITLEMENT = true
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - ACCOUNT_NOT_IN_FILE_ACTION = YES
2022-10-06 19:22:36,885 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - CORRELATEINACTIVEACCOUNTS = NO
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - ACCOUNTNAME found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - CUSTOMPROPERTY24 found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - OWNERUSER found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - OWNERTYPE found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - OWNERRANK found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - ENDPOINTNAME found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - ACCOUNTTYPE found in SAV file
2022-10-06 19:22:37,220 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - OPERATION found in SAV file
2022-10-06 19:22:37,221 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Start processing Accounts data
2022-10-06 19:22:37,221 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Executing batch of 1000
2022-10-06 19:22:37,221 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Executed 1 records
2022-10-06 19:22:37,224 [https-jsse-nio-8443-exec-9] DEBUG services.SaviyntCommonUtilityService  - itemIdSetList Size:: 1
2022-10-06 19:22:37,224 [https-jsse-nio-8443-exec-9] 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-06 19:22:37,224 [https-jsse-nio-8443-exec-9] TRACE 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) endpointIdsInBatch: [49]
2022-10-06 19:22:37,515 [https-jsse-nio-8443-exec-9] DEBUG services.SaviyntCommonUtilityService  - itemIdSetList Size:: 1
2022-10-06 19:22:37,515 [https-jsse-nio-8443-exec-9] 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-06 19:22:37,515 [https-jsse-nio-8443-exec-9] TRACE services.ImportReqsysDataService  - Query: select new Map(u.username as username, u.id as id) from Users u where u.username IN (:ownerUsers) ownerUsers: [UW9]
2022-10-06 19:22:37,516 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Start processing Account Owners data
2022-10-06 19:22:37,516 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Executing batch of 1000
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)
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Unsaved Accounts = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Total Record In File = 1
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Accounts Inserted = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Endpoints Inserted = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Entitlement Types Inserted = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - total skipped duplicate entries = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - End processing Accounts data
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Start processing Entitlements data
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Entitlement Values Inserted = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Account Entitlement Mappings Inserted = 0
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - End processing Entitlements data
2022-10-06 19:22:37,519 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - account_not_in_file_action = YES
2022-10-06 19:22:38,530 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Accounts Deleted/Suspended 0
2022-10-06 19:22:38,771 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Start processing User-Account and Account-Entitlement mappings
2022-10-06 19:22:38,772 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Executing batch of 1000
2022-10-06 19:22:38,772 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - deleteaccountentitlement: true
2022-10-06 19:22:38,772 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - End processing User-Account and Account-Entitlement mappings
2022-10-06 19:22:38,772 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Orphan Accounts Qry - Update Accounts set ORPHAN = 1 where accountkey in (0  )
2022-10-06 19:22:38,773 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Total Orphan Accounts - 0
2022-10-06 19:22:38,773 [https-jsse-nio-8443-exec-9] DEBUG saviynt.ImportExternalDbService  - Associating Users and Accounts
2022-10-06 19:22:39,958 [https-jsse-nio-8443-exec-9] DEBUG saviynt.ImportExternalDbService  - Orphan Accounts- 49066
2022-10-06 19:22:39,959 [https-jsse-nio-8443-exec-9] DEBUG saviynt.ImportExternalDbService  - Rule: users.customproperty11 = accounts.name
2022-10-06 19:22:39,959 [https-jsse-nio-8443-exec-9] 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.customproperty11 = accounts.name
                            WHERE ACCOUNTS.ENDPOINTKEY = 49 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-06 19:22:39,964 [https-jsse-nio-8443-exec-9] TRACE saviynt.ImportExternalDbService  - accuserMap = [:]
2022-10-06 19:22:39,964 [https-jsse-nio-8443-exec-9] DEBUG saviynt.ImportExternalDbService  - Total accounts to be correlated = 0
2022-10-06 19:22:39,964 [https-jsse-nio-8443-exec-9] DEBUG saviynt.ImportExternalDbService  - User-accounts correlated: 0
2022-10-06 19:22:40,307 [https-jsse-nio-8443-exec-9] DEBUG saviynt.ImportExternalDbService  - Orphan Accounts remaining- 49066
2022-10-06 19:22:40,307 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - User Account Mappings Inserted = 0
2022-10-06 19:22:40,307 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - User Account Mappings Updated = 0
2022-10-06 19:22:40,308 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Total time taken to import = 3423 ms
2022-10-06 19:22:40,313 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - DATA FILE Account_Import2.csv10-06-2022 MOVED TO SUCCESS DIR. IMPORT FINISHED = true
2022-10-06 19:22:40,473 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Exit in Method importDataFromFile
2022-10-06 19:22:40,473 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - temp file deleted successfully
2022-10-06 19:22:40,473 [https-jsse-nio-8443-exec-9] INFO  services.ImportReqsysDataService  - FILE MOVED AFTER IMPORT FINISHED = false
2022-10-06 19:22:40,474 [https-jsse-nio-8443-exec-9] DEBUG services.ImportReqsysDataService  - Data file : Account_Import2.csv10-06-2022 has been archived after import: Account_Import2.csv10-06-2022