Monitoring JavaMelody sur /demo

Retour

Page principale

Actualiser PDF

PDF

Aide en ligne

Desktop Choix de la période : Jour

Jour

Semaine

Mois

Année

Tout

Personnalisée

Par déploiement

Requête	Temps moyen (ms)	Temps max (ms)	Ecart-type	Temps cpu moyen (ms)	% d'erreur système
ERROR [fr.spi4j.ui.gwt.server.SpiRemoteServiceImpl] Erreur racine : org.h2.jdbc.JdbcSQLDataException: Valeur trop longue pour la colonne "SALAIRE DECIMAL(14, 2)": "56666667899999.00 (16)" Value too long for column "SALAIRE DECIMAL(14, 2)": "56666667899999.00 (16)"; SQL statement: update AW_PERSONNE set NOM = ?, PRENOM = ?, CIVIL = ?, DATE_NAISSANCE = ?, SALAIRE = ?, VERSION = ?, GRADE_ID = ?, XDMAJ = ?, XTOPSUP = ? where PERSONNE_ID = ? and VERSION = ? [22001-200] Erreur levée : Erreur 'executeUpdate' Solution potentielle : Vérifier la requête sql (p_sqlQuery=update AW_PERSONNE set NOM = :nom, PRENOM = :prenom, CIVIL = :civil, DATE_NAISSANCE = :dateNaissance, SALAIRE = :salaire, VERSION = :version, GRADE_ID = :grade_id, XDMAJ = :xdmaj, XTOPSUP = :xtopsup where PERSONNE_ID = :id and VERSION = :spi4j_version_value) update AW_PERSONNE set NOM = 'Мальчик', PRENOM = 'Молодой', CIVIL = 0, DATE_NAISSANCE = '02/11/2023 00:00:00', SALAIRE = 5.6666667899999E13, VERSION = '21/02/2024 23:55:52', GRADE_ID = 1001, XDMAJ = '21/02/2024 23:55:52', XTOPSUP = 0 where PERSONNE_ID = 1464 and VERSION = '05/02/2024 14:55:04'	-1	0	0		100,00

