Informations
-
Bug
-
Résolution: Résolu
-
Mineur
-
1.06.00-BETA-01
-
Aucune
-
reproduit sur dev-ksup-master
Description
Lorsque j'exécute le script de maintenance des newsletter, j'obtiens l'erreur suivante dans les logs :
Data truncation: Incorrect date value: 'Tue Feb 20 15:45:28 CET 2018' for column 'DATE_PURGE' at row
2018-02-20_15:45:28.213 [pool-5-thread-1] [] INFO c.k.s.spring.quartz.LogReportJob - DEBUT PurgeNewsletterJob 2018-02-20_15:45:28.217 [pool-5-thread-1] [] INFO c.k.n.batch.PurgeNewsletterJob - Purge des demandes d'abonnement aux newsletters désactivé 2018-02-20_15:45:28.217 [pool-5-thread-1] [] INFO c.k.n.batch.PurgeNewsletterJob - Suppression des archives des envois de newsletter 2018-02-20_15:45:28.221 [pool-5-thread-1] [] ERROR c.k.n.batch.PurgeNewsletterJob - Erreur SQL lors de la purge des mailings obsolètes com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: 'Tue Feb 20 15:45:28 CET 2018' for column 'DATE_PURGE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3971) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998) at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61) at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java) at com.kosmos.newsletter.batch.PurgeNewsletterJob.perform(PurgeNewsletterJob.java:45) at com.kportal.scheduling.spring.quartz.LogReportJob.execute(LogReportJob.java:36) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2018-02-20_15:45:28.222 [pool-5-thread-1] [] INFO c.k.s.spring.quartz.LogReportJob - FIN PurgeNewsletterJob, durée : 00:00:00