"Date Timestamp (UTC)","Service Name","Class Name","Thread Name","Log Level","Message" "2024-08-02T12:11:08.723+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-49-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:2, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:0,1,2,3,4,5,6,7,8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:11:08.723+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-64-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:3, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:0,1,2,3,4,5,6,7,8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:11:06.105+00:00","ecm","rest.JwtService","http-nio-8080-exec-56-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:11:06.106+00:00","ecm","rest.JwtService","http-nio-8080-exec-56-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:11:06.126+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-56-rsrjr","DEBUG","Disable Audit Logging : true" "2024-08-02T12:11:06.128+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-56-rsrjr","DEBUG","Default max limit is set to 50" "2024-08-02T12:11:06.128+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-56-rsrjr","DEBUG","inside getEcmVersion" "2024-08-02T12:11:06.129+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-56-rsrjr","DEBUG","contentType - text/json" "2024-08-02T12:11:06.130+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-56-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:11:06.153+00:00","ecm","rest.JwtService","http-nio-8080-exec-66-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:11:06.154+00:00","ecm","rest.JwtService","http-nio-8080-exec-66-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:11:06.176+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-66-rsrjr","DEBUG","enter getNewUX" "2024-08-02T12:11:06.177+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-66-rsrjr","DEBUG","getNewUX is fetch from database" "2024-08-02T12:11:06.178+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-66-rsrjr","DEBUG","Exit getNewUX" "2024-08-02T12:11:06.179+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","contentType - application/json" "2024-08-02T12:11:06.179+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:11:06.247+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-70-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:1, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, action:listjson, controller:campaign, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:11:05.227+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-66-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [status:5, controller:campaign, action:list, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:11:05.230+00:00","ecm","campains.CampaignController","http-nio-8080-exec-66-rsrjr","DEBUG","Enter campaign list.." "2024-08-02T12:11:05.231+00:00","ecm","campains.CampaignController","http-nio-8080-exec-66-rsrjr","DEBUG","campUrlsAccessQry--_select url from Requestmap where description = 'CAMPAIGN' and ( 1=2 OR concat(',',configAttribute,',') like '%,ROLE_ADMIN,%' )" "2024-08-02T12:11:05.237+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List:: Total Campaign refresh Job Scheduled and Running 0" "2024-08-02T12:11:05.238+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List:: Campaign refresh Job already running false" "2024-08-02T12:11:05.238+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List:: Total Campaign refresh Job Manually and Running 0" "2024-08-02T12:11:05.239+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List Trigger CampaignProgressRefreshJob_xxx:: Status -1" "2024-08-02T12:11:05.239+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Trigger CampaignProgressRefreshJob_xxx not exists. enabling progress refresh feature" "2024-08-02T12:11:05.241+00:00","ecm","campains.CampaignController","http-nio-8080-exec-66-rsrjr","DEBUG","Exit campaign list.." "2024-08-02T12:11:04.430+00:00","ecm-worker","campaigns.CampaignService","quartzScheduler_Worker-7-qgpxz","WARN","DB count :1979" "2024-08-02T12:11:04.430+00:00","ecm-worker","campaigns.CampaignService","quartzScheduler_Worker-7-qgpxz","WARN","ES count :1979" "2024-08-02T12:11:04.452+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Batch size configured for entitlement owner campaign secondary certifier assign while populating data 100" "2024-08-02T12:11:04.483+00:00","ecm-worker","jobs.CampaignJob","quartzScheduler_Worker-7-qgpxz","DEBUG","Campaign Job End" "2024-08-02T12:11:04.526+00:00","ecm-worker","jobs.CampaignReminderJob","quartzScheduler_Worker-2-qgpxz","DEBUG","CampaignReminder Job Start" "2024-08-02T12:11:04.536+00:00","ecm-worker","jobs.CampaignReminderJob","quartzScheduler_Worker-2-qgpxz","DEBUG","Calling campaign service" "2024-08-02T12:11:04.540+00:00","ecm-worker","campaigns.CampaignService","quartzScheduler_Worker-2-qgpxz","DEBUG","campaign now sending and email" "2024-08-02T12:11:04.547+00:00","ecm-worker","jobs.CampaignReminderJob","quartzScheduler_Worker-2-qgpxz","INFO","Campaign Reminder job ends" "2024-08-02T12:11:04.547+00:00","ecm-worker","jobs.CampaignReminderJob","quartzScheduler_Worker-2-qgpxz","DEBUG","Campaign Reminder Job End" "2024-08-02T12:10:59.309+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Elastic Data saved in 919" "2024-08-02T12:11:00.023+00:00","ecm-worker","jobs.EmailHistoryJob","quartzScheduler_Worker-5-qgpxz","DEBUG","Start cronEmailHistoryJob" "2024-08-02T12:11:00.025+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","EmailHistoryService: Inside Execute" "2024-08-02T12:11:00.027+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","Email History Service start @ " "2024-08-02T12:11:00.027+00:00","ecm-worker","services.ImportUtilityService","quartzScheduler_Worker-5-qgpxz","DEBUG","Setting Batch Size from config = 1000" "2024-08-02T12:11:00.038+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","USE_MULTI_THREADING_EMAIL_HISTORY_JOB=1" "2024-08-02T12:11:00.038+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","sendEmailUsingThreads =true" "2024-08-02T12:11:00.038+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","emailNewSessionFlag true" "2024-08-02T12:11:00.042+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","Fetching data to be insert for EMAILHISTORY_ARCHIVE Table checkpoint 1 - | SELECT EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,| CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,| TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS FROM EMAILHISTORYPROCESS where status not in (5,15,404) | " "2024-08-02T12:11:00.042+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","Inserting sql for EMAILHISTORY_ARCHIVE Table checkpoint 1 - INSERT INTO EMAILHISTORY_ARCHIVE (EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) " "2024-08-02T12:11:00.043+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","Inserting into EMAILHISTORY to retry emails with status 5,15,404 - | INSERT INTO EMAILHISTORY(ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,| JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS)| SELECT ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,| JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS | FROM EMAILHISTORYPROCESS where status in (5,15,404)| " "2024-08-02T12:11:00.045+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","Cleaning EmailHistoryProcess - removing old entries - DELETE FROM EMAILHISTORYPROCESS " "2024-08-02T12:11:00.049+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","total records in emailhistory table = 0" "2024-08-02T12:11:00.062+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-5-qgpxz","DEBUG","Email History Service END" "2024-08-02T12:11:00.062+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-5-qgpxz","DEBUG","inside executeFailedEmails" "2024-08-02T12:11:00.062+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-5-qgpxz","DEBUG","Start of moveEmailsToArchiveWithoutToCCBcc" "2024-08-02T12:11:00.063+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-5-qgpxz","DEBUG","total time taken to finish moveEmailsToArchiveWithoutToCCBcc in miliseconds 1" "2024-08-02T12:11:00.064+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-5-qgpxz","DEBUG","end of moveEmailsToArchiveWithoutToCCBcc" "2024-08-02T12:11:00.065+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-5-qgpxz","DEBUG","Exit executeFailedEmails" "2024-08-02T12:11:00.065+00:00","ecm-worker","jobs.EmailHistoryJob","quartzScheduler_Worker-5-qgpxz","DEBUG","End cronEmailHistoryJob" "2024-08-02T12:10:58.364+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","emptyCertificationsToBeDeleted - 0" "2024-08-02T12:10:58.364+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Calling get client with retry for launch campaign" "2024-08-02T12:10:58.387+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","ElasticSearch response: [number_of_pending_tasks:0, cluster_name:797382084246:xxx-es, active_shards:1010, active_primary_shards:1010, unassigned_shards:1010, delayed_unassigned_shards:0, timed_out:false, relocating_shards:0, initializing_shards:0, task_max_waiting_in_queue_millis:0, number_of_data_nodes:1, number_of_in_flight_fetch:0, active_shards_percent_as_number:50.0, status:yellow, number_of_nodes:1]" "2024-08-02T12:10:58.390+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","campaignindexbatchcount = 10000" "2024-08-02T12:10:58.394+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","certEntColumns to show in response - [Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS]" "2024-08-02T12:10:58.398+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","userColumns to show in response - [User_DISPLAYNAME, User_TITLE, User_COSTCENTER]" "2024-08-02T12:10:58.403+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","certEnt2Columns to show in response - []" "2024-08-02T12:10:58.404+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","getEODetailedViewDataForCreateCampaign SELECT * FROM (| select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE, cev.description as ENTDESCRIPTION, | cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, cev.ENTITLEMENT_GLOSSARY as Ent_ENTITLEMENT_GLOSSARY, cev.STATUS as Ent_STATUS,| cevs.certified as ENTCERTIFIED, cevs.comments as ENTCOMMENT, cevs.ISREASSIGNED as ENTISREASSIGNED, cevs.AUDIT_TRAIL as ENT_AUDIT_TRAIL,| cevs.UPDATEUSER as ENT_UPDATEUSER, cevs.UPDATEDATE as ENT_UPDATEDATE,| NULL as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE, Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, | NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS, NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE,| NULL as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, NULL as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, NULL as ENT2_UPDATEDATE, | NULL as ENT2ISREASSIGNED, 0 as ROW_TYPE, cevs.onlyStep2 as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | left join cert_ent_values_status cevs on (cev.CERT_ENTITLEMENT_VALUEKEY=cevs.CERT_ENTITLEMENT_VALUEKEY)| left join certification cert on (cert.CERTKEY = cevs.CERTKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join Users u on (cev.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY in (1423) and et.ENDPOINTKEY=ep.ENDPOINTKEY and ep.securitysystemkey=ss.systemkey | and ep.status=1| Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, aae1s.lastusedenddate as LASTUSEDENDDATE, aae1s.enddate as ENDDATE,| aae1s.access as ACCESS, aae1s.LASTCERTIFIEDCAMPAIGNNAME as LASTCERTIFIEDCAMPAIGNNAME, aae1s.lastCertifiedUser as LASTCERTIFIEDUSER, | aae1s.lastCertifiedDate as LASTCERTIFIEDDATE, certacc.cert_accountkey as CERT_ACCOUNTKEY, certacc.name as ACCOUNTNAME,| ep.endpointname as ENDPOINT, aae1s.certified as ACCOUNTCERTFIED, certacc.status as ACCSTATUS, aae1s.comments as ACCCOMMENT, | aae1s.AUDIT_TRAIL as ACC_AUDIT_TRAIL, aae1s.UPDATEUSER as ACC_UPDATEUSER,aae1s.UPDATEDATE as ACC_UPDATEDATE, certusr.statuskey as USERSTATUS, | certusr.username as USERNAME, certusr.DISPLAYNAME as User_DISPLAYNAME, certusr.TITLE as User_TITLE, certusr.COSTCENTER as User_COSTCENTER, | NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, | NULL as ENT2_UPDATEDATE, NULL as ENT2ISREASSIGNED, 1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS,| CASE| WHEN certacc.status='2' or upper(certacc.status)='INACTIVE' then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT,| CASE| WHEN aae1s.LASTCERTIFIEDDATE is not null and -DATEDIFF(aae1s.LASTCERTIFIEDDATE, now()) < 30 then 'YES'| ELSE NULL END AS LASTCERTIFIED_CHART, | CASE| WHEN certacc.updatedate is not null and -DATEDIFF(certacc.updatedate, now()) > 60 | and (certacc.status='2' or upper(certacc.status)='INACTIVE') then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT_CHART,| CASE | WHEN certusr.username is null or certusr.username ='' then 'YES'| ELSE NULL END as ORPHAN_ACCOUNT_CHART,| CASE| WHEN (aae1s.RISKS is not null and aae1s.RISKS !='') THEN 'YES'| ELSE 'NO'| END as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ACCOUNT_ENTITLEMENT1_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join CERTIFICATION_ACCOUNT certacc on aae1s.CERT_ACCOUNTKEY=certacc.CERT_ACCOUNTKEY| left join CERTIFICATION_USER_ACCOUNT_STATUS cuas on certacc.CERT_ACCOUNTKEY=cuas.CERT_ACCOUNTKEY| left join CERTIFICATION_USER certusr on cuas.CERT_USERKEY=certusr.CERT_USERKEY| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| where cert.CAMPAIGNKEY in (1423) and certacc.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey and ep.status=1 | Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS, cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE,| Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS,| NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE, null as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| cev2.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUE2KEY, cev2.entitlement_value as ENT2NAME, aae1s.certified as ENT2CERTIFIED,| cev.status as ENT2STATUS, aae1s.comments as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, aae1s.UPDATEUSER as ENT2_UPDATEUSER, | aae1s.UPDATEDATE as ENT2_UPDATEDATE, aae1s.ISREASSIGNED as ENT2ISREASSIGNED, -1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME, | CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK| from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ENTITLEMENT2_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join certification_entitlement_value cev2 on (aae1s.CERT_ENTITLEMENT_VALUE2KEY=cev2.CERT_ENTITLEMENT_VALUEKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join Users u on (cev2.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY = 1423 and et.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey | and ep.status=1 ) AS resultData ORDER BY CERT_ENTITLEMENT_VALUEKEY" "2024-08-02T12:10:58.505+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","ent data fetched count = 1979" "2024-08-02T12:10:58.505+00:00","ecm-worker","campaigns.CampaignESService","quartzScheduler_Worker-7-qgpxz","DEBUG","====saving index======" "2024-08-02T12:10:58.505+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","certEntColumns to show in response - [Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS]" "2024-08-02T12:10:58.506+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","userColumns to show in response - [User_DISPLAYNAME, User_TITLE, User_COSTCENTER]" "2024-08-02T12:10:58.506+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","certEnt2Columns to show in response - []" "2024-08-02T12:10:58.506+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","getEODetailedViewDataForCreateCampaign SELECT * FROM (| select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE, cev.description as ENTDESCRIPTION, | cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, cev.ENTITLEMENT_GLOSSARY as Ent_ENTITLEMENT_GLOSSARY, cev.STATUS as Ent_STATUS,| cevs.certified as ENTCERTIFIED, cevs.comments as ENTCOMMENT, cevs.ISREASSIGNED as ENTISREASSIGNED, cevs.AUDIT_TRAIL as ENT_AUDIT_TRAIL,| cevs.UPDATEUSER as ENT_UPDATEUSER, cevs.UPDATEDATE as ENT_UPDATEDATE,| NULL as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE, Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, | NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS, NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE,| NULL as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, NULL as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, NULL as ENT2_UPDATEDATE, | NULL as ENT2ISREASSIGNED, 0 as ROW_TYPE, cevs.onlyStep2 as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | left join cert_ent_values_status cevs on (cev.CERT_ENTITLEMENT_VALUEKEY=cevs.CERT_ENTITLEMENT_VALUEKEY)| left join certification cert on (cert.CERTKEY = cevs.CERTKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join Users u on (cev.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY in (1423) and et.ENDPOINTKEY=ep.ENDPOINTKEY and ep.securitysystemkey=ss.systemkey | and ep.status=1| Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, aae1s.lastusedenddate as LASTUSEDENDDATE, aae1s.enddate as ENDDATE,| aae1s.access as ACCESS, aae1s.LASTCERTIFIEDCAMPAIGNNAME as LASTCERTIFIEDCAMPAIGNNAME, aae1s.lastCertifiedUser as LASTCERTIFIEDUSER, | aae1s.lastCertifiedDate as LASTCERTIFIEDDATE, certacc.cert_accountkey as CERT_ACCOUNTKEY, certacc.name as ACCOUNTNAME,| ep.endpointname as ENDPOINT, aae1s.certified as ACCOUNTCERTFIED, certacc.status as ACCSTATUS, aae1s.comments as ACCCOMMENT, | aae1s.AUDIT_TRAIL as ACC_AUDIT_TRAIL, aae1s.UPDATEUSER as ACC_UPDATEUSER,aae1s.UPDATEDATE as ACC_UPDATEDATE, certusr.statuskey as USERSTATUS, | certusr.username as USERNAME, certusr.DISPLAYNAME as User_DISPLAYNAME, certusr.TITLE as User_TITLE, certusr.COSTCENTER as User_COSTCENTER, | NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, | NULL as ENT2_UPDATEDATE, NULL as ENT2ISREASSIGNED, 1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS,| CASE| WHEN certacc.status='2' or upper(certacc.status)='INACTIVE' then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT,| CASE| WHEN aae1s.LASTCERTIFIEDDATE is not null and -DATEDIFF(aae1s.LASTCERTIFIEDDATE, now()) < 30 then 'YES'| ELSE NULL END AS LASTCERTIFIED_CHART, | CASE| WHEN certacc.updatedate is not null and -DATEDIFF(certacc.updatedate, now()) > 60 | and (certacc.status='2' or upper(certacc.status)='INACTIVE') then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT_CHART,| CASE | WHEN certusr.username is null or certusr.username ='' then 'YES'| ELSE NULL END as ORPHAN_ACCOUNT_CHART,| CASE| WHEN (aae1s.RISKS is not null and aae1s.RISKS !='') THEN 'YES'| ELSE 'NO'| END as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ACCOUNT_ENTITLEMENT1_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join CERTIFICATION_ACCOUNT certacc on aae1s.CERT_ACCOUNTKEY=certacc.CERT_ACCOUNTKEY| left join CERTIFICATION_USER_ACCOUNT_STATUS cuas on certacc.CERT_ACCOUNTKEY=cuas.CERT_ACCOUNTKEY| left join CERTIFICATION_USER certusr on cuas.CERT_USERKEY=certusr.CERT_USERKEY| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| where cert.CAMPAIGNKEY in (1423) and certacc.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey and ep.status=1 | Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS, cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE,| Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS,| NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE, null as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| cev2.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUE2KEY, cev2.entitlement_value as ENT2NAME, aae1s.certified as ENT2CERTIFIED,| cev.status as ENT2STATUS, aae1s.comments as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, aae1s.UPDATEUSER as ENT2_UPDATEUSER, | aae1s.UPDATEDATE as ENT2_UPDATEDATE, aae1s.ISREASSIGNED as ENT2ISREASSIGNED, -1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME, | CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK| from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ENTITLEMENT2_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join certification_entitlement_value cev2 on (aae1s.CERT_ENTITLEMENT_VALUE2KEY=cev2.CERT_ENTITLEMENT_VALUEKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join Users u on (cev2.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY = 1423 and et.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey | and ep.status=1 ) AS resultData ORDER BY CERT_ENTITLEMENT_VALUEKEY" "2024-08-02T12:10:58.507+00:00","ecm-worker","analytics.AnalyticsESService","quartzScheduler_Worker-7-qgpxz","DEBUG","Final Query with limit 1--- SELECT * FROM (| select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE, cev.description as ENTDESCRIPTION, | cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, cev.ENTITLEMENT_GLOSSARY as Ent_ENTITLEMENT_GLOSSARY, cev.STATUS as Ent_STATUS,| cevs.certified as ENTCERTIFIED, cevs.comments as ENTCOMMENT, cevs.ISREASSIGNED as ENTISREASSIGNED, cevs.AUDIT_TRAIL as ENT_AUDIT_TRAIL,| cevs.UPDATEUSER as ENT_UPDATEUSER, cevs.UPDATEDATE as ENT_UPDATEDATE,| NULL as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE, Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, | NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS, NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE,| NULL as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, NULL as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, NULL as ENT2_UPDATEDATE, | NULL as ENT2ISREASSIGNED, 0 as ROW_TYPE, cevs.onlyStep2 as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | left join cert_ent_values_status cevs on (cev.CERT_ENTITLEMENT_VALUEKEY=cevs.CERT_ENTITLEMENT_VALUEKEY)| left join certification cert on (cert.CERTKEY = cevs.CERTKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join Users u on (cev.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY in (1423) and et.ENDPOINTKEY=ep.ENDPOINTKEY and ep.securitysystemkey=ss.systemkey | and ep.status=1| Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, aae1s.lastusedenddate as LASTUSEDENDDATE, aae1s.enddate as ENDDATE,| aae1s.access as ACCESS, aae1s.LASTCERTIFIEDCAMPAIGNNAME as LASTCERTIFIEDCAMPAIGNNAME, aae1s.lastCertifiedUser as LASTCERTIFIEDUSER, | aae1s.lastCertifiedDate as LASTCERTIFIEDDATE, certacc.cert_accountkey as CERT_ACCOUNTKEY, certacc.name as ACCOUNTNAME,| ep.endpointname as ENDPOINT, aae1s.certified as ACCOUNTCERTFIED, certacc.status as ACCSTATUS, aae1s.comments as ACCCOMMENT, | aae1s.AUDIT_TRAIL as ACC_AUDIT_TRAIL, aae1s.UPDATEUSER as ACC_UPDATEUSER,aae1s.UPDATEDATE as ACC_UPDATEDATE, certusr.statuskey as USERSTATUS, | certusr.username as USERNAME, certusr.DISPLAYNAME as User_DISPLAYNAME, certusr.TITLE as User_TITLE, certusr.COSTCENTER as User_COSTCENTER, | NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, | NULL as ENT2_UPDATEDATE, NULL as ENT2ISREASSIGNED, 1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS,| CASE| WHEN certacc.status='2' or upper(certacc.status)='INACTIVE' then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT,| CASE| WHEN aae1s.LASTCERTIFIEDDATE is not null and -DATEDIFF(aae1s.LASTCERTIFIEDDATE, now()) < 30 then 'YES'| ELSE NULL END AS LASTCERTIFIED_CHART, | CASE| WHEN certacc.updatedate is not null and -DATEDIFF(certacc.updatedate, now()) > 60 | and (certacc.status='2' or upper(certacc.status)='INACTIVE') then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT_CHART,| CASE | WHEN certusr.username is null or certusr.username ='' then 'YES'| ELSE NULL END as ORPHAN_ACCOUNT_CHART,| CASE| WHEN (aae1s.RISKS is not null and aae1s.RISKS !='') THEN 'YES'| ELSE 'NO'| END as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ACCOUNT_ENTITLEMENT1_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join CERTIFICATION_ACCOUNT certacc on aae1s.CERT_ACCOUNTKEY=certacc.CERT_ACCOUNTKEY| left join CERTIFICATION_USER_ACCOUNT_STATUS cuas on certacc.CERT_ACCOUNTKEY=cuas.CERT_ACCOUNTKEY| left join CERTIFICATION_USER certusr on cuas.CERT_USERKEY=certusr.CERT_USERKEY| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| where cert.CAMPAIGNKEY in (1423) and certacc.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey and ep.status=1 | Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS, cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE,| Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS,| NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE, null as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| cev2.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUE2KEY, cev2.entitlement_value as ENT2NAME, aae1s.certified as ENT2CERTIFIED,| cev.status as ENT2STATUS, aae1s.comments as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, aae1s.UPDATEUSER as ENT2_UPDATEUSER, | aae1s.UPDATEDATE as ENT2_UPDATEDATE, aae1s.ISREASSIGNED as ENT2ISREASSIGNED, -1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME, | CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK| from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ENTITLEMENT2_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join certification_entitlement_value cev2 on (aae1s.CERT_ENTITLEMENT_VALUE2KEY=cev2.CERT_ENTITLEMENT_VALUEKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join Users u on (cev2.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY = 1423 and et.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey | and ep.status=1 ) AS resultData ORDER BY CERT_ENTITLEMENT_VALUEKEY limit 1" "2024-08-02T12:10:58.507+00:00","ecm-worker","analytics.AnalyticsESService","quartzScheduler_Worker-7-qgpxz","DEBUG","external connection is null" "2024-08-02T12:10:58.570+00:00","ecm-worker","analytics.AnalyticsESService","quartzScheduler_Worker-7-qgpxz","DEBUG","dataSizeAndFieldSetMap [result:[[CERTKEY:17145, CERTIFICATIONNAME:ENT_Owner_Campaign_CRM - xxx (Lakhitha Lakhitha), STATUS:0, CERT_ENTITLEMENT_VALUEKEY:339104, ENTSTATUS:1, ENTTYPE:Role, ENTITLEMENT_VALUE:Export Customizations (Solution Checker), ENTDESCRIPTION:Export Customizations (Solution Checker), ENTDISPLAYNAME:, ENTCRITICALITY:0, RISK:null, ENTITLEMENT_VALUEKEY:5771, Ent_ENTITLEMENT_GLOSSARY:null, Ent_STATUS:1, ENTCERTIFIED:null, ENTCOMMENT:null, ENTISREASSIGNED:false, ENT_AUDIT_TRAIL:null, ENT_UPDATEUSER:null, ENT_UPDATEDATE:2024-08-02 12:10:25.0, ACCOUNTISREASSIGNED:null, LASTUSEDENDDATE:null, ENDDATE:null, ACCESS:null, LASTCERTIFIEDCAMPAIGNNAME:null, LASTCERTIFIEDUSER:null, LASTCERTIFIEDDATE:null, CERT_ACCOUNTKEY:null, ACCOUNTNAME:null, ENDPOINT:Dynamics CRM UAT, ACCOUNTCERTFIED:null, ACCSTATUS:null, ACCCOMMENT:null, ACC_AUDIT_TRAIL:null, ACC_UPDATEUSER:null, ACC_UPDATEDATE:null, USERSTATUS:null, USERNAME:null, User_DISPLAYNAME:, User_TITLE:, User_COSTCENTER:, CERT_ENTITLEMENT_VALUE2KEY:null, ENT2NAME:null, ENT2CERTIFIED:null, ENT2STATUS:null, ENT2COMMENTS:null, ENT2_AUDIT_TRAIL:null, ENT2_UPDATEUSER:null, ENT2_UPDATEDATE:null, ENT2ISREASSIGNED:null, ROW_TYPE:0, ONLYSTEP2:[48], SYSTEMNAME:Dynamics CRM UAT, ENT_RISKS:NO, INACTIVE_ACCOUNT:null, LASTCERTIFIED_CHART:null, INACTIVE_ACCOUNT_CHART:null, ORPHAN_ACCOUNT_CHART:null, ENT_SOD_RISK:null]], columnNames:[CERTKEY, CERTIFICATIONNAME, STATUS, CERT_ENTITLEMENT_VALUEKEY, ENTSTATUS, ENTTYPE, ENTITLEMENT_VALUE, ENTDESCRIPTION, ENTDISPLAYNAME, ENTCRITICALITY, RISK, ENTITLEMENT_VALUEKEY, Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS, ENTCERTIFIED, ENTCOMMENT, ENTISREASSIGNED, ENT_AUDIT_TRAIL, ENT_UPDATEUSER, ENT_UPDATEDATE, ACCOUNTISREASSIGNED, LASTUSEDENDDATE, ENDDATE, ACCESS, LASTCERTIFIEDCAMPAIGNNAME, LASTCERTIFIEDUSER, LASTCERTIFIEDDATE, CERT_ACCOUNTKEY, ACCOUNTNAME, ENDPOINT, ACCOUNTCERTFIED, ACCSTATUS, ACCCOMMENT, ACC_AUDIT_TRAIL, ACC_UPDATEUSER, ACC_UPDATEDATE, USERSTATUS, USERNAME, User_DISPLAYNAME, User_TITLE, User_COSTCENTER, CERT_ENTITLEMENT_VALUE2KEY, ENT2NAME, ENT2CERTIFIED, ENT2STATUS, ENT2COMMENTS, ENT2_AUDIT_TRAIL, ENT2_UPDATEUSER, ENT2_UPDATEDATE, ENT2ISREASSIGNED, ROW_TYPE, ONLYSTEP2, SYSTEMNAME, ENT_RISKS, INACTIVE_ACCOUNT, LASTCERTIFIED_CHART, INACTIVE_ACCOUNT_CHART, ORPHAN_ACCOUNT_CHART, ENT_SOD_RISK], fieldSet:[CERTKEY, CERTIFICATIONNAME, STATUS, CERT_ENTITLEMENT_VALUEKEY, ENTSTATUS, ENTTYPE, ENTITLEMENT_VALUE, ENTDESCRIPTION, ENTDISPLAYNAME, ENTCRITICALITY, RISK, ENTITLEMENT_VALUEKEY, Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS, ENTCERTIFIED, ENTCOMMENT, ENTISREASSIGNED, ENT_AUDIT_TRAIL, ENT_UPDATEUSER, ENT_UPDATEDATE, ACCOUNTISREASSIGNED, LASTUSEDENDDATE, ENDDATE, ACCESS, LASTCERTIFIEDCAMPAIGNNAME, LASTCERTIFIEDUSER, LASTCERTIFIEDDATE, CERT_ACCOUNTKEY, ACCOUNTNAME, ENDPOINT, ACCOUNTCERTFIED, ACCSTATUS, ACCCOMMENT, ACC_AUDIT_TRAIL, ACC_UPDATEUSER, ACC_UPDATEDATE, USERSTATUS, USERNAME, User_DISPLAYNAME, User_TITLE, User_COSTCENTER, CERT_ENTITLEMENT_VALUE2KEY, ENT2NAME, ENT2CERTIFIED, ENT2STATUS, ENT2COMMENTS, ENT2_AUDIT_TRAIL, ENT2_UPDATEUSER, ENT2_UPDATEDATE, ENT2ISREASSIGNED, ROW_TYPE, ONLYSTEP2, SYSTEMNAME, ENT_RISKS, INACTIVE_ACCOUNT, LASTCERTIFIED_CHART, INACTIVE_ACCOUNT_CHART, ORPHAN_ACCOUNT_CHART, ENT_SOD_RISK], dataSize:1, columnNameAndTypeMap:[ENTSTATUS:BIGINT, Ent_ENTITLEMENT_GLOSSARY:LONGTEXT, ENT_AUDIT_TRAIL:LONGTEXT, ENTDISPLAYNAME:VARCHAR, User_DISPLAYNAME:VARCHAR, ACCOUNTISREASSIGNED:BIT, ONLYSTEP2:VARBINARY, STATUS:BIGINT, ENT2_UPDATEUSER:BIGINT, USERNAME:VARCHAR, ENT2STATUS:BIGINT, ENT2ISREASSIGNED:BIT, ROW_TYPE:BIGINT, ENTCRITICALITY:BIGINT, ACCOUNTCERTFIED:BIGINT, USERSTATUS:BIGINT, ENTCERTIFIED:BIGINT, ENT_RISKS:VARCHAR, CERTKEY:BIGINT, LASTCERTIFIEDCAMPAIGNNAME:VARCHAR, ENTDESCRIPTION:LONGTEXT, User_TITLE:VARCHAR, ENT_UPDATEUSER:BIGINT, ACC_AUDIT_TRAIL:LONGTEXT, ENT_SOD_RISK:VARCHAR, ORPHAN_ACCOUNT_CHART:VARCHAR, CERT_ENTITLEMENT_VALUEKEY:BIGINT, ENT2NAME:VARCHAR, ENT_UPDATEDATE:DATETIME, ENT2CERTIFIED:BIGINT, CERT_ACCOUNTKEY:BIGINT, ACCCOMMENT:LONGTEXT, ACC_UPDATEDATE:DATETIME, ENT2_AUDIT_TRAIL:LONGTEXT, ACCESS:VARCHAR, LASTCERTIFIEDDATE:DATETIME, ENTITLEMENT_VALUE:VARCHAR, ACCSTATUS:VARCHAR, INACTIVE_ACCOUNT:VARCHAR, ENTISREASSIGNED:BIT, User_COSTCENTER:VARCHAR, ACCOUNTNAME:VARCHAR, RISK:BIGINT, ENTTYPE:VARCHAR, Ent_STATUS:BIGINT, LASTCERTIFIED_CHART:VARCHAR, ENTCOMMENT:LONGTEXT, ENTITLEMENT_VALUEKEY:BIGINT, ENDDATE:DATETIME, LASTCERTIFIEDUSER:VARCHAR, LASTUSEDENDDATE:DATETIME, ENDPOINT:VARCHAR, CERTIFICATIONNAME:VARCHAR, CERT_ENTITLEMENT_VALUE2KEY:BIGINT, INACTIVE_ACCOUNT_CHART:VARCHAR, ENT2_UPDATEDATE:DATETIME, SYSTEMNAME:VARCHAR, ACC_UPDATEUSER:BIGINT, ENT2COMMENTS:LONGTEXT]]" "2024-08-02T12:10:58.571+00:00","ecm-worker","campaigns.CampaignESService","quartzScheduler_Worker-7-qgpxz","DEBUG","memento .... [indexName:entownercampaigncrm, typeName:account_ent_status, columnNameList:[CERTIFIER, ENTSTATUS, Ent_ENTITLEMENT_GLOSSARY, ENT_AUDIT_TRAIL, ENTDISPLAYNAME, User_DISPLAYNAME, ACCOUNTISREASSIGNED, ONLYSTEP2, STATUS, REASSIGNED, ENT2_UPDATEUSER, USERNAME, ENT2STATUS, ENT2ISREASSIGNED, ROW_TYPE, ENTCRITICALITY, ACCOUNTCERTFIED, USERSTATUS, ENTCERTIFIED, ENT_RISKS, CERTKEY, LASTCERTIFIEDCAMPAIGNNAME, ENTDESCRIPTION, User_TITLE, ENT_UPDATEUSER, ACC_AUDIT_TRAIL, ENT_SOD_RISK, ORPHAN_ACCOUNT_CHART, CERT_ENTITLEMENT_VALUEKEY, ENT2NAME, ENT_UPDATEDATE, ENT2CERTIFIED, CERT_ACCOUNTKEY, ACCCOMMENT, ACC_UPDATEDATE, ENT2_AUDIT_TRAIL, ACCESS, LASTCERTIFIEDDATE, ENTITLEMENT_VALUE, ACCSTATUS, INACTIVE_ACCOUNT, ENTISREASSIGNED, User_COSTCENTER, ACCOUNTNAME, RISK, ENTTYPE, Ent_STATUS, LASTCERTIFIED_CHART, ENTCOMMENT, ENTITLEMENT_VALUEKEY, ENDDATE, LASTCERTIFIEDUSER, LASTUSEDENDDATE, ENDPOINT, CERTIFICATIONNAME, CERT_ENTITLEMENT_VALUE2KEY, INACTIVE_ACCOUNT_CHART, ENT2_UPDATEDATE, SYSTEMNAME, ACC_UPDATEUSER, ENT2COMMENTS], columnNameAndType:[ENTSTATUS:BIGINT, Ent_ENTITLEMENT_GLOSSARY:LONGTEXT, ENT_AUDIT_TRAIL:LONGTEXT, ENTDISPLAYNAME:VARCHAR, User_DISPLAYNAME:VARCHAR, ACCOUNTISREASSIGNED:BIT, ONLYSTEP2:BIT, STATUS:BIGINT, CERTIFIED:VARCHAR, ENT2_UPDATEUSER:BIGINT, USERNAME:VARCHAR, ENT2STATUS:BIGINT, ENT2ISREASSIGNED:BIT, ROW_TYPE:BIGINT, ENTCRITICALITY:BIGINT, ACCOUNTCERTFIED:VARCHAR, USERSTATUS:BIGINT, ENTCERTIFIED:VARCHAR, ENT_RISKS:VARCHAR, CERTKEY:BIGINT, LASTCERTIFIEDCAMPAIGNNAME:VARCHAR, ENTDESCRIPTION:LONGTEXT, User_TITLE:VARCHAR, ENT_UPDATEUSER:BIGINT, ACC_AUDIT_TRAIL:LONGTEXT, ENT_SOD_RISK:VARCHAR, ORPHAN_ACCOUNT_CHART:VARCHAR, CERT_ENTITLEMENT_VALUEKEY:BIGINT, ENT2NAME:VARCHAR, ENT_UPDATEDATE:DATETIME, ENT2CERTIFIED:VARCHAR, CERT_ACCOUNTKEY:BIGINT, ACCCOMMENT:LONGTEXT, ACC_UPDATEDATE:DATETIME, ENT2_AUDIT_TRAIL:LONGTEXT, ACCESS:VARCHAR, LASTCERTIFIEDDATE:DATETIME, ENTITLEMENT_VALUE:VARCHAR, ACCSTATUS:VARCHAR, INACTIVE_ACCOUNT:VARCHAR, ENTISREASSIGNED:BIT, User_COSTCENTER:VARCHAR, ACCOUNTNAME:VARCHAR, RISK:BIGINT, ENTTYPE:VARCHAR, Ent_STATUS:BIGINT, LASTCERTIFIED_CHART:VARCHAR, ENTCOMMENT:LONGTEXT, ENTITLEMENT_VALUEKEY:BIGINT, ENDDATE:DATETIME, LASTCERTIFIEDUSER:VARCHAR, LASTUSEDENDDATE:DATETIME, ENDPOINT:VARCHAR, CERTIFICATIONNAME:VARCHAR, CERT_ENTITLEMENT_VALUE2KEY:BIGINT, INACTIVE_ACCOUNT_CHART:VARCHAR, ENT2_UPDATEDATE:DATETIME, SYSTEMNAME:VARCHAR, ACC_UPDATEUSER:BIGINT, ENT2COMMENTS:LONGTEXT], fieldTypeMap:[NULL:keyword, DATETIME:date, VARCHAR:text, BIGINT:long, BIT:boolean, INT:integer], indexAction:createMapping, isCallFromCampaign:true]" "2024-08-02T12:10:58.571+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","inside createOrUpdateIndexMapping" "2024-08-02T12:10:58.578+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","reinitializeClient true" "2024-08-02T12:10:58.578+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","replicacount=null" "2024-08-02T12:10:58.578+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","noofreplicas = 1" "2024-08-02T12:10:58.579+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","memento generateMappingObject().. [mappingObject:null, typeName:account_ent_status, columnNameList:[CERTIFIER, ENTSTATUS, Ent_ENTITLEMENT_GLOSSARY, ENT_AUDIT_TRAIL, ENTDISPLAYNAME, User_DISPLAYNAME, ACCOUNTISREASSIGNED, ONLYSTEP2, STATUS, REASSIGNED, ENT2_UPDATEUSER, USERNAME, ENT2STATUS, ENT2ISREASSIGNED, ROW_TYPE, ENTCRITICALITY, ACCOUNTCERTFIED, USERSTATUS, ENTCERTIFIED, ENT_RISKS, CERTKEY, LASTCERTIFIEDCAMPAIGNNAME, ENTDESCRIPTION, User_TITLE, ENT_UPDATEUSER, ACC_AUDIT_TRAIL, ENT_SOD_RISK, ORPHAN_ACCOUNT_CHART, CERT_ENTITLEMENT_VALUEKEY, ENT2NAME, ENT_UPDATEDATE, ENT2CERTIFIED, CERT_ACCOUNTKEY, ACCCOMMENT, ACC_UPDATEDATE, ENT2_AUDIT_TRAIL, ACCESS, LASTCERTIFIEDDATE, ENTITLEMENT_VALUE, ACCSTATUS, INACTIVE_ACCOUNT, ENTISREASSIGNED, User_COSTCENTER, ACCOUNTNAME, RISK, ENTTYPE, Ent_STATUS, LASTCERTIFIED_CHART, ENTCOMMENT, ENTITLEMENT_VALUEKEY, ENDDATE, LASTCERTIFIEDUSER, LASTUSEDENDDATE, ENDPOINT, CERTIFICATIONNAME, CERT_ENTITLEMENT_VALUE2KEY, INACTIVE_ACCOUNT_CHART, ENT2_UPDATEDATE, SYSTEMNAME, ACC_UPDATEUSER, ENT2COMMENTS], columnNameAndType:[ENTSTATUS:BIGINT, Ent_ENTITLEMENT_GLOSSARY:LONGTEXT, ENT_AUDIT_TRAIL:LONGTEXT, ENTDISPLAYNAME:VARCHAR, User_DISPLAYNAME:VARCHAR, ACCOUNTISREASSIGNED:BIT, ONLYSTEP2:BIT, STATUS:BIGINT, CERTIFIED:VARCHAR, ENT2_UPDATEUSER:BIGINT, USERNAME:VARCHAR, ENT2STATUS:BIGINT, ENT2ISREASSIGNED:BIT, ROW_TYPE:BIGINT, ENTCRITICALITY:BIGINT, ACCOUNTCERTFIED:VARCHAR, USERSTATUS:BIGINT, ENTCERTIFIED:VARCHAR, ENT_RISKS:VARCHAR, CERTKEY:BIGINT, LASTCERTIFIEDCAMPAIGNNAME:VARCHAR, ENTDESCRIPTION:LONGTEXT, User_TITLE:VARCHAR, ENT_UPDATEUSER:BIGINT, ACC_AUDIT_TRAIL:LONGTEXT, ENT_SOD_RISK:VARCHAR, ORPHAN_ACCOUNT_CHART:VARCHAR, CERT_ENTITLEMENT_VALUEKEY:BIGINT, ENT2NAME:VARCHAR, ENT_UPDATEDATE:DATETIME, ENT2CERTIFIED:VARCHAR, CERT_ACCOUNTKEY:BIGINT, ACCCOMMENT:LONGTEXT, ACC_UPDATEDATE:DATETIME, ENT2_AUDIT_TRAIL:LONGTEXT, ACCESS:VARCHAR, LASTCERTIFIEDDATE:DATETIME, ENTITLEMENT_VALUE:VARCHAR, ACCSTATUS:VARCHAR, INACTIVE_ACCOUNT:VARCHAR, ENTISREASSIGNED:BIT, User_COSTCENTER:VARCHAR, ACCOUNTNAME:VARCHAR, RISK:BIGINT, ENTTYPE:VARCHAR, Ent_STATUS:BIGINT, LASTCERTIFIED_CHART:VARCHAR, ENTCOMMENT:LONGTEXT, ENTITLEMENT_VALUEKEY:BIGINT, ENDDATE:DATETIME, LASTCERTIFIEDUSER:VARCHAR, LASTUSEDENDDATE:DATETIME, ENDPOINT:VARCHAR, CERTIFICATIONNAME:VARCHAR, CERT_ENTITLEMENT_VALUE2KEY:BIGINT, INACTIVE_ACCOUNT_CHART:VARCHAR, ENT2_UPDATEDATE:DATETIME, SYSTEMNAME:VARCHAR, ACC_UPDATEUSER:BIGINT, ENT2COMMENTS:LONGTEXT], fieldTypeMap:[NULL:keyword, DATETIME:date, VARCHAR:text, BIGINT:long, BIT:boolean, INT:integer], indexAction:createMapping, isCallFromCampaign:true, doNotDate:null]" "2024-08-02T12:10:58.579+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","" "2024-08-02T12:10:58.718+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","Performing createMapping index.... entownercampaigncrm" "2024-08-02T12:10:58.718+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","Index createMapping Successfully....." "2024-08-02T12:10:58.980+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","threadCount = 10" "2024-08-02T12:10:58.980+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","Inside bulkRequestForBatchCountWithMultiThread() for adding Document Size .... 1979" "2024-08-02T12:10:58.980+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","unable to set batchsize from config due to For input string: "[:]".. setting to default." "2024-08-02T12:10:58.981+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","bulkrequestmaxsize =25000000" "2024-08-02T12:10:58.981+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","threadCount = 10" "2024-08-02T12:10:58.981+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","threadBatchCount = 500" "2024-08-02T12:10:58.981+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","START TOTAL RECORDS TO STORE IN ELASTIC 1979" "2024-08-02T12:10:58.992+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","batch size met. write to elastic" "2024-08-02T12:10:58.992+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","bulkrequestsize = 789251" "2024-08-02T12:10:58.993+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-1-qgpxz","DEBUG","Initiating bulkrequest call" "2024-08-02T12:10:58.993+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-1-qgpxz","DEBUG","Total Entries in bulkRequest = 500" "2024-08-02T12:10:59.003+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","batch size met. write to elastic" "2024-08-02T12:10:59.004+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","bulkrequestsize = 782043" "2024-08-02T12:10:59.004+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-2-qgpxz","DEBUG","Initiating bulkrequest call" "2024-08-02T12:10:59.004+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-2-qgpxz","DEBUG","Total Entries in bulkRequest = 500" "2024-08-02T12:10:59.015+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","batch size met. write to elastic" "2024-08-02T12:10:59.015+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","bulkrequestsize = 790526" "2024-08-02T12:10:59.016+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-3-qgpxz","DEBUG","Initiating bulkrequest call" "2024-08-02T12:10:59.016+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-3-qgpxz","DEBUG","Total Entries in bulkRequest = 500" "2024-08-02T12:10:59.026+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-4-qgpxz","DEBUG","Initiating bulkrequest call" "2024-08-02T12:10:59.027+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-4-qgpxz","DEBUG","Total Entries in bulkRequest = 479" "2024-08-02T12:10:59.113+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-1-qgpxz","DEBUG","bulkrequest call suceeded" "2024-08-02T12:10:59.113+00:00","ecm-worker","services.SaviyntElasticService","pool-3535-thread-1-qgpxz","DEBUG","Bulk operation done for data of size 500" "2024-08-02T12:10:59.133+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-2-qgpxz","DEBUG","bulkrequest call suceeded" "2024-08-02T12:10:59.133+00:00","ecm-worker","services.SaviyntElasticService","pool-3535-thread-2-qgpxz","DEBUG","Bulk operation done for data of size 500" "2024-08-02T12:10:59.148+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-4-qgpxz","DEBUG","bulkrequest call suceeded" "2024-08-02T12:10:59.149+00:00","ecm-worker","services.SaviyntElasticService","pool-3535-thread-4-qgpxz","DEBUG","Bulk operation done for data of size 479" "2024-08-02T12:10:59.150+00:00","ecm-worker","services.SaviyntElasticService$ProcessBulkRequest","pool-3535-thread-3-qgpxz","DEBUG","bulkrequest call suceeded" "2024-08-02T12:10:59.151+00:00","ecm-worker","services.SaviyntElasticService","pool-3535-thread-3-qgpxz","DEBUG","Bulk operation done for data of size 500" "2024-08-02T12:10:59.151+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","FINISH-TOTAL RECORDS TO STORE IN ELASTIC 1979" "2024-08-02T12:10:59.151+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","bulkResponse completed" "2024-08-02T12:10:59.151+00:00","ecm-worker","services.SaviyntElasticService","quartzScheduler_Worker-7-qgpxz","DEBUG","Total Records added by bulkRequest .. 1979" "2024-08-02T12:10:59.186+00:00","ecm-worker","campaigns.CampaignESService","quartzScheduler_Worker-7-qgpxz","DEBUG","====saved index====== total =1979" "2024-08-02T12:10:59.187+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","certEntColumns to show in response - [Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS]" "2024-08-02T12:10:59.187+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","userColumns to show in response - [User_DISPLAYNAME, User_TITLE, User_COSTCENTER]" "2024-08-02T12:10:59.187+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","certEnt2Columns to show in response - []" "2024-08-02T12:10:59.187+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","getEODetailedViewDataForCreateCampaign SELECT * FROM (| select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE, cev.description as ENTDESCRIPTION, | cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, cev.ENTITLEMENT_GLOSSARY as Ent_ENTITLEMENT_GLOSSARY, cev.STATUS as Ent_STATUS,| cevs.certified as ENTCERTIFIED, cevs.comments as ENTCOMMENT, cevs.ISREASSIGNED as ENTISREASSIGNED, cevs.AUDIT_TRAIL as ENT_AUDIT_TRAIL,| cevs.UPDATEUSER as ENT_UPDATEUSER, cevs.UPDATEDATE as ENT_UPDATEDATE,| NULL as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE, Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, | NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS, NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE,| NULL as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, NULL as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, NULL as ENT2_UPDATEDATE, | NULL as ENT2ISREASSIGNED, 0 as ROW_TYPE, cevs.onlyStep2 as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | left join cert_ent_values_status cevs on (cev.CERT_ENTITLEMENT_VALUEKEY=cevs.CERT_ENTITLEMENT_VALUEKEY)| left join certification cert on (cert.CERTKEY = cevs.CERTKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join Users u on (cev.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY in (1423) and et.ENDPOINTKEY=ep.ENDPOINTKEY and ep.securitysystemkey=ss.systemkey | and ep.status=1| Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS,cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, aae1s.lastusedenddate as LASTUSEDENDDATE, aae1s.enddate as ENDDATE,| aae1s.access as ACCESS, aae1s.LASTCERTIFIEDCAMPAIGNNAME as LASTCERTIFIEDCAMPAIGNNAME, aae1s.lastCertifiedUser as LASTCERTIFIEDUSER, | aae1s.lastCertifiedDate as LASTCERTIFIEDDATE, certacc.cert_accountkey as CERT_ACCOUNTKEY, certacc.name as ACCOUNTNAME,| ep.endpointname as ENDPOINT, aae1s.certified as ACCOUNTCERTFIED, certacc.status as ACCSTATUS, aae1s.comments as ACCCOMMENT, | aae1s.AUDIT_TRAIL as ACC_AUDIT_TRAIL, aae1s.UPDATEUSER as ACC_UPDATEUSER,aae1s.UPDATEDATE as ACC_UPDATEDATE, certusr.statuskey as USERSTATUS, | certusr.username as USERNAME, certusr.DISPLAYNAME as User_DISPLAYNAME, certusr.TITLE as User_TITLE, certusr.COSTCENTER as User_COSTCENTER, | NULL as CERT_ENTITLEMENT_VALUE2KEY, NULL as ENT2NAME, NULL as ENT2CERTIFIED, | NULL as ENT2STATUS, NULL as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, NULL as ENT2_UPDATEUSER, | NULL as ENT2_UPDATEDATE, NULL as ENT2ISREASSIGNED, 1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME,| CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS,| CASE| WHEN certacc.status='2' or upper(certacc.status)='INACTIVE' then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT,| CASE| WHEN aae1s.LASTCERTIFIEDDATE is not null and -DATEDIFF(aae1s.LASTCERTIFIEDDATE, now()) < 30 then 'YES'| ELSE NULL END AS LASTCERTIFIED_CHART, | CASE| WHEN certacc.updatedate is not null and -DATEDIFF(certacc.updatedate, now()) > 60 | and (certacc.status='2' or upper(certacc.status)='INACTIVE') then 'YES'| ELSE NULL END AS INACTIVE_ACCOUNT_CHART,| CASE | WHEN certusr.username is null or certusr.username ='' then 'YES'| ELSE NULL END as ORPHAN_ACCOUNT_CHART,| CASE| WHEN (aae1s.RISKS is not null and aae1s.RISKS !='') THEN 'YES'| ELSE 'NO'| END as ENT_SOD_RISK | from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ACCOUNT_ENTITLEMENT1_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join CERTIFICATION_ACCOUNT certacc on aae1s.CERT_ACCOUNTKEY=certacc.CERT_ACCOUNTKEY| left join CERTIFICATION_USER_ACCOUNT_STATUS cuas on certacc.CERT_ACCOUNTKEY=cuas.CERT_ACCOUNTKEY| left join CERTIFICATION_USER certusr on cuas.CERT_USERKEY=certusr.CERT_USERKEY| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| where cert.CAMPAIGNKEY in (1423) and certacc.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey and ep.status=1 | Union | select cert.certkey as CERTKEY, cert.cert_name as CERTIFICATIONNAME, cert.status as STATUS, cev.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUEKEY, | cev.status as ENTSTATUS, et.entitlementname as ENTTYPE, cev.ENTITLEMENT_VALUE as ENTITLEMENT_VALUE,| cev.description as ENTDESCRIPTION, cev.DISPLAYNAME as ENTDISPLAYNAME, cev.SYS_CRITICAL as ENTCRITICALITY, cev.RISK as RISK, cev.ENTITLEMENT_VALUEKEY as ENTITLEMENT_VALUEKEY, null as Ent_ENTITLEMENT_GLOSSARY, null as Ent_STATUS,| NULL as ENTCERTIFIED, NULL as ENTCOMMENT, NULL as ENTISREASSIGNED, NULL as ENT_AUDIT_TRAIL,| NULL as ENT_UPDATEUSER, NULL as ENT_UPDATEDATE,| aae1s.ISREASSIGNED as ACCOUNTISREASSIGNED, NULL as LASTUSEDENDDATE, NULL as ENDDATE, NULL as ACCESS, NULL as LASTCERTIFIEDCAMPAIGNNAME, | NULL as LASTCERTIFIEDUSER, NULL as LASTCERTIFIEDDATE,| Null as CERT_ACCOUNTKEY, NULL as ACCOUNTNAME, ep.endpointname as ENDPOINT, NULL as ACCOUNTCERTFIED, NULL as ACCSTATUS,| NULL as ACCCOMMENT, null as ACC_AUDIT_TRAIL, NULL as ACC_UPDATEUSER, NULL as ACC_UPDATEDATE, null as USERSTATUS, NULL as USERNAME, '' as User_DISPLAYNAME, '' as User_TITLE, '' as User_COSTCENTER,| cev2.CERT_ENTITLEMENT_VALUEKEY as CERT_ENTITLEMENT_VALUE2KEY, cev2.entitlement_value as ENT2NAME, aae1s.certified as ENT2CERTIFIED,| cev.status as ENT2STATUS, aae1s.comments as ENT2COMMENTS, aae1s.audit_trail as ENT2_AUDIT_TRAIL, aae1s.UPDATEUSER as ENT2_UPDATEUSER, | aae1s.UPDATEDATE as ENT2_UPDATEDATE, aae1s.ISREASSIGNED as ENT2ISREASSIGNED, -1 as ROW_TYPE, false as ONLYSTEP2, ss.SYSTEMNAME as SYSTEMNAME, | CASE| WHEN cev.risk is not null and cev.risk !='' and cev.risk >= 4 then 'YES'| WHEN cev.risk is null or cev.risk ='' or cev.risk < 4 THEN 'NO' END AS ENT_RISKS, NULL as INACTIVE_ACCOUNT,| NULL AS LASTCERTIFIED_CHART, NULL as INACTIVE_ACCOUNT_CHART, NULL as ORPHAN_ACCOUNT_CHART, NULL as ENT_SOD_RISK| from Endpoints ep,Securitysystems ss, certification_entitlement_value cev | inner join CERTIFICATION_ENTITLEMENT2_STATUS aae1s on (cev.CERT_ENTITLEMENT_VALUEKEY=aae1s.CERT_ENTITLEMENT_VALUEKEY)| left join certification_entitlement_value cev2 on (aae1s.CERT_ENTITLEMENT_VALUE2KEY=cev2.CERT_ENTITLEMENT_VALUEKEY)| left join ENTITLEMENT_TYPES et on (cev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY)| left join certification cert on (cert.CERTKEY = aae1s.CERTKEY) | left join Users u on (cev2.LASTREVIEWEDBY=u.USERKEY)| where cert.CAMPAIGNKEY = 1423 and et.endpointkey=ep.endpointkey and ep.securitysystemkey=ss.systemkey | and ep.status=1 ) AS resultData ORDER BY CERT_ENTITLEMENT_VALUEKEY" "2024-08-02T12:10:58.241+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Done Saving user data for entitlement2 " "2024-08-02T12:10:58.275+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","data populated for ENT_Owner_Campaign_CRM - xxx (Lakhitha Lakhitha)" "2024-08-02T12:10:52.240+00:00","ecm","auth.LoginController","http-nio-8080-exec-64-rsrjr","DEBUG","Default Setup" "2024-08-02T12:10:52.241+00:00","ecm","auth.LoginController","http-nio-8080-exec-64-rsrjr","DEBUG","idp = https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/" "2024-08-02T12:10:52.241+00:00","ecm","auth.LoginController","http-nio-8080-exec-64-rsrjr","DEBUG","URL TO SAML LOGIN2=/ECM/login/index?login=true&idp=https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/ JSESSIONID =F8BACA2B94505CD7D88FBB037BC31E8E" "2024-08-02T12:10:45.788+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Done Saving entitlement data for account status" "2024-08-02T12:10:45.789+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving entitlement data for entitlement2" "2024-08-02T12:10:45.789+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Done Saving entitlement data for entitlement2 " "2024-08-02T12:10:45.789+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving user data for entitlement2" "2024-08-02T12:10:35.771+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving cert account entitlement status for 100 to 140 of 140 entitlements" "2024-08-02T12:10:35.833+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Found account entitlement 1473" "2024-08-02T12:10:32.850+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Done Saving entitlement data for account " "2024-08-02T12:10:32.851+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Calculating SOD Risk for Account/Entitlement. " "2024-08-02T12:10:32.851+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","accountsIdAlreadyProcessed-[96257, 98305, 274436, 96256, 274437, 96259, 274438, 96261, 274432, 96260, 96263, 274435, 96262, 96264, 96266, 96269, 98317, 96268, 98316, 96275, 98323, 98327, 98326, 96281, 274460, 96280, 98328, 274461, 274462, 96282, 274463, 96284, 98335, 96286, 274468, 96288, 98338, 274464, 96292, 274465, 274466, 274467, 98345, 96297, 98347, 96299, 677920, 274479, 96301, 274474, 274475, 274484, 96304, 274485, 98355, 274486, 98354, 96306, 274487, 96309, 274480, 96308, 98359, 274482, 98361, 274493, 96314, 96317, 96316, 98364, 96319, 274491, 98366, 98369, 98368, 96320, 274501, 274502, 274496, 274498, 274499, 96329, 274508, 96328, 98379, 96330, 98381, 274504, 96335, 274506, 274507, 96337, 96336, 98384, 96339, 96341, 98389, 96340, 274513, 98391, 274514, 96342, 96345, 98393, 98395, 98394, 96349, 96348, 98399, 96350, 98401, 274534, 274535, 96354, 98402, 96357, 98404, 96359, 98407, 274531, 274540, 274542, 274543, 274536, 96364, 98412, 98415, 274538, 274539, 98414, 274548, 96369, 98416, 274549, 98419, 274550, 98418, 274551, 788607, 96372, 274545, 274546, 274547, 98425, 96376, 274558, 96378, 274559, 98426, 96381, 274552, 790640, 98428, 98431, 98432, 96387, 274566, 96386, 274567, 98437, 274560, 1026187, 96388, 98436, 274561, 788617, 1026186, 96391, 274562, 274563, 96393, 98441, 98440, 96395, 98443, 274568, 98445, 733317, 274571, 96401, 96403, 96402, 98450, 96405, 98453, 96404, 96407, 98454, 98457, 274588, 274589, 96411, 274590, 96410, 274591, 98461, 274584, 96412, 274585, 98463, 274586, 98462, 274587, 96416, 96419, 96418, 98466, 274592, 274593, 1331377, 274594, 274604, 1331388, 1331389, 96427, 274606, 1331390, 274607, 96429, 274601, 1331385, 274602, 96431, 96430, 98478, 274603, 274613, 98483, 96434, 98482, 274615, 96436, 98484, 98487, 98486, 274611, 96441, 274620, 96440, 274621, 98488, 96443, 274622, 96442, 274623, 98490, 96445, 98493, 274616, 96444, 98492, 96447, 98494, 274628, 98496, 274629, 98499, 96450, 96453, 1675485, 98503, 98502, 274636, 274637, 274639, 98506, 98508, 274633, 98510, 274635, 98512, 274646, 1331398, 274647, 98518, 1331404, 274653, 274654, 274649, 98527, 274650, 274651, 98529, 274660, 1331445, 98531, 274662, 274663, 98534, 98536, 98538, 98541, 98540, 98543, 98542, 274667, 1675497, 98545, 98547, 98546, 1331425, 274675, 1675492, 274682, 1331464, 1331465, 1331467, 1026350, 1026347, 1026346, 645423, 645422, 1026336, 1026359, 1218858, 1218857, 1026378, 1026377, 1026376, 1331534, 1331535, 1026415, 1026413, 500087, 135546, 500094, 500093, 135550, 500091, 135551, 500090, 500088, 135554, 135552, 135553, 500099, 135559, 500097, 135556, 500096, 135560, 135561, 135567, 135564, 135565, 135574, 135575, 135573, 135578, 135576, 135577, 135582, 135580, 135586, 135587, 135584, 135585, 135591, 135588, 135589, 135594, 135595, 135592, 135598, 135602, 135603, 135601, 135606, 135604, 135614, 135626, 135627, 135624, 135625, 135628, 135635, 94681, 135642, 94680, 135643, 135641, 94684, 135647, 135644, 135648, 94690, 135655, 135656, 135660, 94706, 94708, 94711, 94712, 94717, 1563158, 94727, 94729, 94731, 94742, 94744, 94755, 94761, 272941, 272942, 272943, 94765, 94766, 94769, 94768, 94773, 272945, 272947, 1219114, 94776, 272958, 94778, 272959, 1219118, 94780, 1219116, 1219117, 94785, 94787, 272960, 94789, 94788, 94791, 94797, 94796, 94798, 94805, 94807, 94809, 94808, 94811, 94810, 565844, 94812, 94815, 94820, 94828, 94831, 94842, 94847, 94853, 94852, 94854, 94857, 94864, 96915, 96914, 96917, 96916, 94874, 96925, 96924, 96927, 96926, 94880, 96928, 94882, 791215, 96933, 96938, 96942, 96945, 94899, 96946, 96949, 96948, 94902, 94905, 96952, 94906, 791216, 96956, 1219283, 1219286, 1219287, 94919, 1219284, 96969, 94923, 96971, 1219288, 1219289, 94922, 96973, 96972, 1219295, 94929, 96979, 96983, 96982, 96987, 96989, 96991, 96993, 96995, 1219313, 94949, 1219318, 1219319, 96999, 94951, 1219316, 94950, 97001, 1219322, 1219323, 97000, 94955, 97003, 1219321, 920290, 1219326, 94959, 97006, 1219325, 97009, 1219298, 1219299, 97011, 1219296, 1219297, 97010, 97013, 1219302, 94964, 94967, 1219300, 1219301, 1219307, 94971, 97018, 94973, 97021, 97020, 94975, 1219308, 94974, 94977, 97025, 94976, 791305, 97031, 791306, 94982, 97030, 94985, 97032, 94986, 1219359, 94991, 97039, 1219356, 94990, 97038, 97041, 1219331, 97040, 1219329, 920347, 1219335, 1219333, 1219338, 97048, 97051, 1219336, 97055, 97054, 920366, 95011, 920364, 920365, 97060, 1219383, 97063, 97066, 97071, 920353, 1219362, 97072, 791357, 1219361, 97074, 97077, 97078, 97083, 97085, 97086, 97089, 1219410, 1219411, 97093, 1219414, 1219415, 791371, 97097, 1219418, 791365, 1219417, 920384, 97104, 97107, 791384, 97110, 1219402, 97112, 791381, 1219403, 1219400, 791383, 1219401, 791376, 1219406, 1219407, 1841985, 1219404, 97118, 1219405, 97122, 97125, 97124, 97127, 97129, 97128, 791398, 920418, 97133, 97132, 97134, 566137, 97139, 566138, 791422, 97138, 791423, 97142, 791412, 97144, 791413, 791408, 97155, 97154, 791432, 791433, 791434, 791435, 97161, 97163, 97162, 791431, 1219486, 1217439, 1219487, 97167, 1217436, 97170, 791448, 791440, 97180, 97182, 97185, 97187, 97188, 97190, 97192, 97197, 97203, 1219488, 1219489, 97205, 97204, 97207, 97206, 97211, 791500, 791503, 97221, 97220, 97222, 97226, 1842128, 97232, 97238, 97241, 97245, 791505, 791506, 97246, 97249, 97253, 97255, 97259, 97260, 566264, 566265, 566268, 97269, 566270, 97276, 97279, 566262, 97278, 97281, 97280, 97283, 566282, 97282, 566283, 566284, 97286, 97288, 97291, 97290, 97293, 97292, 566296, 566297, 97299, 97298, 97301, 566301, 566292, 566294, 566313, 566315, 97317, 97321, 566304, 566305, 566306, 97323, 566308, 566309, 566310, 97329, 97334, 97339, 97338, 97340, 97343, 97344, 97347, 97351, 97350, 97356, 97359, 97361, 97362, 97367, 97368, 734289, 97370, 1858624, 97372, 97378, 97380, 679023, 97383, 97385, 97384, 97387, 97386, 97389, 97392, 97398, 679026, 97403, 97402, 97404, 97410, 97415, 97418, 679044, 97422, 97424, 679071, 97433, 97432, 97437, 679062, 679063, 97439, 97438, 97443, 97442, 126117, 126119, 126121, 97448, 126120, 126124, 97455, 126127, 97454, 126129, 126128, 97459, 126133, 126132, 95415, 95417, 126137, 126136, 126138, 95420, 95423, 1565864, 95428, 734425, 734429, 734443, 734456, 734455, 734473, 734472, 734479, 734477, 734470, 734468, 734483, 734482, 734480, 97581, 97580, 97582, 97585, 95539, 97589, 95540, 95542, 97590, 95544, 97592, 95547, 95549, 97597, 95548, 97596, 97598, 734539, 1566037, 95557, 97605, 97607, 95558, 95560, 97608, 95563, 95562, 95565, 97613, 97614, 95569, 97617, 95568, 193882, 95576, 95578, 193881, 193886, 95580, 193887, 95582, 95585, 95584, 193888, 95587, 97634, 193889, 95589, 95588, 95591, 193892, 97638, 193893, 97643, 95594, 95596, 97647, 95598, 95600, 95602, 97650, 97652, 97657, 95608, 97656, 193915, 97659, 97660, 193919, 97663, 95614, 97662, 193922, 95616, 97664, 193920, 193921, 95620, 95623, 95628, 95631, 95632, 95635, 95638, 193941, 95641, 95640, 95642, 124317, 193950, 193951, 95647, 124319, 193954, 95648, 193955, 193952, 95651, 95650, 193953, 193959, 95655, 193956, 193957, 501167, 501166, 193960, 95661, 501163, 95665, 501175, 95664, 501174, 501173, 501171, 501170, 501180, 95677, 95676, 501178, 501177, 95681, 501191, 501190, 501189, 501188, 1566164, 95685, 95684, 501186, 95687, 501185, 1762780, 95686, 95691, 95693, 501193, 95695, 95694, 95699, 95698, 95701, 95700, 95703, 95711, 95710, 95712, 501222, 95714, 501220, 95717, 194022, 501219, 501218, 194023, 95718, 194021, 501216, 501231, 95721, 194026, 501229, 194025, 501227, 501226, 501225, 501224, 95729, 501238, 501237, 501236, 194038, 95732, 501233, 194037, 95734, 95736, 194040, 501245, 194041, 501244, 95741, 501243, 95740, 95743, 95745, 501255, 501254, 95744, 95747, 501253, 95746, 501252, 95749, 501251, 95751, 95753, 501262, 501261, 95754, 501260, 501259, 95756, 501258, 95759, 501257, 501256, 95766, 95769, 95772, 95776, 95781, 194086, 194087, 194084, 95783, 194085, 564768, 95785, 1611313, 95787, 194089, 95791, 95793, 95792, 95797, 95799, 194106, 194107, 95802, 95805, 194108, 95806, 95811, 273990, 273991, 95812, 95815, 273986, 273987, 273998, 273992, 273993, 273994, 95822, 273995, 95825, 274004, 95826, 274007, 274000, 95828, 274001, 274003, 274012, 95832, 274013, 95834, 274015, 95837, 274009, 95839, 95838, 95845, 274016, 95844, 274017, 95847, 274018, 274019, 95848, 95851, 95850, 95853, 95855, 95857, 95856, 95863, 95862, 95873, 95872, 194179, 95874, 194182, 194180, 95878, 95881, 194186, 95880, 194187, 194184, 95882, 194185, 95885, 194191, 194194, 194195, 194192, 95893, 194199, 95895, 194196, 194202, 194200, 274078, 95898, 274079, 95901, 194205, 194210, 194211, 194208, 274086, 274081, 194212, 194213, 274083, 194216, 126643, 126645, 126647, 97985, 97987, 97988, 97990, 97999, 98001, 98000, 732889, 98006, 98009, 98011, 732880, 98012, 98015, 98017, 98020, 98026, 95980, 98031, 95983, 98034, 98036, 646897, 98045, 98046, 96001, 98048, 96002, 98052, 96007, 96006, 126728, 126731, 126730, 96013, 126733, 126735, 126734, 126737, 126736, 126739, 96018, 98066, 98069, 126741, 126740, 98071, 96023, 126743, 96025, 98075, 96027, 98074, 96029, 98078, 96030, 96032, 126752, 646957, 96036, 96042, 98090, 96045, 96046, 96051, 96054, 646963, 96058, 96061, 96060, 96063, 98111, 96064, 96067, 98115, 98114, 646986, 96070, 646977, 96072, 98120, 96075, 646978, 96077, 96081, 647001, 96080, 96085, 647004, 98135, 96089, 96088, 98136, 98139, 98141, 96092, 98140, 96095, 96094, 96097, 98145, 98144, 98147, 647018, 98148, 98151, 96105, 98152, 96106, 647010, 96111, 98158, 98161, 96119, 98169, 96120, 98170, 96125, 98172, 96127, 98174, 96133, 98181, 98183, 98182, 98186, 274312, 647065, 274327, 96149, 98196, 96151, 98201, 274332, 96152, 98200, 274333, 98203, 274334, 274335, 96157, 98205, 274328, 96156, 274329, 96159, 274330, 96158, 274331, 96160, 98208, 98210, 274337, 96167, 274338, 96168, 96177, 565181, 96183, 98231, 565183, 98233, 98232, 96184, 98234, 96192, 96197, 98244, 96199, 96198, 96200, 98248, 96203, 98251, 274382, 96202, 274376, 96204, 98252, 274377, 96207, 274378, 96206, 98254, 274388, 499671, 96208, 274390, 98258, 96210, 274391, 96213, 98261, 96212, 274386, 274387, 96217, 274397, 274398, 96218, 274399, 96221, 499675, 98269, 274392, 274393, 98271, 274394, 499673, 499672, 98273, 274404, 274406, 98274, 274407, 96229, 274400, 98276, 274401, 96231, 274402, 274403, 96233, 96232, 96235, 274414, 96234, 274415, 274408, 96236, 96239, 274410, 274411, 96241, 274422, 98293, 274416, 98292, 96247, 274419, 274428, 274429, 274430, 274431, 96250, 274424, 96252, 98300, 96255, 274426, 274427]" "2024-08-02T12:10:32.911+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","accEntRiskMap-[:]" "2024-08-02T12:10:32.911+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Done Calculating SOD Risk for Account/Entitlement." "2024-08-02T12:10:32.911+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving entitlement data for account status" "2024-08-02T12:10:32.913+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving cert account entitlement status for 0 to 100 of 140 entitlements" "2024-08-02T12:10:32.947+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Found account entitlement 811" "2024-08-02T12:10:31.042+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-49-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:4, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:0,1,2,3,4,5,6,7,8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:31.042+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-82-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:5, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:0,1,2,3,4,5,6,7,8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:28.235+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-73-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:3, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:28.237+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-81-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:2, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:27.100+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving cert account for 100 to 140 of 140 entitlements" "2024-08-02T12:10:25.600+00:00","ecm","rest.JwtService","http-nio-8080-exec-64-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:25.601+00:00","ecm","rest.JwtService","http-nio-8080-exec-64-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:25.613+00:00","ecm","rest.JwtService","http-nio-8080-exec-70-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:25.614+00:00","ecm","rest.JwtService","http-nio-8080-exec-70-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:25.621+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-64-rsrjr","DEBUG","Disable Audit Logging : true" "2024-08-02T12:10:25.622+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-64-rsrjr","DEBUG","Default max limit is set to 50" "2024-08-02T12:10:25.623+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-64-rsrjr","DEBUG","inside getEcmVersion" "2024-08-02T12:10:25.623+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-64-rsrjr","DEBUG","contentType - text/json" "2024-08-02T12:10:25.624+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-64-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:10:25.637+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-70-rsrjr","DEBUG","enter getNewUX" "2024-08-02T12:10:25.638+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-70-rsrjr","DEBUG","getNewUX is fetch from database" "2024-08-02T12:10:25.639+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-70-rsrjr","DEBUG","Exit getNewUX" "2024-08-02T12:10:25.640+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","contentType - application/json" "2024-08-02T12:10:25.641+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:10:25.727+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-79-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:1, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, action:listjson, controller:campaign, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:25.407+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving Cert entitlement value status 101 to 101 of 140" "2024-08-02T12:10:25.566+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Done Saving Cert entitlement value status" "2024-08-02T12:10:25.566+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving entitlement data for account " "2024-08-02T12:10:25.569+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving cert account for 0 to 100 of 140 entitlements" "2024-08-02T12:10:25.140+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-70-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [status:5, controller:campaign, action:list, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:25.142+00:00","ecm","campains.CampaignController","http-nio-8080-exec-70-rsrjr","DEBUG","Enter campaign list.." "2024-08-02T12:10:25.143+00:00","ecm","campains.CampaignController","http-nio-8080-exec-70-rsrjr","DEBUG","campUrlsAccessQry--_select url from Requestmap where description = 'CAMPAIGN' and ( 1=2 OR concat(',',configAttribute,',') like '%,ROLE_ADMIN,%' )" "2024-08-02T12:10:25.148+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","Certification List:: Total Campaign refresh Job Scheduled and Running 0" "2024-08-02T12:10:25.149+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","Certification List:: Campaign refresh Job already running false" "2024-08-02T12:10:25.149+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","Certification List:: Total Campaign refresh Job Manually and Running 0" "2024-08-02T12:10:25.150+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","Certification List Trigger CampaignProgressRefreshJob_xxx:: Status -1" "2024-08-02T12:10:25.150+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","Trigger CampaignProgressRefreshJob_xxx not exists. enabling progress refresh feature" "2024-08-02T12:10:25.152+00:00","ecm","campains.CampaignController","http-nio-8080-exec-70-rsrjr","DEBUG","Exit campaign list.." "2024-08-02T12:10:24.507+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","" "2024-08-02T12:10:24.507+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Account advanced query and status in ('Manually Provisioned','1') and accountkey in (select accountkey from user_accounts)" "2024-08-02T12:10:24.549+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","nullAndInactiveEoEntitlement Qry-select distinct ev from Entitlement_values ev where (ev.status!=2 or ev.status is null) AND ev.id in (:advEntitlementList)) and ev.entitlementtypekey.certifiable=1 and ev.entitlementtypekey.endpointkey in(-1,31)" "2024-08-02T12:10:24.708+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Total owner=140" "2024-08-02T12:10:24.708+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving Cert entitlement value" "2024-08-02T12:10:24.741+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving Cert entitlement value 1 to 102 of 140" "2024-08-02T12:10:24.929+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving Cert entitlement value 102 to 141 of 140" "2024-08-02T12:10:25.003+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving Cert entitlement value" "2024-08-02T12:10:25.003+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Saving Cert entitlement value status" "2024-08-02T12:10:25.013+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","saving Cert entitlement value status 0 to 101 of 140" "2024-08-02T12:10:24.178+00:00","ecm-worker","jobs.CampaignJob","quartzScheduler_Worker-7-qgpxz","DEBUG","Campaign Job Start" "2024-08-02T12:10:24.222+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","populating data for ENT_Owner_Campaign_CRM - xxx (Lakhitha Lakhitha)" "2024-08-02T12:10:24.222+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Start entitlement Certification for Certifier:-- 2429, CertName :- ENT_Owner_Campaign_CRM - xxx (Lakhitha Lakhitha)" "2024-08-02T12:10:24.222+00:00","ecm-worker","campaigns.CampaignEoAndRoService","quartzScheduler_Worker-7-qgpxz","DEBUG","Batch size configured for populateEntitlementOwnerCertification while populating data 100" "2024-08-02T12:10:22.375+00:00","ecm","auth.LoginController","http-nio-8080-exec-49-rsrjr","DEBUG","Default Setup" "2024-08-02T12:10:22.375+00:00","ecm","auth.LoginController","http-nio-8080-exec-49-rsrjr","DEBUG","idp = https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/" "2024-08-02T12:10:22.375+00:00","ecm","auth.LoginController","http-nio-8080-exec-49-rsrjr","DEBUG","URL TO SAML LOGIN2=/ECM/login/index?login=true&idp=https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/ JSESSIONID =D9630EF6275EC2584A599D8E919411D6" "2024-08-02T12:10:13.643+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-56-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:2, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:0,1,2,3,4,5,6,7,8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:13.653+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-79-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:3, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, status:0,1,2,3,4,5,6,7,8, controller:campaign, action:listjson, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:02.704+00:00","ecm","rest.JwtService","http-nio-8080-exec-70-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:02.705+00:00","ecm","rest.JwtService","http-nio-8080-exec-70-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:02.716+00:00","ecm","rest.JwtService","http-nio-8080-exec-56-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:02.716+00:00","ecm","rest.JwtService","http-nio-8080-exec-56-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:10:02.730+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-70-rsrjr","DEBUG","enter getNewUX" "2024-08-02T12:10:02.730+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-70-rsrjr","DEBUG","getNewUX is fetch from database" "2024-08-02T12:10:02.731+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-70-rsrjr","DEBUG","Exit getNewUX" "2024-08-02T12:10:02.732+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","contentType - application/json" "2024-08-02T12:10:02.733+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-70-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:10:02.737+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-56-rsrjr","DEBUG","Disable Audit Logging : true" "2024-08-02T12:10:02.739+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-56-rsrjr","DEBUG","Default max limit is set to 50" "2024-08-02T12:10:02.739+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-56-rsrjr","DEBUG","inside getEcmVersion" "2024-08-02T12:10:02.740+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-56-rsrjr","DEBUG","contentType - text/json" "2024-08-02T12:10:02.740+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-56-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:10:02.831+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-68-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [sEcho:1, iColumns:9, sColumns:, iDisplayStart:0, iDisplayLength:25, mDataProp_0:status, mDataProp_1:reassigned, mDataProp_2:campaignName, mDataProp_3:type, mDataProp_4:progress, mDataProp_5:campaignOwner, mDataProp_6:startDate, mDataProp_7:endDate, mDataProp_8:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, sSearch_3:, bRegex_3:false, bSearchable_3:true, sSearch_4:, bRegex_4:false, bSearchable_4:true, sSearch_5:, bRegex_5:false, bSearchable_5:true, sSearch_6:, bRegex_6:false, bSearchable_6:true, sSearch_7:, bRegex_7:false, bSearchable_7:true, sSearch_8:, bRegex_8:false, bSearchable_8:true, iSortCol_0:6, sSortDir_0:desc, iSortingCols:1, bSortable_0:true, bSortable_1:false, bSortable_2:true, bSortable_3:true, bSortable_4:false, bSortable_5:true, bSortable_6:true, bSortable_7:true, bSortable_8:false, action:listjson, controller:campaign, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:01.872+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-56-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [SYNCHRONIZER_TOKEN:04592e64-9464-4f51-a15d-04afaab397b6, SYNCHRONIZER_URI:/ECM/campaign/create, previewMode:, launchTypeForScheduleCampaign:, schedulelaterpopup:, schedulelater:, createNowVar:1, templateId:212, forTemplate:, campaign_name:ENT_Owner_Campaign_CRM, campaignDescription:, campaignType:1, campaignowner:1658, campaignTemplate:212, defaultconfig:0, campaign_selectOrCustomQryEpHidden:0, endpointids:31, daystoexpire:60, basedOn:3, showHideSOD:0, UMCONFIG_editemailtemplate:, UMCONFIG_defaultCertifierEo:2429, UMCONFIG_HIDEREASSIGNFORCERTENTOWNER:2, UMCONFIG_SHOWCONSULTFOROWNACCESS:1, UMCONFIG_ENABLE_ESIGNATURE_LOGIN:0, UMCONFIG_ENABLE_ESIGNATURE:0, UMCONFIG_NOOFLOGINRETRIES:, UMCONFIG_ALLOWSELFCERTIFICATIONEO:0, UMCONFIG_USERMANAGER.INGNORESTEP1:0, UMCONFIG_USERMANAGER:[INGNORESTEP1:0], UMCONFIG_DECOMMISIONACTIONENTOWNER:, ENTATTSHOWATT_Hidden:Ent_ENTITLEMENT_GLOSSARY,Ent_STATUS, UMCONFIG_ENTATTSHOWATT:[Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS], SHOWENTATTSTEP1LEFTFILTER_Hidden:Ent_ENTITLEMENT_GLOSSARY, UMCONFIG_SHOWENTATTSTEP1LEFTFILTER:Ent_ENTITLEMENT_GLOSSARY, UMCONFIG_ATTESTATION.ENTOWNER.FIRTSTSEP.SHOWCOMENTSPOPUP:CONSULT, UMCONFIG_ATTESTATION:[ENTOWNER.FIRTSTSEP.SHOWCOMENTSPOPUP:CONSULT, ENTOWNER:[FIRTSTSEP.SHOWCOMENTSPOPUP:CONSULT, FIRTSTSEP:[SHOWCOMENTSPOPUP:CONSULT], SECONDSTEP.ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], SECONDSTEP:[ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], ACCOUNT:[INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], INDIVIDUAL:[SHOWCOMENTSPOPUP:[NO, CONSULT]]]]], ENTITLEMENTLIST.STEP2.SHOWTAB:Account, ENTITLEMENTLIST:[STEP2.SHOWTAB:Account, STEP2:[SHOWTAB:Account]], ENTOWNER.SECONDSTEP.ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT]], UMCONFIG_hidedecommissionent:1, UMCONFIG_showhidedoesnotbelongent:0, UMCONFIG_SHOWREASSIGNPOPUP:0, UMCONFIG_UPDATEENTOWNERTABLE:0, UMCONFIG_ENDUSERMANAGER:0, UMCONFIG_ATTESTATION.ENTITLEMENTLIST.STEP2.SHOWTAB:Account, UMCONFIG_SHOWUPDATEBUTTONENTOWNER:0, UMCONFIG_CONDITIONALCERTIFYENTOWNER:1, UMCONFIG_ConditionallyCertifyInDaysLimit:364, ENTOWNERATTESTATIONUSERFIELDSTOSHOW_Hidden:User_DISPLAYNAME,User_TITLE,User_COSTCENTER, UMCONFIG_ENTOWNERATTESTATIONUSERFIELDSTOSHOW:[User_DISPLAYNAME, User_TITLE, User_COSTCENTER], SHOWUSERATTSTEP2LEFTFILTER_Hidden:User_DISPLAYNAME,User_TITLE,User_COSTCENTER, UMCONFIG_SHOWUSERATTSTEP2LEFTFILTER:[User_DISPLAYNAME, User_TITLE, User_COSTCENTER], CHILDENTATTSHOWATT_Hidden:, SHOWENTATTSTEP2LEFTFILTER_Hidden:, UMCONFIG_ATTESTATION.ENTOWNER.SECONDSTEP.ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], UMCONFIG_SHOWCARDFILTERSINSTEP2:1, UMCONFIG_CREATEREVOKETASKFORREVOKEDITEMONLOCKING:1, UMCONFIG_CREATEREVOKETASKFORREVOKEDITEMONEXPIRING:0, UMCONFIG_CREATEREVOKETASKFORUNRESPONDED:0, UMCONFIG_CREATETASKFORCERTIFIEDONEXPIRYEO:0, UMCONFIG_CREATEREVOKECHILDENTTASKONEXPIRY:0, UMCONFIG_CREATEREVOKECHILDENTTASKONLOCKING:0, UMCONFIG_CREATEREVOKECHILDENTTASKONUNRESPONDED:0, UMCONFIG_previewtemplate:, UMCONFIG_createtemplate:, UMCONFIG_completetemplate:, UMCONFIG_reassigntemplate:, UMCONFIG_reassigncompletetemplate:, UMCONFIG_discontinuetemplate:, UMCONFIG_reassignusertemplate:, UMCONFIG_expirytemplate:, UMCONFIG_revokeTaskEmailConfigurationEO:, UMCONFIG_NotifyCertifierEmail:, UMCONFIG_firstremindertomanagerinterval:, UMCONFIG_secondremindertomanagerinterval:, UMCONFIG_thirdremindertomanagerinterval:, UMCONFIG_fourthremindertomanagerinterval:, UMCONFIG_fifthremindertomanagerinterval:, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, mininginstance:, status:[, -1], bp:, customproperty4:, customproperty5:, customproperty6:, customproperty7:, customproperty8:, customproperty9:, customproperty10:, customproperty11:, customproperty12:, customproperty13:, customproperty14:, customproperty15:, customproperty16:, customproperty17:, customproperty18:, customproperty19:, customproperty20:, customproperty21:, customproperty22:, customproperty23:, customproperty24:, customproperty25:, customproperty26:, customproperty27:, customproperty28:, customproperty29:, customproperty30:, customproperty31:, customproperty32:, customproperty33:, customproperty34:, customproperty35:, customproperty36:, customproperty37:, customproperty38:, customproperty39:, customproperty40:, customproperty41:, customproperty42:, customproperty43:, customproperty44:, customproperty45:, customproperty46:, customproperty47:, customproperty48:, customproperty49:, customproperty50:, customproperty51:, customproperty52:, customproperty53:, customproperty54:, customproperty55:, customproperty56:, customproperty57:, customproperty58:, customproperty59:, customproperty60:, roleQuery:, usertype:0, alluser:1, campaign_enableadvanceconfig:on, UMCONFIG_campaign_enableadvanceconfig:1, userQry:, orgQuery:, accountQry:status in ('Manually Provisioned','1') and accountkey in (select accountkey from user_accounts), entQry:customproperty16 is null and entitlement_valuekey in (select entitlement_valuekey from account_entitlements1), roleQry:, accountEnt1Qry:, advoptioninpr:[{userqry:" "}____{entqry:"customproperty16 is null and entitlement_valuekey in (select entitlement_valuekey from account_entitlements1)"}____{orgquery:" "}____{accountqry:"status in ('Manually Provisioned','1') and accountkey in (select accountkey from user_accounts)"}____{accountEnt1Qry:" "}____{reassignUserQry:"select u from Users u where u.id in (Select userkey from User_savroles where rolekey=1 or rolekey=9)"}____{roleQry:" "}____{appOwnerMetaUserGroupQuery:" "}____{appOwnerMetaOrgQuery:" "}____{appOwnerMetaApplicationRoleQuery:" "}____{appOwnerMetaEntitlementQuery:" "}____{appOwnerMetaEntitlementValueQuery:" "}____{appOwnerMetaEntValApproversQuery:" "}____{appOwnerMetaRoleApproversQuery:" "}], reassignUserQry:select u from Users u where u.id in (Select userkey from User_savroles where rolekey=1 or rolekey=9), appOwnerMetaOrgQuery:, appOwnerMetaApplicationRoleQuery:, appOwnerMetaEntitlementQuery:, appOwnerMetaUserGroupQuery:, appOwnerMetaEntitlementValueQuery:, appOwnerMetaEntValApproversQuery:, appOwnerMetaRoleApproversQuery:, controller:campaign, action:save, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:false]" "2024-08-02T12:10:01.883+00:00","ecm","campaigns.CampaignService","http-nio-8080-exec-56-rsrjr","DEBUG","No Batch size configured for campaign" "2024-08-02T12:10:01.891+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","saveCertificationsUserManager for Campaign com.saviynt.ecm.campaign.domain.Campaign : 1423 - certifiersList= [] - [SYNCHRONIZER_TOKEN:04592e64-9464-4f51-a15d-04afaab397b6, SYNCHRONIZER_URI:/ECM/campaign/create, previewMode:, launchTypeForScheduleCampaign:, schedulelaterpopup:, schedulelater:, createNowVar:1, templateId:212, forTemplate:, campaign_name:ENT_Owner_Campaign_CRM, campaignDescription:, campaignType:1, campaignowner:1658, campaignTemplate:212, defaultconfig:0, campaign_selectOrCustomQryEpHidden:0, endpointids:31, daystoexpire:60, basedOn:3, showHideSOD:0, UMCONFIG_editemailtemplate:, UMCONFIG_defaultCertifierEo:2429, UMCONFIG_HIDEREASSIGNFORCERTENTOWNER:2, UMCONFIG_SHOWCONSULTFOROWNACCESS:1, UMCONFIG_ENABLE_ESIGNATURE_LOGIN:0, UMCONFIG_ENABLE_ESIGNATURE:0, UMCONFIG_NOOFLOGINRETRIES:, UMCONFIG_ALLOWSELFCERTIFICATIONEO:0, UMCONFIG_USERMANAGER.INGNORESTEP1:0, UMCONFIG_USERMANAGER:[INGNORESTEP1:0], UMCONFIG_DECOMMISIONACTIONENTOWNER:, ENTATTSHOWATT_Hidden:Ent_ENTITLEMENT_GLOSSARY,Ent_STATUS, UMCONFIG_ENTATTSHOWATT:[Ent_ENTITLEMENT_GLOSSARY, Ent_STATUS], SHOWENTATTSTEP1LEFTFILTER_Hidden:Ent_ENTITLEMENT_GLOSSARY, UMCONFIG_SHOWENTATTSTEP1LEFTFILTER:Ent_ENTITLEMENT_GLOSSARY, UMCONFIG_ATTESTATION.ENTOWNER.FIRTSTSEP.SHOWCOMENTSPOPUP:CONSULT, UMCONFIG_ATTESTATION:[ENTOWNER.FIRTSTSEP.SHOWCOMENTSPOPUP:CONSULT, ENTOWNER:[FIRTSTSEP.SHOWCOMENTSPOPUP:CONSULT, FIRTSTSEP:[SHOWCOMENTSPOPUP:CONSULT], SECONDSTEP.ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], SECONDSTEP:[ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], ACCOUNT:[INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], INDIVIDUAL:[SHOWCOMENTSPOPUP:[NO, CONSULT]]]]], ENTITLEMENTLIST.STEP2.SHOWTAB:Account, ENTITLEMENTLIST:[STEP2.SHOWTAB:Account, STEP2:[SHOWTAB:Account]], ENTOWNER.SECONDSTEP.ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT]], UMCONFIG_hidedecommissionent:1, UMCONFIG_showhidedoesnotbelongent:0, UMCONFIG_SHOWREASSIGNPOPUP:0, UMCONFIG_UPDATEENTOWNERTABLE:0, UMCONFIG_ENDUSERMANAGER:0, UMCONFIG_ATTESTATION.ENTITLEMENTLIST.STEP2.SHOWTAB:Account, UMCONFIG_SHOWUPDATEBUTTONENTOWNER:0, UMCONFIG_CONDITIONALCERTIFYENTOWNER:1, UMCONFIG_ConditionallyCertifyInDaysLimit:364, ENTOWNERATTESTATIONUSERFIELDSTOSHOW_Hidden:User_DISPLAYNAME,User_TITLE,User_COSTCENTER, UMCONFIG_ENTOWNERATTESTATIONUSERFIELDSTOSHOW:[User_DISPLAYNAME, User_TITLE, User_COSTCENTER], SHOWUSERATTSTEP2LEFTFILTER_Hidden:User_DISPLAYNAME,User_TITLE,User_COSTCENTER, UMCONFIG_SHOWUSERATTSTEP2LEFTFILTER:[User_DISPLAYNAME, User_TITLE, User_COSTCENTER], CHILDENTATTSHOWATT_Hidden:, SHOWENTATTSTEP2LEFTFILTER_Hidden:, UMCONFIG_ATTESTATION.ENTOWNER.SECONDSTEP.ACCOUNT.INDIVIDUAL.SHOWCOMENTSPOPUP:[NO, CONSULT], UMCONFIG_SHOWCARDFILTERSINSTEP2:1, UMCONFIG_CREATEREVOKETASKFORREVOKEDITEMONLOCKING:1, UMCONFIG_CREATEREVOKETASKFORREVOKEDITEMONEXPIRING:0, UMCONFIG_CREATEREVOKETASKFORUNRESPONDED:0, UMCONFIG_CREATETASKFORCERTIFIEDONEXPIRYEO:0, UMCONFIG_CREATEREVOKECHILDENTTASKONEXPIRY:0, UMCONFIG_CREATEREVOKECHILDENTTASKONLOCKING:0, UMCONFIG_CREATEREVOKECHILDENTTASKONUNRESPONDED:0, UMCONFIG_previewtemplate:, UMCONFIG_createtemplate:, UMCONFIG_completetemplate:, UMCONFIG_reassigntemplate:, UMCONFIG_reassigncompletetemplate:, UMCONFIG_discontinuetemplate:, UMCONFIG_reassignusertemplate:, UMCONFIG_expirytemplate:, UMCONFIG_revokeTaskEmailConfigurationEO:, UMCONFIG_NotifyCertifierEmail:, UMCONFIG_firstremindertomanagerinterval:, UMCONFIG_secondremindertomanagerinterval:, UMCONFIG_thirdremindertomanagerinterval:, UMCONFIG_fourthremindertomanagerinterval:, UMCONFIG_fifthremindertomanagerinterval:, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, mininginstance:, status:[, -1], bp:, customproperty4:, customproperty5:, customproperty6:, customproperty7:, customproperty8:, customproperty9:, customproperty10:, customproperty11:, customproperty12:, customproperty13:, customproperty14:, customproperty15:, customproperty16:, customproperty17:, customproperty18:, customproperty19:, customproperty20:, customproperty21:, customproperty22:, customproperty23:, customproperty24:, customproperty25:, customproperty26:, customproperty27:, customproperty28:, customproperty29:, customproperty30:, customproperty31:, customproperty32:, customproperty33:, customproperty34:, customproperty35:, customproperty36:, customproperty37:, customproperty38:, customproperty39:, customproperty40:, customproperty41:, customproperty42:, customproperty43:, customproperty44:, customproperty45:, customproperty46:, customproperty47:, customproperty48:, customproperty49:, customproperty50:, customproperty51:, customproperty52:, customproperty53:, customproperty54:, customproperty55:, customproperty56:, customproperty57:, customproperty58:, customproperty59:, customproperty60:, roleQuery:, usertype:0, alluser:1, campaign_enableadvanceconfig:on, UMCONFIG_campaign_enableadvanceconfig:1, userQry:, orgQuery:, accountQry:status in ('Manually Provisioned','1') and accountkey in (select accountkey from user_accounts), entQry:customproperty16 is null and entitlement_valuekey in (select entitlement_valuekey from account_entitlements1), roleQry:, accountEnt1Qry:, advoptioninpr:[{userqry:" "}____{entqry:"customproperty16 is null and entitlement_valuekey in (select entitlement_valuekey from account_entitlements1)"}____{orgquery:" "}____{accountqry:"status in ('Manually Provisioned','1') and accountkey in (select accountkey from user_accounts)"}____{accountEnt1Qry:" "}____{reassignUserQry:"select u from Users u where u.id in (Select userkey from User_savroles where rolekey=1 or rolekey=9)"}____{roleQry:" "}____{appOwnerMetaUserGroupQuery:" "}____{appOwnerMetaOrgQuery:" "}____{appOwnerMetaApplicationRoleQuery:" "}____{appOwnerMetaEntitlementQuery:" "}____{appOwnerMetaEntitlementValueQuery:" "}____{appOwnerMetaEntValApproversQuery:" "}____{appOwnerMetaRoleApproversQuery:" "}], reassignUserQry:select u from Users u where u.id in (Select userkey from User_savroles where rolekey=1 or rolekey=9), appOwnerMetaOrgQuery:, appOwnerMetaApplicationRoleQuery:, appOwnerMetaEntitlementQuery:, appOwnerMetaUserGroupQuery:, appOwnerMetaEntitlementValueQuery:, appOwnerMetaEntValApproversQuery:, appOwnerMetaRoleApproversQuery:, controller:campaign, action:save, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:false, UPDATEUSER:xxx, startdate:08-02-2024 12:10:01, enddate:10-01-2024 12:10:01, certifiersInSession:null, setUsersValueinSession:null]" "2024-08-02T12:10:01.892+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","queryToGetEntOwner---select DISTINCT eo.userkey as OWNER FROM Entitlement_owners eo WHERE 1=1 and eo.rank=:rank and eo.userkey.statuskey=:statuskey" "2024-08-02T12:10:01.920+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","Certifiers qry- select DISTINCT eo.userkey as OWNER FROM Entitlement_owners eo WHERE 1=1 and eo.rank=:rank and eo.userkey.statuskey=:statuskey and eo.entitlement_valuekey in(| select ev.id from Entitlement_values ev, Entitlement_types et,Endpoints ep| where (ev.status!=2 or ev.status is null) AND ev.entitlementtypekey = et.id and et.endpointkey = ep.id and et.certifiable=true| and ep.id in (:endpts) ) " "2024-08-02T12:10:01.924+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","Certifiers List= 0" "2024-08-02T12:10:01.926+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","Certifiers List= []" "2024-08-02T12:10:01.931+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","Saving Certification For Certifiers [xxx]" "2024-08-02T12:10:01.931+00:00","ecm","campaigns.CampaignService","http-nio-8080-exec-56-rsrjr","DEBUG","No Batch size configured for campaign" "2024-08-02T12:10:01.932+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","Batch size configured for saving certification entitlement owner 100" "2024-08-02T12:10:01.935+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","usersList = [xxx]" "2024-08-02T12:10:02.054+00:00","ecm","services.SaviyntElasticService","http-nio-8080-exec-56-rsrjr","DEBUG","reinitializeClient true" "2024-08-02T12:10:02.103+00:00","ecm","campaigns.CampaignEoAndRoService","http-nio-8080-exec-56-rsrjr","DEBUG","Certification saved" "2024-08-02T12:10:02.186+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-66-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [status:5, controller:campaign, action:list, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:true]" "2024-08-02T12:10:02.188+00:00","ecm","campains.CampaignController","http-nio-8080-exec-66-rsrjr","DEBUG","Enter campaign list.." "2024-08-02T12:10:02.189+00:00","ecm","campains.CampaignController","http-nio-8080-exec-66-rsrjr","DEBUG","campUrlsAccessQry--_select url from Requestmap where description = 'CAMPAIGN' and ( 1=2 OR concat(',',configAttribute,',') like '%,ROLE_ADMIN,%' )" "2024-08-02T12:10:02.194+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List:: Total Campaign refresh Job Scheduled and Running 0" "2024-08-02T12:10:02.195+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List:: Campaign refresh Job already running false" "2024-08-02T12:10:02.195+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List:: Total Campaign refresh Job Manually and Running 0" "2024-08-02T12:10:02.196+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Certification List Trigger CampaignProgressRefreshJob_xxx:: Status -1" "2024-08-02T12:10:02.196+00:00","ecm","campaigns.CampaignUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","Trigger CampaignProgressRefreshJob_xxx not exists. enabling progress refresh feature" "2024-08-02T12:10:02.198+00:00","ecm","campains.CampaignController","http-nio-8080-exec-66-rsrjr","DEBUG","Exit campaign list.." "2024-08-02T12:10:00.021+00:00","ecm-worker","jobs.EmailHistoryJob","quartzScheduler_Worker-4-qgpxz","DEBUG","Start cronEmailHistoryJob" "2024-08-02T12:10:00.024+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","EmailHistoryService: Inside Execute" "2024-08-02T12:10:00.050+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","Email History Service start @ " "2024-08-02T12:10:00.050+00:00","ecm-worker","services.ImportUtilityService","quartzScheduler_Worker-4-qgpxz","DEBUG","Setting Batch Size from config = 1000" "2024-08-02T12:10:00.060+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","USE_MULTI_THREADING_EMAIL_HISTORY_JOB=1" "2024-08-02T12:10:00.060+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","sendEmailUsingThreads =true" "2024-08-02T12:10:00.060+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","emailNewSessionFlag true" "2024-08-02T12:10:00.064+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","Fetching data to be insert for EMAILHISTORY_ARCHIVE Table checkpoint 1 - | SELECT EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,| CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,| TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS FROM EMAILHISTORYPROCESS where status not in (5,15,404) | " "2024-08-02T12:10:00.064+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","Inserting sql for EMAILHISTORY_ARCHIVE Table checkpoint 1 - INSERT INTO EMAILHISTORY_ARCHIVE (EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) " "2024-08-02T12:10:00.065+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","Inserting into EMAILHISTORY to retry emails with status 5,15,404 - | INSERT INTO EMAILHISTORY(ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,| JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS)| SELECT ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,| JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS | FROM EMAILHISTORYPROCESS where status in (5,15,404)| " "2024-08-02T12:10:00.066+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","Cleaning EmailHistoryProcess - removing old entries - DELETE FROM EMAILHISTORYPROCESS " "2024-08-02T12:10:00.071+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","total records in emailhistory table = 0" "2024-08-02T12:10:00.083+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-4-qgpxz","DEBUG","Email History Service END" "2024-08-02T12:10:00.083+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-4-qgpxz","DEBUG","inside executeFailedEmails" "2024-08-02T12:10:00.083+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-4-qgpxz","DEBUG","Start of moveEmailsToArchiveWithoutToCCBcc" "2024-08-02T12:10:00.084+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-4-qgpxz","DEBUG","total time taken to finish moveEmailsToArchiveWithoutToCCBcc in miliseconds 1" "2024-08-02T12:10:00.084+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-4-qgpxz","DEBUG","end of moveEmailsToArchiveWithoutToCCBcc" "2024-08-02T12:10:00.085+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-4-qgpxz","DEBUG","Exit executeFailedEmails" "2024-08-02T12:10:00.085+00:00","ecm-worker","jobs.EmailHistoryJob","quartzScheduler_Worker-4-qgpxz","DEBUG","End cronEmailHistoryJob" "2024-08-02T12:09:52.240+00:00","ecm","auth.LoginController","http-nio-8080-exec-70-rsrjr","DEBUG","Default Setup" "2024-08-02T12:09:52.241+00:00","ecm","auth.LoginController","http-nio-8080-exec-70-rsrjr","DEBUG","idp = https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/" "2024-08-02T12:09:52.241+00:00","ecm","auth.LoginController","http-nio-8080-exec-70-rsrjr","DEBUG","URL TO SAML LOGIN2=/ECM/login/index?login=true&idp=https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/ JSESSIONID =DF40AD82DA528F9EB8240681FD0AF632" "2024-08-02T12:09:48.560+00:00","ecm","domain.EcmConfigController","http-nio-8080-exec-81-rsrjr","INFO","Initating process to fetch configuration for category: Campaign Config Entitlement Owner" "2024-08-02T12:09:48.560+00:00","ecm","domain.EcmConfigController","http-nio-8080-exec-81-rsrjr","INFO","Initiating to fetch list of config for category: Campaign Config Entitlement Owner" "2024-08-02T12:09:48.564+00:00","ecm","domain.EcmConfigController","http-nio-8080-exec-81-rsrjr","INFO","Total number of configuration found is: 59" "2024-08-02T12:09:48.599+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-81-rsrjr","INFO","Total transport configs found is: 0" "2024-08-02T12:09:48.619+00:00","ecm","domain.EcmConfigController","http-nio-8080-exec-81-rsrjr","INFO","Auditing process completed for Global Configuration of action: generalConfiguration" "2024-08-02T12:09:48.298+00:00","ecm","rest.JwtService","http-nio-8080-exec-79-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:48.299+00:00","ecm","rest.JwtService","http-nio-8080-exec-79-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:48.317+00:00","ecm","rest.JwtService","http-nio-8080-exec-64-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:48.318+00:00","ecm","rest.JwtService","http-nio-8080-exec-64-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:48.325+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-79-rsrjr","DEBUG","Disable Audit Logging : true" "2024-08-02T12:09:48.327+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-79-rsrjr","DEBUG","Default max limit is set to 50" "2024-08-02T12:09:48.327+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-79-rsrjr","DEBUG","inside getEcmVersion" "2024-08-02T12:09:48.327+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-79-rsrjr","DEBUG","contentType - text/json" "2024-08-02T12:09:48.328+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-79-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:09:48.343+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-64-rsrjr","DEBUG","enter getNewUX" "2024-08-02T12:09:48.344+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-64-rsrjr","DEBUG","getNewUX is fetch from database" "2024-08-02T12:09:48.345+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-64-rsrjr","DEBUG","Exit getNewUX" "2024-08-02T12:09:48.346+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-64-rsrjr","DEBUG","contentType - application/json" "2024-08-02T12:09:48.347+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-64-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:09:47.366+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-73-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [template:212, controller:campaign, action:create, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:false]" "2024-08-02T12:09:22.337+00:00","ecm","rest.JwtService","http-nio-8080-exec-80-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:22.339+00:00","ecm","rest.JwtService","http-nio-8080-exec-80-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:22.341+00:00","ecm","rest.JwtService","http-nio-8080-exec-66-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:22.342+00:00","ecm","rest.JwtService","http-nio-8080-exec-66-rsrjr","DEBUG","Parsed an HMAC signed JWT" "2024-08-02T12:09:22.359+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-80-rsrjr","DEBUG","Disable Audit Logging : true" "2024-08-02T12:09:22.367+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-80-rsrjr","DEBUG","Default max limit is set to 50" "2024-08-02T12:09:22.368+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-80-rsrjr","DEBUG","inside getEcmVersion" "2024-08-02T12:09:22.368+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-80-rsrjr","DEBUG","contentType - text/json" "2024-08-02T12:09:22.369+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-80-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:09:22.383+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-66-rsrjr","DEBUG","enter getNewUX" "2024-08-02T12:09:22.383+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-66-rsrjr","DEBUG","getNewUX is fetch from database" "2024-08-02T12:09:22.384+00:00","ecm","campaignV2.CampaignUtilityV2Service","http-nio-8080-exec-66-rsrjr","DEBUG","Exit getNewUX" "2024-08-02T12:09:22.385+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","contentType - application/json" "2024-08-02T12:09:22.386+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-66-rsrjr","DEBUG","contentTypeFromConfig - application/json" "2024-08-02T12:09:22.286+00:00","ecm","auth.LoginController","http-nio-8080-exec-24-nfjcl","DEBUG","Default Setup" "2024-08-02T12:09:22.287+00:00","ecm","auth.LoginController","http-nio-8080-exec-24-nfjcl","DEBUG","idp = https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/" "2024-08-02T12:09:22.287+00:00","ecm","auth.LoginController","http-nio-8080-exec-24-nfjcl","DEBUG","URL TO SAML LOGIN2=/ECM/login/index?login=true&idp=https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/ JSESSIONID =B79C85B6840F5CE1DB12466A7C93AA3F" "2024-08-02T12:09:21.273+00:00","ecm","campaigns.CampaignValidationService","http-nio-8080-exec-81-rsrjr","DEBUG","checkIfLoggedInUserCanAccessCampaign [controller:campaign, action:create, campaignAccessableUrlSet:[/certification/discontinue, /campaignOrganization/**, /campaign/create, /campaignAOMetaData/**, /campaignTemplate/**, /certifications/v2/**, /stepone/export, /firststep/actions, /campaignTemplate/schedulecampaign, /secondstep/actions, /campaignTemplate/campaignTemplate_History, /campaign/reconfigure, /campaign/discontinue, /certificationlist/export, /campaign/viewAllCampCertAccess, /certification/export, /campaignlist/export, /campaign/summary, /secondstep/export, /certification/**, /campaignTemplate/campaignTemplateList, /campaignEoAndRo/**, /campaignTemplate/deleteTemplate], users:xxx, allowReadOnlyAuditorAccess:false]" "2024-08-02T12:09:00.023+00:00","ecm-worker","jobs.EmailHistoryJob","quartzScheduler_Worker-6-qgpxz","DEBUG","Start cronEmailHistoryJob" "2024-08-02T12:09:00.025+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","EmailHistoryService: Inside Execute" "2024-08-02T12:09:00.050+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","Email History Service start @ " "2024-08-02T12:09:00.051+00:00","ecm-worker","services.ImportUtilityService","quartzScheduler_Worker-6-qgpxz","DEBUG","Setting Batch Size from config = 1000" "2024-08-02T12:09:00.062+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","USE_MULTI_THREADING_EMAIL_HISTORY_JOB=1" "2024-08-02T12:09:00.062+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","sendEmailUsingThreads =true" "2024-08-02T12:09:00.062+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","emailNewSessionFlag true" "2024-08-02T12:09:00.065+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","Fetching data to be insert for EMAILHISTORY_ARCHIVE Table checkpoint 1 - | SELECT EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,| CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,| TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS FROM EMAILHISTORYPROCESS where status not in (5,15,404) | " "2024-08-02T12:09:00.066+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","Inserting sql for EMAILHISTORY_ARCHIVE Table checkpoint 1 - INSERT INTO EMAILHISTORY_ARCHIVE (EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) " "2024-08-02T12:09:00.067+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","Inserting into EMAILHISTORY to retry emails with status 5,15,404 - | INSERT INTO EMAILHISTORY(ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,| JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS)| SELECT ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,| JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS | FROM EMAILHISTORYPROCESS where status in (5,15,404)| " "2024-08-02T12:09:00.068+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","Cleaning EmailHistoryProcess - removing old entries - DELETE FROM EMAILHISTORYPROCESS " "2024-08-02T12:09:00.072+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","total records in emailhistory table = 0" "2024-08-02T12:09:00.086+00:00","ecm-worker","mail.EmailHistoryService","quartzScheduler_Worker-6-qgpxz","DEBUG","Email History Service END" "2024-08-02T12:09:00.086+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-6-qgpxz","DEBUG","inside executeFailedEmails" "2024-08-02T12:09:00.086+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-6-qgpxz","DEBUG","Start of moveEmailsToArchiveWithoutToCCBcc" "2024-08-02T12:09:00.087+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-6-qgpxz","DEBUG","total time taken to finish moveEmailsToArchiveWithoutToCCBcc in miliseconds 1" "2024-08-02T12:09:00.087+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-6-qgpxz","DEBUG","end of moveEmailsToArchiveWithoutToCCBcc" "2024-08-02T12:09:00.088+00:00","ecm-worker","services.EmailerService","quartzScheduler_Worker-6-qgpxz","DEBUG","Exit executeFailedEmails" "2024-08-02T12:09:00.088+00:00","ecm-worker","jobs.EmailHistoryJob","quartzScheduler_Worker-6-qgpxz","DEBUG","End cronEmailHistoryJob" "2024-08-02T12:08:52.416+00:00","ecm","auth.LoginController","http-nio-8080-exec-56-rsrjr","DEBUG","Default Setup" "2024-08-02T12:08:52.416+00:00","ecm","auth.LoginController","http-nio-8080-exec-56-rsrjr","DEBUG","idp = https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/" "2024-08-02T12:08:52.417+00:00","ecm","auth.LoginController","http-nio-8080-exec-56-rsrjr","DEBUG","URL TO SAML LOGIN2=/ECM/login/index?login=true&idp=https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/ JSESSIONID =1341D846AEE76D34D58566737712C7C1" "2024-08-02T12:08:22.383+00:00","ecm","auth.LoginController","http-nio-8080-exec-27-nfjcl","DEBUG","Default Setup" "2024-08-02T12:08:22.384+00:00","ecm","auth.LoginController","http-nio-8080-exec-27-nfjcl","DEBUG","idp = https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/" "2024-08-02T12:08:22.384+00:00","ecm","auth.LoginController","http-nio-8080-exec-27-nfjcl","DEBUG","URL TO SAML LOGIN2=/ECM/login/index?login=true&idp=https://sts.windows.net/4b1c6b54-4031-481e-b9c8-9000b4e3b2c2/ JSESSIONID =4618FB268BDA95B98DB723BE49B1CAA6"