2024-03-12T02:53:50-04:00-ecm----2024-03-12T06:53:50.020540417Z stdout F 2024-03-12 06:53:50,020 [http-nio-8080-exec-15] DEBUG services.WorkflowService - whereQry - and 1=1 and upper(users.username) like '10000125%' order by tasks.id desc NULLS LAST 2024-03-12T02:53:50-04:00-ecm----2024-03-12T06:53:50.020650218Z stdout F WHERE tasks.id > 0 and tasks.status IN (1,2,6,7) and 1=1 and upper(users.username) like '10000125%' order by tasks.id desc NULLS LAST 2024-03-12T02:53:50-04:00-ecm----2024-03-12T06:53:50.020652018Z stdout F 2024-03-12 06:53:50,020 [http-nio-8080-exec-15] DEBUG services.WorkflowService - taskQry - and 1=1 and upper(users.username) like '10000125%' order by tasks.id desc NULLS LAST 2024-03-12T02:53:46-04:00-ecm----2024-03-12T06:53:45.822609863Z stdout F WHERE tasks.id > 0 and tasks.status IN (1,2,6,7) and 1=1 and upper(users.username) like '10000125%' order by tasks.id desc NULLS LAST 2024-03-12T02:53:46-04:00-ecm----2024-03-12T06:53:45.822611863Z stdout F 2024-03-12 06:53:45,822 [http-nio-8080-exec-15] DEBUG services.WorkflowService - taskQry - and 1=1 and upper(users.username) like '10000125%' order by tasks.id desc NULLS LAST 2024-03-12T02:53:46-04:00-ecm----2024-03-12T06:53:45.822484162Z stdout F 2024-03-12 06:53:45,822 [http-nio-8080-exec-15] DEBUG services.WorkflowService - whereQry - and 1=1 and upper(users.username) like '10000125%' order by tasks.id desc NULLS LAST 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.112666293Z stdout F 2024-03-12 06:53:09,112 [quartzScheduler_Worker-7] DEBUG saviynt.ImportExternalDbService - Not creating Zero Day tasks for user-10000125-account name could not not be derived 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.122518337Z stdout F 2024-03-12 06:53:09,122 [quartzScheduler_Worker-7] DEBUG saviynt.ImportExternalDbService - Not creating Zero Day tasks for user-10000125-account name could not not be derived 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.123831942Z stdout F 2024-03-12 06:53:09,123 [quartzScheduler_Worker-7] DEBUG rulerun.RuleRunService - Created zero tasks for user-10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.123880943Z stdout F 2024-03-12 06:53:09,123 [quartzScheduler_Worker-7] DEBUG rulerun.RuleRunService - START Rule Run for userkey=59337 , username=10000125 Completed 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.708881409Z stdout F 2024-03-12 06:53:08,708 [quartzScheduler_Worker-7] DEBUG rulerun.RuleRunService - START Rule Run for userkey=59337 , username=10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.750469093Z stdout F 2024-03-12 06:53:08,750 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - newbatchMap [21###191,185###133:[10000125]] 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.750798994Z stdout F 2024-03-12 06:53:08,750 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Processing rerun provisioning rule for -59337 , 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.750820994Z stdout F 2024-03-12 06:53:08,750 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - matchTechRuleByUserAndReturnMap for user 59337,10000125 started 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.760786938Z stdout F 2024-03-12 06:53:08,760 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.784875145Z stdout F 2024-03-12 06:53:08,784 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 done 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.797008198Z stdout F 2024-03-12 06:53:08,796 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.797057598Z stdout F 2024-03-12 06:53:08,797 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 done 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.804732032Z stdout F 2024-03-12 06:53:08,804 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - matchTechRuleByUserAndReturnMap for user 59337,10000125 finished 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.825978426Z stdout F 2024-03-12 06:53:08,825 [quartzScheduler_Worker-7] DEBUG saviynt.ImportExternalDbService - Creating Zero Day Task for - 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.853253947Z stdout F 2024-03-12 06:53:08,853 [quartzScheduler_Worker-7] DEBUG saviynt.ImportExternalDbService - Not creating Zero Day tasks for user-10000125-account name could not not be derived 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.853339147Z stdout F 2024-03-12 06:53:08,853 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Processing rerun provisioning rule for -59337 , 10000125 done 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.853530548Z stdout F 2024-03-12 06:53:08,853 [quartzScheduler_Worker-7] DEBUG rulerun.RuleRunService - Evaluating rules to identify if the user-10000125 matches any zeroDay Rules 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.853555548Z stdout F 2024-03-12 06:53:08,853 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - matchTechRuleByUserAndReturnMap for user 59337,10000125 started 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.889060005Z stdout F 2024-03-12 06:53:08,889 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.891380915Z stdout F 2024-03-12 06:53:08,891 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 done 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.924375261Z stdout F 2024-03-12 06:53:08,924 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.924616062Z stdout F 2024-03-12 06:53:08,924 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 done 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:08.98740314Z stdout F 2024-03-12 06:53:08,987 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.000872299Z stdout F 2024-03-12 06:53:09,000 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - Fetching getTechRuleMap for user-59337 , 10000125 done 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.086591078Z stdout F 2024-03-12 06:53:09,086 [quartzScheduler_Worker-7] DEBUG changeaction.UserChangeActionService - matchTechRuleByUserAndReturnMap for user 59337,10000125 finished 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.091992102Z stdout F 2024-03-12 06:53:09,091 [quartzScheduler_Worker-7] DEBUG rulerun.RuleRunService - Creating zero Day Task for user-10000125 2024-03-12T02:53:09-04:00-ecm-worker----2024-03-12T06:53:09.100998342Z stdout F 2024-03-12 06:53:09,100 [quartzScheduler_Worker-7] DEBUG saviynt.ImportExternalDbService - Creating Zero Day Task for - 10000125 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.050627623Z stdout F 2024-03-12 06:52:49,050 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - Proceed to Import for records - > [10000125, chakritha.naga.ext@mail.com, Test2C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test2C Naga, Florida] : true 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.050670123Z stdout F 2024-03-12 06:52:49,050 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - Executing query select userkey as userkey from users where username = :reconvalue , reconvalue=10000125 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.052059428Z stdout F 2024-03-12 06:52:49,052 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - reconcillationValue during insertion ::: 10000125 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.052073128Z stdout F 2024-03-12 06:52:49,052 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - User with username '10000125' does not exist. Creating new one 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.12046869Z stdout F 2024-03-12 06:52:49,120 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - Adding user 10000125 to the batch 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.12048039Z stdout F 2024-03-12 06:52:49,120 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - #1 :: 10000125 :: #Adding new user to the batch 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.3576166Z stdout F 2024-03-12 06:52:49,357 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - #3 :: 10000125 :: #New User 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.373156459Z stdout F 2024-03-12 06:52:49,373 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - processing attributes for user 10000125 , userattribute = null , updateuser = false 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.380566788Z stdout F 2024-03-12 06:52:49,380 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - Final batch - Adding to Rule Run table- new user with username : 10000125 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.381414491Z stdout F 2024-03-12 06:52:49,381 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - Added to Rule Run table- new user for username-10000125 2024-03-12T02:52:49-04:00-ecm----2024-03-12T06:52:49.381439791Z stdout F 2024-03-12 06:52:49,381 [http-nio-8080-exec-15] DEBUG services.ImportSAvDataUserService - Saving user data for username : 10000125 2024-03-12T02:52:40-04:00-ecm----2024-03-12T06:52:40.095461046Z stdout F 2024-03-12 06:52:40,095 [http-nio-8080-exec-3] DEBUG controllers.UsersController - CSV Data : [[10000116, chakritha.naga.ext@mail.com, Test1C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test1C Naga 6, Ohio], [10000117, chakritha.naga.ext@mail.com, Test1C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test1C Naga 7, Ohio], [10000118, chakritha.naga.ext@mail.com, Test1C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test1C Naga 8, Ohio], [10000119, chakritha.naga.ext@mail.com, Test1C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test1C Naga 9, Ohio], [10000120, chakritha.naga.ext@mail.com, Test2C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test2C Naga, Ohio], [10000121, chakritha.naga.ext@mail.com, Test2C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test2C Naga, Florida], [10000122, chakritha.naga.ext@mail.com, Test2C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test2C Naga, Ohio], [10000123, chakritha.naga.ext@mail.com, Steven, Test3, Contractor, 1, 2/28/2025, Contractor (outside FG), Steven Test, Ohio], [10000124, chakritha.naga.ext@mail.com, Steven, Test3, Contractor, 1, 2/28/2025, Contractor (outside FG), Steven Test, Ohio], [10000125, chakritha.naga.ext@mail.com, Test2C, Naga, Contractor, 1, 2/28/2025, Contractor (outside FG), Test2C Naga, Florida]]