Stack-trace
Erreur racine : org.h2.jdbc.JdbcSQLDataException: Valeur trop longue pour la colonne "SALAIRE DECIMAL(14, 2)": "56666667899999.00 (16)"
Value too long for column "SALAIRE DECIMAL(14, 2)": "56666667899999.00 (16)"; SQL statement:
update AW_PERSONNE set NOM = ?, PRENOM = ?, CIVIL = ?, DATE_NAISSANCE = ?, SALAIRE = ?, VERSION = ?, GRADE_ID = ?, XDMAJ = ?, XTOPSUP = ? where PERSONNE_ID = ? and VERSION = ? [22001-200]
Erreur levée : Erreur 'executeUpdate'
Solution potentielle : Vérifier la requête sql (p_sqlQuery=update AW_PERSONNE set NOM = :nom, PRENOM = :prenom, CIVIL = :civil, DATE_NAISSANCE = :dateNaissance, SALAIRE = :salaire, VERSION = :version, GRADE_ID = :grade_id, XDMAJ = :xdmaj, XTOPSUP = :xtopsup where PERSONNE_ID = :id and VERSION = :spi4j_version_value)
update AW_PERSONNE set NOM = 'Мальчик', PRENOM = 'Молодой', CIVIL = 0, DATE_NAISSANCE = '02/11/2023 00:00:00', SALAIRE = 5.6666667899999E13, VERSION = '21/02/2024 23:55:52', GRADE_ID = 1001, XDMAJ = '21/02/2024 23:55:52', XTOPSUP = 0 where PERSONNE_ID = 1464 and VERSION = '05/02/2024 14:55:04'
      at fr.spi4j.persistence.dao.jdbc.DaoJdbc_Abs.executeUpdate(DaoJdbc_Abs.java:753)
      at fr.spi4j.persistence.dao.jdbc.DaoJdbc_Abs.update(DaoJdbc_Abs.java:371)
      at fr.spi4j.matching.Match_Abs.update(Match_Abs.java:73)
      at fr.appwhite1.matching.Appli1Match_Abs.update(Appli1Match_Abs.java:111)
      at fr.appwhite1.matching.annuaire.PersonneMatch.update(PersonneMatch.java:156)
      at fr.appwhite1.matching.annuaire.PersonneMatch.update(PersonneMatch.java:32)
      at fr.spi4j.business.Service_Abs.save(Service_Abs.java:52)
      at jdk.internal.reflect.GeneratedMethodAccessor2106.invoke(Unknown Source)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
      at fr.spi4j.ReflectUtil.invokeMethod(ReflectUtil.java:39)
      at fr.spi4j.lib.security.SecurityProxy.invoke(SecurityProxy.java:47)
      at com.sun.proxy.$Proxy6.save(Unknown Source)
      at jdk.internal.reflect.GeneratedMethodAccessor2106.invoke(Unknown Source)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
      at fr.spi4j.ReflectUtil.invokeMethod(ReflectUtil.java:39)
      at fr.spi4j.persistence.TransactionProxy.invoke(TransactionProxy.java:70)
      at com.sun.proxy.$Proxy6.save(Unknown Source)
      at jdk.internal.reflect.GeneratedMethodAccessor2106.invoke(Unknown Source)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
      at fr.spi4j.ReflectUtil.invokeMethod(ReflectUtil.java:39)
      at fr.spi4j.business.ServiceLogProxy.invoke(ServiceLogProxy.java:169)
      at com.sun.proxy.$Proxy6.save(Unknown Source)
      at jdk.internal.reflect.GeneratedMethodAccessor2106.invoke(Unknown Source)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
      at net.bull.javamelody.MonitoringProxy.invokeTarget(MonitoringProxy.java:182)
      at net.bull.javamelody.MonitoringProxy.invoke(MonitoringProxy.java:164)
      at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
      at com.sun.proxy.$Proxy7.save(Unknown Source)
      at fr.spi4j.ui.gwt.server.GwtRemoteServiceImpl.save(GwtRemoteServiceImpl.java:31)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
      at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
      at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
      at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
      at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
      at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
      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:53)
      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:239)
      at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at fr.spi4j.filter.HttpSessionFilter.doFilter(HttpSessionFilter.java:69)
      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:199)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at fr.spi4j.lib.security.RemoteUserFilter.doFilter(RemoteUserFilter.java:92)
      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:202)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.h2.jdbc.JdbcSQLDataException: Valeur trop longue pour la colonne "SALAIRE DECIMAL(14, 2)": "56666667899999.00 (16)"
Value too long for column "SALAIRE DECIMAL(14, 2)": "56666667899999.00 (16)"; SQL statement:
update AW_PERSONNE set NOM = ?, PRENOM = ?, CIVIL = ?, DATE_NAISSANCE = ?, SALAIRE = ?, VERSION = ?, GRADE_ID = ?, XDMAJ = ?, XTOPSUP = ? where PERSONNE_ID = ? and VERSION = ? [22001-200]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
      at org.h2.message.DbException.get(DbException.java:205)
      at org.h2.value.TypeInfo.getValueTooLongException(TypeInfo.java:535)
      at org.h2.value.TypeInfo.cast(TypeInfo.java:520)
      at org.h2.table.Column.validateConvertUpdateSequence(Column.java:378)
      at org.h2.table.Table.validateConvertUpdateSequence(Table.java:845)
      at org.h2.command.dml.Update.update(Update.java:176)
      at org.h2.command.CommandContainer.update(CommandContainer.java:198)
      at org.h2.command.Command.executeUpdate(Command.java:251)
      at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:191)
      at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:152)
      at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
      at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
      at jdk.internal.reflect.GeneratedMethodAccessor2126.invoke(Unknown Source)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:566)
      at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
      at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
      at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
      at com.sun.proxy.$Proxy33.executeUpdate(Unknown Source)
      at fr.spi4j.persistence.dao.jdbc.DaoJdbc_Abs.executeUpdate(DaoJdbc_Abs.java:736)
      ... 78 more