EMM Error (Server: *.com / Exceptiontype: BadSqlGrammarException)

JuergenB · Post by **JuergenB** » Tue Mar 10, 2026 3:45 pm

After or during upgrade from 24.10 to 25.04 i get this log errors.

SQL: SELECT COUNT(*) FROM (SELECT timestamp, username, endpoint, client_ip FROM webservice_usage_log_tbl WHERE (timestamp >= ?)  AND  (timestamp <= ?)  AND  ((username IN ('****@****.de','****@****.de','****@****.de','****@****.de','emm-master','****@****.de')))) selection
Parameter: java.util.Date:'2026-03-10_00:00:00,000', java.util.Date:'2026-03-11_00:00:00,000'
Exception:
BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT COUNT(*) FROM (SELECT timestamp, username, endpoint, client_ip FROM webservice_usage_log_tbl WHERE (timestamp >= ?)  AND  (timestamp <= ?)  AND  ((username IN ('****@****.de')))) selection]
StackTrace:
org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:103)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107)
org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1556)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:677)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:723)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:754)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:767)
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:889)
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:912)
com.agnitas.dao.impl.BaseDaoImpl.selectIntWithDefaultValue(BaseDaoImpl.java:412)
com.agnitas.dao.impl.BaseDaoImpl.selectInt(BaseDaoImpl.java:387)
com.agnitas.dao.impl.PaginatedBaseDaoImpl.selectPaginatedListWithSortClause(PaginatedBaseDaoImpl.java:110)
com.agnitas.dao.impl.PaginatedBaseDaoImpl.selectPaginatedListWithSortClause(PaginatedBaseDaoImpl.java:102)
com.agnitas.dao.impl.PaginatedBaseDaoImpl.selectPaginatedList(PaginatedBaseDaoImpl.java:77)
com.agnitas.emm.core.useractivitylog.dao.impl.SoapUserActivityLogDaoImpl.getUserActivityEntries(SoapUserActivityLogDaoImpl.java:51)
com.agnitas.emm.core.useractivitylog.service.DbUserActivityLogServiceImpl.getSoapUserActivityLogByFilter(DbUserActivityLogServiceImpl.java:117)
com.agnitas.emm.core.useractivitylog.web.SoapUserActivityLogController.preparePaginatedList(SoapUserActivityLogController.java:95)
com.agnitas.emm.core.useractivitylog.web.AbstractUserActivityLogController.lambda$getList$0(AbstractUserActivityLogController.java:88)
com.agnitas.service.impl.PollingServiceImpl$CallablePollable.call(PollingServiceImpl.java:89)
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
java.base/java.lang.Thread.run(Thread.java:840)

Any idea

This table does not exist in 25.04

webservice_usage_log_tbl

Is this some from a old version or from a
premium Release?