Lorsqu'on créé une fiche en chinois avec un titre assez long, une erreur peut survenir à l'enregistrement car lors de la création du slug, les caractères sont transformés et dépassent alors la limite de 255 caractères :
Voici la stack :
2020-02-06_11:29:00.399 [ajp-nio-8009-exec-10] [5EFC61304D017B2B9FA1BE848B87DEFA.ksup1] ERROR c.u.o.processus.SaisieFiche - erreur dans le processus de saisie de fiche com.jsbsoft.jtf.datasource.exceptions.UpdateToDataSourceException: Unable to update ACTUALITE with id 1000021 at com.jsbsoft.jtf.datasource.dao.impl.mysql.AbstractCommonDAO.update(AbstractCommonDAO.java:168) at com.univ.objetspartages.om.AbstractOm.update(AbstractOm.java:90) at com.univ.utils.FicheUnivMgr.enregistrer(FicheUnivMgr.java:428) at com.univ.objetspartages.processus.ControleurUniv.traiterActionEnregistrer(ControleurUniv.java:1780) at com.univ.objetspartages.processus.ControleurUniv.traiterActionTraitement(ControleurUniv.java:1034) at com.univ.objetspartages.processus.ControleurUniv.traiterPRINCIPAL(ControleurUniv.java:978) at com.univ.objetspartages.processus.SaisieActualite.traiterPRINCIPAL(SaisieActualite.java:207) at com.univ.objetspartages.processus.SaisieFiche.traiterActionParDefaut(SaisieFiche.java:412) at com.univ.objetspartages.processus.SaisieActualite.traiterAction(SaisieActualite.java:76) at com.jsbsoft.jtf.core.ProcessusManager.traiterAction(ProcessusManager.java:241) at com.jsbsoft.jtf.core.ProcedureBean.descriptifFluxProcessus(ProcedureBean.java:500) at com.jsbsoft.jtf.core.ProcedureBean.descriptifFluxRetour(ProcedureBean.java:210) at com.jsbsoft.jtf.core.ProcedureBean.descriptifFluxRetour(ProcedureBean.java:238) at com.jsbsoft.jtf.core.TraitementRequeteHTTP.traiterRequeteHTTP(TraitementRequeteHTTP.java:489) at com.kosmos.controllers.SGController.doSg(SGController.java:39) at sun.reflect.GeneratedMethodAccessor608.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:232) at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:209) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.kosmos.log.MDCFilter.doFilter(MDCFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.jsbsoft.jtf.core.LogAppFilter.doFilter(LogAppFilter.java:123) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at ro.isdc.wro.http.WroContextFilter.doFilter(WroContextFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.kportal.pdf.PDFFilter.doFilter(PDFFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.univ.url.filter.SiteAliasResolutionFilter.doFilter(SiteAliasResolutionFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.univ.multisites.filter.HttpsRedirectFilter.doFilter(HttpsRedirectFilter.java:69) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.univ.utils.filter.ContexteFilter.doFilter(ContexteFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.univ.utils.filter.HoneyPotFilter.doFilter(HoneyPotFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:482) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE ACTUALITE SET CODE=?, CODE_RATTACHEMENT=?, CODE_REDACTEUR=?, CODE_RUBRIQUE=?, CODE_VALIDATION=?, COMPLEMENT_DATE=?, CONTENU_ENCADRE=?, DATE_ALERTE=?, DATE_ARCHIVAGE=?, DATE_CREATION=?, DATE_DECLENCHEMENT=?, DATE_EVENEMENT=?, DATE_FIN_EVENEMENT=?, DATE_MODIFICATION=?, DATE_PROPOSITION=?, DATE_SUPPRESSION=?, DATE_VALIDATION=?, DESCRIPTION=?, DIFFUSION_MODE_RESTRICTION=?, DIFFUSION_PUBLIC_VISE=?, DIFFUSION_PUBLIC_VISE_RESTRICTION=?, EMAIL_RESPONSABLE_EVENEMENT=?, ENCADRE_RECHERCHE=?, ENCADRE_RECHERCHE_BIS=?, ETAT_OBJET=?, ID_PLAN_ACCES=?, ID_VIGNETTE=?, INSERTION_AGENDA=?, LANGUE=?, LIEU=?, MESSAGE_ALERTE=?, META_DESCRIPTION=?, META_KEYWORDS=?, NB_HITS=?, PARTENAIRES=?, RATTACHEMENT_BANDEAU=?, RESPONSABLE_EVENEMENT=?, RESUME=?, SITE_EVENEMENT=?, SLUG=?, THEMATIQUE=?, TITRE=?, TITRE_ENCADRE=?, TYPE_EVENEMENT=? WHERE ID_ACTUALITE = ?]; Data truncation: Data too long for column 'SLUG' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'SLUG' at row 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:870) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:894) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:287) at com.jsbsoft.jtf.datasource.dao.impl.mysql.AbstractCommonDAO.update(AbstractCommonDAO.java:166) ... 84 common frames omitted Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'SLUG' 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.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:877) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:870) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633) ... 88 common frames omitted
1.
|
Report 6.7 - CORE-4957 | Fini | Automate |