Forum Squashtest

Code : Tout sélectionner

[...]
[23-03-17 15:32:37.997] SquashTM - 7937  WARN [squashtest.tm.service.ThreadPoolTaskScheduler-1] [] --- org.hibernate.orm.deprecation: HHH90000022: Hibernate's legacy org.hibernate.Criteria A
PI is deprecated; use the JPA javax.persistence.criteria.CriteriaQuery instead
[23-03-17 15:32:46.053] SquashTM - 7937 ERROR [http-nio-7777-exec-4] [ServletWebRequest: uri=/squash/backend/users;client=127.0.0.1;session=0A4FDE95296C3F838A186B0CA522E468;user=admin] --- o
rg.squashtest.tm.web.backend.exceptionresolver.HandlerExceptionLogger: An exception occured while processing request  : http://localhost:7777/squash/backend/users
org.jooq.exception.DataAccessException: SQL [select `CORE_USER`.`PARTY_ID`, `CORE_USER`.`ACTIVE`, `CORE_USER`.`LOGIN`, `CORE_GROUP`.`QUALIFIED_NAME` as `USER_GROUP`, `CORE_USER`.`FIRST_NAME`
, `CORE_USER`.`LAST_NAME`, `CORE_USER`.`EMAIL`, `CORE_USER`.`CREATED_ON`, `CORE_USER`.`CREATED_BY`, IFNULL(HABILITATION_COUNT, ?) as `HABILITATION_COUNT`, IFNULL(TEAM_COUNT, ?) as `TEAM_COUN
T`, `CORE_USER`.`LAST_CONNECTED_ON` from `CORE_USER` left outer join `CORE_GROUP_MEMBER` on `CORE_GROUP_MEMBER`.`PARTY_ID` = `CORE_USER`.`PARTY_ID` left outer join `CORE_GROUP` on `CORE_GROU
P_MEMBER`.`GROUP_ID` = `CORE_GROUP`.`ID` left outer join (select `CORE_USER`.`PARTY_ID` as `TEAM_MEMBER_ID`, COUNT(`CORE_TEAM_MEMBER`.`TEAM_ID`) as `TEAM_COUNT` from `CORE_USER` left outer j
oin `CORE_TEAM_MEMBER` on `CORE_TEAM_MEMBER`.`USER_ID` = `CORE_USER`.`PARTY_ID` group by `CORE_USER`.`PARTY_ID`) as `ALIAS_9928152` on `ALIAS_9928152`.`TEAM_MEMBER_ID` = `CORE_USER`.`PARTY_I
D` left outer join (select `CORE_USER`.`PARTY_ID` as `USER_ID`, COUNT(`ACL_RESPONSIBILITY_SCOPE_ENTRY`.`ID`) as `HABILITATION_COUNT` from `CORE_USER` left outer join `ACL_RESPONSIBILITY_SCOP
E_ENTRY` on `ACL_RESPONSIBILITY_SCOPE_ENTRY`.`PARTY_ID` = `CORE_USER`.`PARTY_ID` left outer join `ACL_OBJECT_IDENTITY` on `ACL_OBJECT_IDENTITY`.`ID` = `ACL_RESPONSIBILITY_SCOPE_ENTRY`.`OBJEC
T_IDENTITY_ID` where `ACL_OBJECT_IDENTITY`.`CLASS_ID` = ? group by `CORE_USER`.`PARTY_ID`) as `ALIAS_31927684` on `ALIAS_31927684`.`USER_ID` = `CORE_USER`.`PARTY_ID` where (? = ? and ? = ?) 
order by UPPER(`CORE_USER`.`LOGIN`) asc offset ? rows fetch next ? rows only]; (conn=33) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versio
n for the right syntax to use near 'offset 0 rows fetch next 25 rows only' at line 1
        at org.jooq_3.16.11.MARIADB.debug(Unknown Source) ~[?:?]
        at org.jooq.impl.Tools.translate(Tools.java:3103) ~[jooq-3.16.11.jar!/:?]
        at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:670) ~[jooq-3.16.11.jar!/:?]
        at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:354) ~[jooq-3.16.11.jar!/:?]
        at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:284) ~[jooq-3.16.11.jar!/:?]
        at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2843) ~[jooq-3.16.11.jar!/:?]
        at org.squashtest.tm.service.internal.display.grid.AbstractGrid.getRows(AbstractGrid.java:106) ~[tm.service-5.0.0.RELEASE.jar!/:?]
        at org.squashtest.tm.service.internal.display.user.UserDisplayServiceImpl.findAll(UserDisplayServiceImpl.java:147) ~[tm.service-5.0.0.RELEASE.jar!/:?]
        at org.squashtest.tm.service.internal.display.user.UserDisplayServiceImpl$$FastClassBySpringCGLIB$$bba114df.invoke(<generated>) ~[tm.service-5.0.0.RELEASE.jar!/:?]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.23.jar!/:5.3.23]
        [...]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.23.jar!/:5.3.23]
        at org.squashtest.tm.service.internal.display.user.UserDisplayServiceImpl$$EnhancerBySpringCGLIB$$b3d8330.findAll(<generated>) ~[tm.service-5.0.0.RELEASE.jar!/:?]
        at org.squashtest.tm.web.backend.controller.user.UsersAdministrationController.getAllUsers(UsersAdministrationController.java:71) ~[classes!/:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        [...]