Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-869

RS to remove an empty list of members from a course

    XMLWordPrintable

    Details

      Description

      Fehlernummer: N18-E13
      Vorherige Business Pfad: https://xyz.openolat.com/clienia/url/RepositoryEntry/491520/CourseNode/79062820874806
      Business Pfad: https://xyz.openolat.com/clienia/url/RepositoryEntry/3309579/MembersMgmt/0/Members/0/All/0
      Datum und Zeit: 19.11.13 09:27
      Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)

      Error#: N18-E13
      Category/Class: org.olat.core.logging
      Remote IP: 213.196.145.108
      Referer: https://clienia.openolat.com/clienia/auth/1%3A1%3A0%3A0%3A0/
      User-Agent: Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)
      Log msg: *RedScreen* org.hibernate.exception.SQLGrammarException: could not execute statement

      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_confirm_delete</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo></extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>validation ok</command>
      			<tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.group.ui.main.MemberLeaveConfirmationController</controllername>
      		<controllername>org.olat.course.member.MemberListWithOriginFilterController</controllername>
      		<controllername>org.olat.course.member.MembersOverviewController</controllername>
      		<controllername>org.olat.course.member.MembersManagementMainController</controllername>
      		<controllername>org.olat.course.run.RunMainController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      		<controllername>org.olat.core.commons.chiefcontrollers.controller.simple.SimpleBaseController</controllername>
      		<controllername>org.olat.core.commons.chiefcontrollers.BaseChiefController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      Cause: 
      
      stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.SQLGrammarException: could not execute statement
      -> at org.olat.core.gui.exception.ExceptionWindowController.<init>(ExceptionWindowController.java:107)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:57)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:46)
         at org.olat.core.gui.components.Window.dispatchRequest(Window.java:508)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:226)
         at org.olat.core.gui.components.Component.dispatchRequest(Component.java:192)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:227)
         at org.olat.core.dispatcher.DispatcherAction.execute(DispatcherAction.java:154)
         at org.olat.core.servlets.OLATServlet.doPost(OLATServlet.java:155)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
         at org.olat.core.servlets.OLATServlet.service(OLATServlet.java:112)
      
      stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
      -> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
         at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
         at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397)
         at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:108)
         at org.olat.basesecurity.BaseSecurityManager.removeIdentityFromSecurityGroups(BaseSecurityManager.java:642)
         at org.olat.repository.RepositoryManager.removeMembers(RepositoryManager.java:2165)
         at org.olat.group.ui.main.AbstractMemberListController.doLeave(AbstractMemberListController.java:486)
         at org.olat.group.ui.main.AbstractMemberListController.event(AbstractMemberListController.java:326)
         at org.olat.course.member.MemberListWithOriginFilterController.event(MemberListWithOriginFilterController.java:69)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:239)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      
      stack of 3.cause::org.hibernate.exception.SQLGrammarException: could not execute statement
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
         at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:103)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:414)
         at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:282)
         at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1290)
         at org.hibernate.internal.QueryImpl.executeUpdate(QueryImpl.java:116)
         at org.hibernate.ejb.QueryImpl.internalExecuteUpdate(QueryImpl.java:196)
      
      stack of 4.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) and (secgroup_id in (3178583 , 3178584 , 3178585))'
      at line 1
      -> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
         at java.lang.reflect.Constructor.newInstance(Unknown Source)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
         at com.mysql.jdbc.Util.getInstance(Util.java:386)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)empty
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: