Hi folks,
The ootb email purging job is failing with the following error message: "Error while purging email history archive table"
Investigating logs revealed the following lines:
"ecm-worker","2023-05-04T00:26:36.773+00:00","2023-05-04T00:26:35.79982008Z stdout F 2023-05-04 00:26:35,799 [quartzScheduler_Worker-3] DEBUG println.PrintlnToLogger - Println :: inside email purge job"
"ecm-worker","2023-05-04T00:26:36.773+00:00","2023-05-04T00:26:35.803699276Z stdout F 2023-05-04 00:26:35,803 [quartzScheduler_Worker-3] DEBUG archive.ArchiveJobPurgingService - Qry for purging emailhistory_archive : delete from emailhistory_archive where str_to_date(createdate, '%m-%d-%Y %H:%i:%s') < now() - interval :Days day"
"ecm-worker","2023-05-04T00:26:36.773+00:00","2023-05-04T00:26:35.803736077Z stdout F 2023-05-04 00:26:35,803 [quartzScheduler_Worker-3] DEBUG archive.ArchiveJobPurgingService - Number of Days : 90"
"ecm-worker","2023-05-04T00:26:36.773+00:00","2023-05-04T00:26:35.807370067Z stderr F 04-May-2023 00:26:35.807 WARNING [quartzScheduler_Worker-3] groovy.sql.Sql.executeUpdate Failed to execute: delete from emailhistory_archive where str_to_date(createdate, '%m-%d-%Y %H:%i:%s') < now() - interval :Days day because: Incorrect datetime value: 'Fri Apr 14 21:21:36 UTC 2023' for function str_to_date"
"ecm-worker","2023-05-04T00:26:36.773+00:00","2023-05-04T00:26:35.807988683Z stdout F 2023-05-04 00:26:35,807 [quartzScheduler_Worker-3] ERROR archive.ArchiveJobPurgingService - Something went wrong while deleting"
"ecm-worker","2023-05-04T00:26:36.773+00:00","2023-05-04T00:26:35.809384217Z stdout F 2023-05-04 00:26:35,809 [quartzScheduler_Worker-3] ERROR archive.ArchiveJobPurgingService - Incorrect datetime value: 'Fri Apr 14 21:21:36 UTC 2023' for function str_to_date"
Is there any way to resolve this or is it support ticket time?
