Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Email History Job Failure

rushikeshvartak
All-Star
All-Star

Email history Job is failing

rushikeshvartak_0-1718311834602.png

 

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

Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.
3 REPLIES 3

rushikeshvartak
All-Star
All-Star

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 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

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

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

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


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.