"Service Name","Date Timestamp","Message" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,216 [quartzScheduler_Worker-7] DEBUG jobs.EmailHistoryJob - Start cronEmailHistoryJob\n","stream":"stdout","time":"2022-12-07T13:37:58.216624233Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,240 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Email History Service start @ \n","stream":"stdout","time":"2022-12-07T13:37:58.241016643Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,240 [quartzScheduler_Worker-7] DEBUG services.ImportUtilityService - Setting Batch Size from config = 500\n","stream":"stdout","time":"2022-12-07T13:37:58.241054201Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,247 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - USE_MULTI_THREADING_EMAIL_HISTORY_JOB=1\n","stream":"stdout","time":"2022-12-07T13:37:58.247866129Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,247 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - sendEmailUsingThreads =true\n","stream":"stdout","time":"2022-12-07T13:37:58.247892961Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,249 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Archiving EmailHistory Table - \n","stream":"stdout","time":"2022-12-07T13:37:58.249784194Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" INSERT INTO EMAILHISTORY_ARCHIVE(EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,\n","stream":"stdout","time":"2022-12-07T13:37:58.249803616Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,TOADDRESS,UUID,BCCADDRESS)\n","stream":"stdout","time":"2022-12-07T13:37:58.24980886Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" SELECT EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,\n","stream":"stdout","time":"2022-12-07T13:37:58.249812082Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,\n","stream":"stdout","time":"2022-12-07T13:37:58.249813717Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" TOADDRESS,UUID,BCCADDRESS FROM EMAILHISTORYPROCESS where status not in (5,15)\n","stream":"stdout","time":"2022-12-07T13:37:58.249818383Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" \n","stream":"stdout","time":"2022-12-07T13:37:58.249822744Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,250 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Inserting into EMAILHISTORY to retry emails with status 5,15 - \n","stream":"stdout","time":"2022-12-07T13:37:58.25014237Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" INSERT INTO EMAILHISTORY(ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,\n","stream":"stdout","time":"2022-12-07T13:37:58.250156588Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS)\n","stream":"stdout","time":"2022-12-07T13:37:58.250164265Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" SELECT ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,\n","stream":"stdout","time":"2022-12-07T13:37:58.250167236Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS \n","stream":"stdout","time":"2022-12-07T13:37:58.250169977Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" FROM EMAILHISTORYPROCESS where status in (5,15)\n","stream":"stdout","time":"2022-12-07T13:37:58.250174633Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" \n","stream":"stdout","time":"2022-12-07T13:37:58.250178846Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,250 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Cleaning EmailHistoryProcess - removing old entries - DELETE FROM EMAILHISTORYPROCESS \n","stream":"stdout","time":"2022-12-07T13:37:58.250421195Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,251 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - total records in emailhistory table = 2\n","stream":"stdout","time":"2022-12-07T13:37:58.251200628Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,251 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Migrating EmailHistory - \n","stream":"stdout","time":"2022-12-07T13:37:58.251215817Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" INSERT INTO EMAILHISTORYPROCESS(ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,OLDEMAILHISTORYKEY,BCCADDRESS)\n","stream":"stdout","time":"2022-12-07T13:37:58.251226483Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" SELECT ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,EMAILHISTORYKEY,BCCADDRESS FROM EMAILHISTORY LIMIT 500\n","stream":"stdout","time":"2022-12-07T13:37:58.251231415Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" \n","stream":"stdout","time":"2022-12-07T13:37:58.251235849Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,254 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - updateqry = UPDATE EMAILHISTORYPROCESS EH , REQUEST_ACCESS REQACC,ACCESS_APPROVERS ACCAPPR, ARS_REQUESTS AREQ\n","stream":"stdout","time":"2022-12-07T13:37:58.254543885Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" SET EH.PROCESSINSTANCEID = AREQ.JBPMPROCESSINSTANCEID,\n","stream":"stdout","time":"2022-12-07T13:37:58.254561071Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" EH.JBPMEXECUTIONID=ACCAPPR.JBPMEXECUTIONID\n","stream":"stdout","time":"2022-12-07T13:37:58.254568417Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" WHERE\n","stream":"stdout","time":"2022-12-07T13:37:58.254569553Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" EH.REQUEST_ACCESS = REQACC.REQUEST_ACCESSKEY AND\n","stream":"stdout","time":"2022-12-07T13:37:58.254573821Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" EH.ACTIVITYNAME=ACCAPPR.JBPM_ACTIVITY_NAME AND\n","stream":"stdout","time":"2022-12-07T13:37:58.254578085Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" ACCAPPR.REQUEST_ACCESS_KEY=REQACC.REQUEST_ACCESSKEY AND\n","stream":"stdout","time":"2022-12-07T13:37:58.254582958Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" REQACC.REQUESTKEY = AREQ.REQUESTKEY AND\n","stream":"stdout","time":"2022-12-07T13:37:58.25458613Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" EH.REQUEST_ACCESS IS NOT NULL AND EH.PROCESSINSTANCEID IS NULL\n","stream":"stdout","time":"2022-12-07T13:37:58.254591758Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" \n","stream":"stdout","time":"2022-12-07T13:37:58.25459411Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,258 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Total rows updated = 0\n","stream":"stdout","time":"2022-12-07T13:37:58.258538452Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,258 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - sql = SELECT EP.OLDEMAILHISTORYKEY AS EMAILHISTORYKEY FROM EMAILHISTORYPROCESS EP\n","stream":"stdout","time":"2022-12-07T13:37:58.258782565Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,259 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Removing EmailHistorykey=39439 from EMAILHISTORY\n","stream":"stdout","time":"2022-12-07T13:37:58.259271783Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,259 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Removing EmailHistorykey=39440 from EMAILHISTORY\n","stream":"stdout","time":"2022-12-07T13:37:58.25928158Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,263 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Processing 2 records\n","stream":"stdout","time":"2022-12-07T13:37:58.26365237Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,263 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Total records left after processing 0\n","stream":"stdout","time":"2022-12-07T13:37:58.263675895Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,263 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Cleaning EmailHistory - UPDATE EMAILHISTORYPROCESS SET STATUS=4 where STATUS=14\n","stream":"stdout","time":"2022-12-07T13:37:58.263691406Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,263 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - recsupdated1 = 0\n","stream":"stdout","time":"2022-12-07T13:37:58.264068952Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,264 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Cleaning EmailHistory - UPDATE EMAILHISTORYPROCESS SET STATUS=7 WHERE STATUS=17\n","stream":"stdout","time":"2022-12-07T13:37:58.264326106Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,264 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - recsupdated2 = 0\n","stream":"stdout","time":"2022-12-07T13:37:58.264680464Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,264 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Cleaning EmailHistory - DELETE FROM EMAILHISTORYPROCESS WHERE STATUS in (144,177)\n","stream":"stdout","time":"2022-12-07T13:37:58.264924165Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,265 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - recsupdated3 = 0\n","stream":"stdout","time":"2022-12-07T13:37:58.265279567Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,265 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - EmailHistory Table has been cleaned\n","stream":"stdout","time":"2022-12-07T13:37:58.265525289Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,265 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Running HQL select a from EmailHistory a where a.status=4\n","stream":"stdout","time":"2022-12-07T13:37:58.265537574Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,265 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Got the result with status STATUS_JBPMSEND(4)=0\n","stream":"stdout","time":"2022-12-07T13:37:58.265978583Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,265 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Building Access Approver Map\n","stream":"stdout","time":"2022-12-07T13:37:58.265996908Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,266 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Building Access Approver Map completed\n","stream":"stdout","time":"2022-12-07T13:37:58.266375992Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,266 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - access approvers list size= 0\n","stream":"stdout","time":"2022-12-07T13:37:58.266389361Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,266 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - processing jbpmAccApprMap\n","stream":"stdout","time":"2022-12-07T13:37:58.266400868Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,266 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - jbpmAccApprMap = [:]\n","stream":"stdout","time":"2022-12-07T13:37:58.266419562Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,266 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Now Email historyprocess size=0\n","stream":"stdout","time":"2022-12-07T13:37:58.267004219Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,266 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Building map for UserGroups\n","stream":"stdout","time":"2022-12-07T13:37:58.267017671Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,267 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Map Built for UserGroup Users - [1:[8, 11], 2:[8]]\n","stream":"stdout","time":"2022-12-07T13:37:58.267323831Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,267 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Building map for Request Access and its corresponding tasks using qry - SELECT ARSTASKS.TASKKEY,ARSTASKS.REQUESTACCESSKEY,ARSTASKS.OWNERTYPE,ARSTASKS.OWNERKEY FROM ARSTASKS,EMAILHISTORYPROCESS WHERE ARSTASKS.REQUESTACCESSKEY=EMAILHISTORYPROCESS.REQUEST_ACCESS AND EMAILHISTORYPROCESS.STATUS=7\n","stream":"stdout","time":"2022-12-07T13:37:58.26734026Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,267 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - roleRequestArsTaskMap = [:]\n","stream":"stdout","time":"2022-12-07T13:37:58.267668158Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,267 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Map Built for Request Access and its corresponding tasks reqAccessArsTasksMap - [:] \n","stream":"stdout","time":"2022-12-07T13:37:58.267714926Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,267 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Running HQL select a from EmailHistory a where a.status=7\n","stream":"stdout","time":"2022-12-07T13:37:58.267721934Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,268 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Now Email historyprocess size=0\n","stream":"stdout","time":"2022-12-07T13:37:58.268628989Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,268 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - List of Email History with status 1=0\n","stream":"stdout","time":"2022-12-07T13:37:58.269030783Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,269 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - List of Email History with status 1=0\n","stream":"stdout","time":"2022-12-07T13:37:58.269993628Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,269 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - List of Email History=0\n","stream":"stdout","time":"2022-12-07T13:37:58.270011312Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,270 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - PROCESS 14 STATUS=0\n","stream":"stdout","time":"2022-12-07T13:37:58.270327419Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,270 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - List of Email History=0\n","stream":"stdout","time":"2022-12-07T13:37:58.270341964Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,270 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Total record in processinstanceid_activityname_Approvers_ListofJbpmExcutionId 0\n","stream":"stdout","time":"2022-12-07T13:37:58.270345471Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,271 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - processinstanceid_activityname_Approvers_ListofJbpmExcutionId = [:]\n","stream":"stdout","time":"2022-12-07T13:37:58.271219306Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,271 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Total emails to be sent=2\n","stream":"stdout","time":"2022-12-07T13:37:58.271737411Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,272 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - THREAD_COUNT_EMAIL_HISTORY_JOB=100\n","stream":"stdout","time":"2022-12-07T13:37:58.272386055Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,272 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - sending 1 of 2\n","stream":"stdout","time":"2022-12-07T13:37:58.272415718Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,272 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - before sending email [akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, akhilc@xxxxxxx.com, aahmed@xxxxxxx.com]\n","stream":"stdout","time":"2022-12-07T13:37:58.272475375Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,273 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - sending 2 of 2\n","stream":"stdout","time":"2022-12-07T13:37:58.273257385Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,273 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - before sending email [akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, null, aahmed@xxxxxxx.com]\n","stream":"stdout","time":"2022-12-07T13:37:58.27331887Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,273 [pool-340-thread-1] DEBUG mail.EmailHistoryService - calling sendEmail in new thread--\n","stream":"stdout","time":"2022-12-07T13:37:58.27388484Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,274 [pool-340-thread-2] DEBUG mail.EmailHistoryService - calling sendEmail in new thread--\n","stream":"stdout","time":"2022-12-07T13:37:58.274675305Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,274 [pool-340-thread-1] DEBUG services.EmailerService - emailAuthType: Basic\n","stream":"stdout","time":"2022-12-07T13:37:58.274832645Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,274 [pool-340-thread-1] DEBUG mail.EmailHistoryService - Mail: [subject:Request Access for Salesforce Endpoint, from:akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, to:[akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, akhilc@xxxxxxx.com, aahmed@xxxxxxx.com], text:There was an error while evaluating the email template, please login to ARS and complete the tasks assigned to you]\n","stream":"stdout","time":"2022-12-07T13:37:58.274922619Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,274 [pool-340-thread-1] DEBUG mail.EmailHistoryService - Did not find email ids form the map so getting it from the emailerService\n","stream":"stdout","time":"2022-12-07T13:37:58.275066057Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,275 [pool-340-thread-1] DEBUG services.EmailerService - Send to delegate flag = true\n","stream":"stdout","time":"2022-12-07T13:37:58.275069267Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,275 [pool-340-thread-2] DEBUG services.EmailerService - emailAuthType: Basic\n","stream":"stdout","time":"2022-12-07T13:37:58.275367045Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,275 [pool-340-thread-2] DEBUG mail.EmailHistoryService - Mail: [subject:Request Access for Salesforce Endpoint, from:akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, to:[akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, null, aahmed@xxxxxxx.com], text:There was an error while evaluating the email template, please login to ARS and complete the tasks assigned to you]\n","stream":"stdout","time":"2022-12-07T13:37:58.275430626Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,275 [pool-340-thread-2] DEBUG mail.EmailHistoryService - Did not find email ids form the map so getting it from the emailerService\n","stream":"stdout","time":"2022-12-07T13:37:58.275545042Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,275 [pool-340-thread-2] DEBUG services.EmailerService - Send to delegate flag = true\n","stream":"stdout","time":"2022-12-07T13:37:58.275554785Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,279 [pool-340-thread-2] DEBUG services.EmailerService - assigneeDelegateEmailQry---select u from Users u, Delegates del where u.id=del.delegateuserkey and del.userkey=3409 and del.startdate \u003c= '2022-12-07 13:37:58' and del.enddate \u003e= '2022-12-07 13:37:58' and u.statuskey = 1\n","stream":"stdout","time":"2022-12-07T13:37:58.279566828Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,279 [pool-340-thread-1] DEBUG services.EmailerService - assigneeDelegateEmailQry---select u from Users u, Delegates del where u.id=del.delegateuserkey and del.userkey=3409 and del.startdate \u003c= '2022-12-07 13:37:58' and del.enddate \u003e= '2022-12-07 13:37:58' and u.statuskey = 1\n","stream":"stdout","time":"2022-12-07T13:37:58.279886339Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-2] DEBUG services.EmailerService - delegatesOfUser---[]\n","stream":"stdout","time":"2022-12-07T13:37:58.294379539Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] DEBUG services.EmailerService - delegatesOfUser---[]\n","stream":"stdout","time":"2022-12-07T13:37:58.294409604Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-2] DEBUG mail.EmailHistoryService - Found the following email ids from the emailerService - [aahmed@xxxxxxx.com, akhilc@xxxxxxx.com, nkishore@xxxxxxx.com] for the emails - [akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, null, aahmed@xxxxxxx.com]\n","stream":"stdout","time":"2022-12-07T13:37:58.294422334Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] DEBUG mail.EmailHistoryService - Found the following email ids from the emailerService - [aahmed@xxxxxxx.com, akhilc@xxxxxxx.com, nkishore@xxxxxxx.com] for the emails - [akhilc@xxxxxxx.com, nkishore@xxxxxxx.com, akhilc@xxxxxxx.com, aahmed@xxxxxxx.com]\n","stream":"stdout","time":"2022-12-07T13:37:58.294427627Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - Exception\n","stream":"stdout","time":"2022-12-07T13:37:58.294791433Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"javax.mail.internet.AddressException: Illegal address in string ``akhilc@xxxxxxx.com, nkishore@xxxxxxx.com''\n","stream":"stdout","time":"2022-12-07T13:37:58.294811906Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.mail.EmailHistoryService.sendEmails(EmailHistoryService.groovy:2805)\n","stream":"stdout","time":"2022-12-07T13:37:58.294820136Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.ecm.services.EmailerService.sendEmailBasedOnConfig(EmailerService.groovy:205)\n","stream":"stdout","time":"2022-12-07T13:37:58.294823766Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.mail.EmailHistoryService.sendEmail(EmailHistoryService.groovy:2669)\n","stream":"stdout","time":"2022-12-07T13:37:58.294826031Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.mail.EmailHistoryService$SendEmailCallable.call(EmailHistoryService.groovy:3255)\n","stream":"stdout","time":"2022-12-07T13:37:58.294833157Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.util.concurrent.FutureTask.run(FutureTask.java:266)\n","stream":"stdout","time":"2022-12-07T13:37:58.294834467Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n","stream":"stdout","time":"2022-12-07T13:37:58.294843711Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n","stream":"stdout","time":"2022-12-07T13:37:58.294850849Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.lang.Thread.run(Thread.java:748)\n","stream":"stdout","time":"2022-12-07T13:37:58.29485639Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - Error while sending email Illegal address\n","stream":"stdout","time":"2022-12-07T13:37:58.294861014Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.auth: True\n","stream":"stdout","time":"2022-12-07T13:37:58.29486827Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.socketFactory.port: 587\n","stream":"stdout","time":"2022-12-07T13:37:58.294873394Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.port: 587\n","stream":"stdout","time":"2022-12-07T13:37:58.294878733Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.starttls.enable: True\n","stream":"stdout","time":"2022-12-07T13:37:58.294907207Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.ssl.protocols: TLSv1.2\n","stream":"stdout","time":"2022-12-07T13:37:58.29492162Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-2] ERROR mail.EmailHistoryService - Exception\n","stream":"stdout","time":"2022-12-07T13:37:58.29508248Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"javax.mail.internet.AddressException: Illegal address in string ``akhilc@xxxxxxx.com, nkishore@xxxxxxx.com''\n","stream":"stdout","time":"2022-12-07T13:37:58.295090626Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.mail.EmailHistoryService.sendEmails(EmailHistoryService.groovy:2805)\n","stream":"stdout","time":"2022-12-07T13:37:58.295092134Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.ecm.services.EmailerService.sendEmailBasedOnConfig(EmailerService.groovy:205)\n","stream":"stdout","time":"2022-12-07T13:37:58.295095354Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.mail.EmailHistoryService.sendEmail(EmailHistoryService.groovy:2669)\n","stream":"stdout","time":"2022-12-07T13:37:58.295099342Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at com.saviynt.mail.EmailHistoryService$SendEmailCallable.call(EmailHistoryService.groovy:3255)\n","stream":"stdout","time":"2022-12-07T13:37:58.295104598Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.util.concurrent.FutureTask.run(FutureTask.java:266)\n","stream":"stdout","time":"2022-12-07T13:37:58.295110995Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n","stream":"stdout","time":"2022-12-07T13:37:58.295115452Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n","stream":"stdout","time":"2022-12-07T13:37:58.295119819Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"\u0009at java.lang.Thread.run(Thread.java:748)\n","stream":"stdout","time":"2022-12-07T13:37:58.2951291Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - Error while sending email Illegal address\n","stream":"stdout","time":"2022-12-07T13:37:58.295132235Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.auth: True\n","stream":"stdout","time":"2022-12-07T13:37:58.295144079Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.socketFactory.port: 587\n","stream":"stdout","time":"2022-12-07T13:37:58.295186602Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.port: 587\n","stream":"stdout","time":"2022-12-07T13:37:58.295195577Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.starttls.enable: True\n","stream":"stdout","time":"2022-12-07T13:37:58.295238187Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.ssl.protocols: TLSv1.2\n","stream":"stdout","time":"2022-12-07T13:37:58.295291696Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.starttls.required: True\n","stream":"stdout","time":"2022-12-07T13:37:58.295299053Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - mail.smtp.ssl.trust: smtp.gmail.com\n","stream":"stdout","time":"2022-12-07T13:37:58.29532686Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - smtpusername: aahmed@xxxxxxx.com\n","stream":"stdout","time":"2022-12-07T13:37:58.295392478Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] ERROR mail.EmailHistoryService - smtpservername: smtp.gmail.com\n","stream":"stdout","time":"2022-12-07T13:37:58.295399481Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] DEBUG mail.EmailHistoryService - mail Sent\n","stream":"stdout","time":"2022-12-07T13:37:58.295409368Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-2] DEBUG mail.EmailHistoryService - mail trigerred or not ...false\n","stream":"stdout","time":"2022-12-07T13:37:58.295415527Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,294 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.starttls.required: True\n","stream":"stdout","time":"2022-12-07T13:37:58.295501293Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-1] ERROR mail.EmailHistoryService - mail.smtp.ssl.trust: smtp.gmail.com\n","stream":"stdout","time":"2022-12-07T13:37:58.295509675Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-1] ERROR mail.EmailHistoryService - smtpusername: aahmed@xxxxxxx.com\n","stream":"stdout","time":"2022-12-07T13:37:58.29552727Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-1] ERROR mail.EmailHistoryService - smtpservername: smtp.gmail.com\n","stream":"stdout","time":"2022-12-07T13:37:58.295537912Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-1] DEBUG mail.EmailHistoryService - mail Sent\n","stream":"stdout","time":"2022-12-07T13:37:58.295543328Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [pool-340-thread-1] DEBUG mail.EmailHistoryService - mail trigerred or not ...false\n","stream":"stdout","time":"2022-12-07T13:37:58.295547107Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,295 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Updating status of email history process\n","stream":"stdout","time":"2022-12-07T13:37:58.296005102Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,300 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Updating status of email history process completed\n","stream":"stdout","time":"2022-12-07T13:37:58.300163492Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,300 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - invalidEmailHistoryMap is blank or null\n","stream":"stdout","time":"2022-12-07T13:37:58.300196089Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,300 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - delprocsql = DELETE FROM EMAILHISTORYPROCESS WHERE EMAILHISTORYKEY = ?\n","stream":"stdout","time":"2022-12-07T13:37:58.300207204Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,300 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - emailHistoryDeleteStatusMap is blank or null\n","stream":"stdout","time":"2022-12-07T13:37:58.300212486Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,300 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Archiving EmailHistory Table - \n","stream":"stdout","time":"2022-12-07T13:37:58.300217844Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" INSERT INTO EMAILHISTORY_ARCHIVE(EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,\n","stream":"stdout","time":"2022-12-07T13:37:58.300224086Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS)\n","stream":"stdout","time":"2022-12-07T13:37:58.300232947Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" SELECT EMAILHISTORYKEY,OLDEMAILHISTORYKEY,ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,\n","stream":"stdout","time":"2022-12-07T13:37:58.300234077Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,\n","stream":"stdout","time":"2022-12-07T13:37:58.300238176Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" TOADDRESS,UUID,BCCADDRESS,EMAILFAILURELOGS FROM EMAILHISTORYPROCESS\n","stream":"stdout","time":"2022-12-07T13:37:58.300247418Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" \n","stream":"stdout","time":"2022-12-07T13:37:58.300251439Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,303 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Inserting into EMAILHISTORY to retry emails with status 5,15,404 - \n","stream":"stdout","time":"2022-12-07T13:37:58.303255646Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" INSERT INTO EMAILHISTORY(ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,\n","stream":"stdout","time":"2022-12-07T13:37:58.303275379Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS)\n","stream":"stdout","time":"2022-12-07T13:37:58.303276932Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" SELECT ACCESS_APPROVERS,ACTIVITYNAME,BODYOFEMAIL,CCADDRESS,CREATEDATE,EMAILTEMPLATE,ENDPOINTKEY,\n","stream":"stdout","time":"2022-12-07T13:37:58.30328258Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" JBPMEXECUTIONID,MAILSENTDATE,PROCESSINSTANCEID,REQUEST_ACCESS,STATUS,SUBJECTOFEMAIL,FROMADDRESS,TOADDRESS,UUID,BCCADDRESS \n","stream":"stdout","time":"2022-12-07T13:37:58.303286892Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" FROM EMAILHISTORYPROCESS where status in (5,15,404)\n","stream":"stdout","time":"2022-12-07T13:37:58.303289053Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":" \n","stream":"stdout","time":"2022-12-07T13:37:58.303292994Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,315 [quartzScheduler_Worker-7] DEBUG mail.EmailHistoryService - Email History Service END\n","stream":"stdout","time":"2022-12-07T13:37:58.315471326Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,315 [quartzScheduler_Worker-7] DEBUG services.SaviyntCommonUtilityService - Enter runNextTrigger \n","stream":"stdout","time":"2022-12-07T13:37:58.315492917Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,315 [quartzScheduler_Worker-7] DEBUG services.SaviyntCommonUtilityService - Exit runNextTrigger \n","stream":"stdout","time":"2022-12-07T13:37:58.315498035Z"}" "ecm-worker","2022-12-07T13:37:58.529+0000","{"log":"2022-12-07 13:37:58,315 [quartzScheduler_Worker-7] DEBUG jobs.EmailHistoryJob - End cronEmailHistoryJob\n","stream":"stdout","time":"2022-12-07T13:37:58.315502054Z"}" "ecm","2022-12-07T13:37:58.466+0000","{"log":"2022-12-07 13:37:58,041 [http-nio-8080-exec-11] DEBUG domain.FlatViewJobcontrolController - Inside fireJobAction params = [triggername:Email_History, triggergroup:GRAILS_JOBS, jobname:EmailHistoryJob, jobgroup:utility, actn:6, job_name:, job_group:, controller:flatViewJobcontrol, action:fireJobAction]\n","stream":"stdout","time":"2022-12-07T13:37:58.041698479Z"}" "ecm","2022-12-07T13:37:58.466+0000","{"log":"2022-12-07 13:37:58,043 [http-nio-8080-exec-11] DEBUG domain.FlatViewJobcontrolController - executing scheduling trigger...\n","stream":"stdout","time":"2022-12-07T13:37:58.043414611Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,185 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - ecmjobIdQuery .. select max(eij.JOBID) as 'JobId' from EcmImportJob eij where eij.TRIGGERNAME in (select qrt.TRIGGER_NAME from qrtz_triggers qrt) group by eij.TRIGGERNAME\n","stream":"stdout","time":"2022-12-07T13:37:50.186094178Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,243 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - jobIdList size = 23\n","stream":"stdout","time":"2022-12-07T13:37:50.243419748Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,244 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - \n","stream":"stdout","time":"2022-12-07T13:37:50.244814832Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,244 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - jobAndTriggerQuery .. select e.SAVRESPONSE, e.JOBENDDATE as prev_fire_time, qt.job_name, qt.job_group, qt.trigger_name,qt.trigger_group,qt.next_fire_time, qct.CRON_EXPRESSION from qrtz_triggers qt left join ecmimportjob e on e.TRIGGERNAME=qt.TRIGGER_NAME left join qrtz_cron_triggers qct on qct.TRIGGER_NAME = qt.TRIGGER_NAME where e.JOBID in(32115,38071,36596,26051,22688,4689,4906,19924,38490,38253,38465,10854,38492,36605,38333,38488,38319,20583,36836,27076,24951,26758,27551) and qt.job_name != 'WSBlockingRetryJob' AND qt.job_group != 'BaseLine' Order by qt.next_fire_time desc \n","stream":"stdout","time":"2022-12-07T13:37:50.244849491Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,244 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - \n","stream":"stdout","time":"2022-12-07T13:37:50.24485888Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,244 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - onlyTriggerQuery .. select qt.job_name, qt.job_group, qt.trigger_name, qt.trigger_group, qt.next_fire_time, qct.CRON_EXPRESSION, qt.TRIGGER_STATE from qrtz_triggers qt left join qrtz_cron_triggers qct on qct.TRIGGER_NAME = qt.TRIGGER_NAME where 1=1 and qt.job_name not in ('AnalyticsJob','AnalyticsESJob') and qt.job_name != 'WSBlockingRetryJob' AND qt.job_group != 'BaseLine' Order by qt.next_fire_time desc \n","stream":"stdout","time":"2022-12-07T13:37:50.24486371Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,246 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - Before fetching jobEnddate and SavResponse from EcmImportJob first element from qrtzTriggerDataList : [job_name:ApplicationDataImportJob, job_group:DATA, trigger_name:AD_import, trigger_group:GRAILS_JOBS, next_fire_time:4070945700000, CRON_EXPRESSION:0 15 10 * * ? 2099, TRIGGER_STATE:WAITING]\n","stream":"stdout","time":"2022-12-07T13:37:50.246524521Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,246 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - After fetching jobEnddate and SavResponse from EcmImportJob first element from qrtzTriggerDataList : [job_name:ApplicationDataImportJob, job_group:DATA, trigger_name:AD_import, trigger_group:GRAILS_JOBS, next_fire_time:4070945700000, CRON_EXPRESSION:0 15 10 * * ? 2099, TRIGGER_STATE:WAITING, SAVRESPONSE:Success, prev_fire_time:2022-12-02 09:54:31.0]\n","stream":"stdout","time":"2022-12-07T13:37:50.246603032Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,246 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - totalData 20\n","stream":"stdout","time":"2022-12-07T13:37:50.246613954Z"}" "ecm","2022-12-07T13:37:50.467+0000","{"log":"2022-12-07 13:37:50,249 [http-nio-8080-exec-1] DEBUG domain.FlatViewJobcontrolController - The running job list is []\n","stream":"stdout","time":"2022-12-07T13:37:50.249539139Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,510 [http-nio-8080-exec-11] DEBUG ws.Restfulv5Controller - Disable Audit Logging : true\n","stream":"stdout","time":"2022-12-07T13:37:44.510677925Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,512 [http-nio-8080-exec-11] DEBUG ws.Restfulv5Controller - Default max limit is set to 50\n","stream":"stdout","time":"2022-12-07T13:37:44.5124058Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,512 [http-nio-8080-exec-11] DEBUG ws.Restfulv5Controller - inside getEcmVersion\n","stream":"stdout","time":"2022-12-07T13:37:44.512509156Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,513 [http-nio-8080-exec-11] DEBUG services.SaviyntCommonUtilityService - Inside setContentTypeForSaviyntAPIs\n","stream":"stdout","time":"2022-12-07T13:37:44.513250541Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,513 [http-nio-8080-exec-11] DEBUG services.SaviyntCommonUtilityService - contentType - text/json\n","stream":"stdout","time":"2022-12-07T13:37:44.513266093Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,513 [http-nio-8080-exec-11] DEBUG services.SaviyntCommonUtilityService - contentTypeFromConfig - application/json\n","stream":"stdout","time":"2022-12-07T13:37:44.513840792Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,513 [http-nio-8080-exec-11] DEBUG services.SaviyntCommonUtilityService - Exit setContentTypeForSaviyntAPIs\n","stream":"stdout","time":"2022-12-07T13:37:44.513861445Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,533 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - jobIdList size = 23\n","stream":"stdout","time":"2022-12-07T13:37:44.533175759Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,533 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - \n","stream":"stdout","time":"2022-12-07T13:37:44.534004736Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,533 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - jobAndTriggerQuery .. select e.SAVRESPONSE, e.JOBENDDATE as prev_fire_time, qt.job_name, qt.job_group, qt.trigger_name,qt.trigger_group,qt.next_fire_time, qct.CRON_EXPRESSION from qrtz_triggers qt left join ecmimportjob e on e.TRIGGERNAME=qt.TRIGGER_NAME left join qrtz_cron_triggers qct on qct.TRIGGER_NAME = qt.TRIGGER_NAME where e.JOBID in(32115,38071,36596,26051,22688,4689,4906,19924,38490,38253,38465,10854,38492,36605,38333,38488,38319,20583,36836,27076,24951,26758,27551) and qt.job_name != 'WSBlockingRetryJob' AND qt.job_group != 'BaseLine' Order by qt.next_fire_time desc \n","stream":"stdout","time":"2022-12-07T13:37:44.534025434Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,533 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - \n","stream":"stdout","time":"2022-12-07T13:37:44.534031532Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,533 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - onlyTriggerQuery .. select qt.job_name, qt.job_group, qt.trigger_name, qt.trigger_group, qt.next_fire_time, qct.CRON_EXPRESSION, qt.TRIGGER_STATE from qrtz_triggers qt left join qrtz_cron_triggers qct on qct.TRIGGER_NAME = qt.TRIGGER_NAME where 1=1 and qt.job_name not in ('AnalyticsJob','AnalyticsESJob') and qt.job_name != 'WSBlockingRetryJob' AND qt.job_group != 'BaseLine' Order by qt.next_fire_time desc \n","stream":"stdout","time":"2022-12-07T13:37:44.534055181Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,535 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - Before fetching jobEnddate and SavResponse from EcmImportJob first element from qrtzTriggerDataList : [job_name:ApplicationDataImportJob, job_group:DATA, trigger_name:AD_import, trigger_group:GRAILS_JOBS, next_fire_time:4070945700000, CRON_EXPRESSION:0 15 10 * * ? 2099, TRIGGER_STATE:WAITING]\n","stream":"stdout","time":"2022-12-07T13:37:44.535644013Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,535 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - After fetching jobEnddate and SavResponse from EcmImportJob first element from qrtzTriggerDataList : [job_name:ApplicationDataImportJob, job_group:DATA, trigger_name:AD_import, trigger_group:GRAILS_JOBS, next_fire_time:4070945700000, CRON_EXPRESSION:0 15 10 * * ? 2099, TRIGGER_STATE:WAITING, SAVRESPONSE:Success, prev_fire_time:2022-12-02 09:54:31.0]\n","stream":"stdout","time":"2022-12-07T13:37:44.535723467Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,535 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - totalData 20\n","stream":"stdout","time":"2022-12-07T13:37:44.535739267Z"}" "ecm","2022-12-07T13:37:45.467+0000","{"log":"2022-12-07 13:37:44,538 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - The running job list is []\n","stream":"stdout","time":"2022-12-07T13:37:44.538263245Z"}" "ecm","2022-12-07T13:37:44.467+0000","{"log":"2022-12-07 13:37:44,229 [http-nio-8080-exec-11] DEBUG rest.JwtService - Parsed an HMAC signed JWT\n","stream":"stdout","time":"2022-12-07T13:37:44.229347708Z"}" "ecm","2022-12-07T13:37:44.467+0000","{"log":"2022-12-07 13:37:44,230 [http-nio-8080-exec-11] DEBUG rest.JwtService - Parsed an HMAC signed JWT\n","stream":"stdout","time":"2022-12-07T13:37:44.230290432Z"}" "ecm","2022-12-07T13:37:44.467+0000","{"log":"2022-12-07 13:37:44,230 [http-nio-8080-exec-11] DEBUG println.PrintlnToLogger - Println :: Inside onAuthenticationSuccessEvent\n","stream":"stdout","time":"2022-12-07T13:37:44.230832063Z"}" "ecm","2022-12-07T13:37:44.467+0000","{"log":"2022-12-07 13:37:44,465 [http-nio-8080-exec-4] DEBUG domain.FlatViewJobcontrolController - ecmjobIdQuery .. select max(eij.JOBID) as 'JobId' from EcmImportJob eij where eij.TRIGGERNAME in (select qrt.TRIGGER_NAME from qrtz_triggers qrt) group by eij.TRIGGERNAME\n","stream":"stdout","time":"2022-12-07T13:37:44.466154606Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,781 [http-nio-8080-exec-17] DEBUG println.PrintlnToLogger - Println :: Inside loadUserByUsername of child GormUserDetailsService.\n","stream":"stdout","time":"2022-12-07T13:37:35.7812288Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,879 [http-nio-8080-exec-17] DEBUG println.PrintlnToLogger - Println :: Inside onAuthenticationSuccessEvent\n","stream":"stdout","time":"2022-12-07T13:37:35.879637182Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,879 [http-nio-8080-exec-17] DEBUG security.RestTokenGeneratorService - isValidRedirectionRequestFromMS - msRedirectUrl: https%3A%2F%2Fsecurdi-partner.saviyntcloud.com%2FECM%2FflatViewJobcontrol%2FflatViewJobList\n","stream":"stdout","time":"2022-12-07T13:37:35.879892823Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,879 [http-nio-8080-exec-17] DEBUG security.RestTokenGeneratorService - isValidRedirectionRequestFromMS - msSubdomain: \n","stream":"stdout","time":"2022-12-07T13:37:35.879905487Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,879 [http-nio-8080-exec-17] DEBUG println.PrintlnToLogger - Println :: isValidRedirectionRequestFromMS - msRedirectUrl: https%3A%2F%2Fsecurdi-partner.saviyntcloud.com%2FECM%2FflatViewJobcontrol%2FflatViewJobList\n","stream":"stdout","time":"2022-12-07T13:37:35.879911128Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,879 [http-nio-8080-exec-17] DEBUG println.PrintlnToLogger - Println :: isValidRedirectionRequestFromMS - msSubdomain: \n","stream":"stdout","time":"2022-12-07T13:37:35.879922716Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,881 [http-nio-8080-exec-17] DEBUG security.RestTokenGeneratorService - enableV6Config: 1\n","stream":"stdout","time":"2022-12-07T13:37:35.881254964Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,881 [http-nio-8080-exec-17] DEBUG println.PrintlnToLogger - Println :: enableV6Config: 1\n","stream":"stdout","time":"2022-12-07T13:37:35.881280014Z"}" "ecm","2022-12-07T13:37:36.467+0000","{"log":"2022-12-07 13:37:35,881 [http-nio-8080-exec-17] DEBUG security.RestTokenGeneratorService - isValidRedirectionRequestFromMS: true\n","stream":"stdout","time":"2022-12-07T13:37:35.881285472Z"}"