Date : 06/02 11:15:00.055 Utilisateur : admin#admin_population Thread : Thread[CacheMonitoringScheduler,5,main] Niveau : ERROR Catégorie : org.ametys.web.cache.monitoring.process.statistics.ResourceStatisticsComponent URI de la requête : /nightly-intranet-cms/_admin/plugins/admin/config/set Message : Exception during update cache stats Emplacement : org.ametys.web.cache.monitoring.process.statistics.ResourceStatisticsComponent._update(ResourceStatisticsComponent.java:96) Pile d'appels : org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='Page_Path_Hash', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #2 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'. ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: INSERT INTO Cache_Stats_Back (Page_Id, Page_Path_Hash, Page_Path, Rendering_Context, Workspace_JCR, Cacheable, Hits, Created_At, Updated_At) values (?, ?, ?, ?, ?, ?, ?, ?, ?) ### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='Page_Path_Hash', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #2 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'. at $1org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at $1org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200) at $1org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185) at $1org.ametys.web.cache.monitoring.process.statistics.impl.PageResourceStatistics.createStat(PageResourceStatistics.java:98) at $1org.ametys.web.cache.monitoring.process.statistics.ResourceStatisticsComponent._updateCacheStats(ResourceStatisticsComponent.java:114) at $1org.ametys.web.cache.monitoring.process.statistics.ResourceStatisticsComponent._update(ResourceStatisticsComponent.java:78) at $1org.ametys.web.cache.monitoring.process.statistics.ResourceStatisticsComponent.updateStatistics(ResourceStatisticsComponent.java:56) at $1org.ametys.web.cache.monitoring.process.CacheMonitoringScheduler.run(CacheMonitoringScheduler.java:128) at $1java.util.TimerThread.mainLoop(Timer.java:555) at $1java.util.TimerThread.run(Timer.java:505) Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='Page_Path_Hash', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #2 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'. at $1org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:89) at $1org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:93) at $1org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64) at $1org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) at $1org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49) at $1org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at $1org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at $1org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198) ... 8 more Caused by: org.apache.ibatis.type.TypeException: Error setting null for parameter #2 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'. at $1org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:47) at $1org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:87) ... 15 more Caused by: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'. at $1org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(Unknown Source) at $1org.apache.derby.impl.jdbc.EmbedPreparedStatement.setNull(Unknown Source) at $1org.apache.commons.dbcp2.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:107) at $1org.apache.commons.dbcp2.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:107) at $1org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:45) ... 16 more Caused by: java.sql.SQLException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'. at $1org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at $1org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 27 more