Email History Job Failure

[rushikeshvartak]

Email history Job is failing

2024-06-13T16:42:38-04:00-ecm-worker-mail.EmailHistoryService-quartzScheduler_Worker-16-6v8rs-ERROR-Exception

2024-06-13T16:42:39-04:00-ecm-worker--null-6v8rs--java.sql.BatchUpdateException: Data truncation: Data too long for column 'EMAILFAILURELOGS' at row 1 at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) at com.mysql.cj.util.Util.getInstance(Util.java:167) at com.mysql.cj.util.Util.getInstance(Util.java:174) at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:853) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:435) at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:796) at com.saviynt.mail.EmailHistoryService$_execute_closure3_closure54_closure55.doCall(EmailHistoryService.groovy:203) at com.saviynt.mail.EmailHistoryService$_execute_closure3_closure54.doCall(EmailHistoryService.groovy:189) at com.saviynt.mail.EmailHistoryService$_execute_closure3.doCall(EmailHistoryService.groovy:188) at com.saviynt.mail.EmailHistoryService.execute(EmailHistoryService.groovy:187) at EmailHistoryJob.execute(EmailHistoryJob.groovy:35) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'EMAILFAILURELOGS' at row 1 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832) ... 9 more

Data truncation: Data too long for column 'EMAILFAILURELOGS' at row 1
Time Taken 88(miliseconds)

Steps performed.

• There is no email template with task keyword so issue is not related.
• we tried changing status to 15 /5/404 still email history job is failing

[rushikeshvartak]

It seems issue is fixed in v24.6 

2026822

FON-16595

After upgrading EIC, the Email History Job (EmailHistoryJob) fails to complete and throws an exception stating, Data truncation: Data too long for column 'EMAILFAILURELOGS' at row 1 Time Taken 86(miliseconds). https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v24x/Release-Notes-24-6.htm

[Raghu]

@rushikeshvartak   this issue we also experienced , it would be fixed 24.4.6v sub version deployment.

[rushikeshvartak · Accepted solution]

We have cleared emails from emailhistory table and fixed the issue.