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

RS import a course with several same relations area to group

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 9.4.2
    • Fix Version/s: 9.4.3
    • Component/s: Course
    • Labels:
      None

      Description

      If the xml file in the export package of a course contains severals same relation area to group -> RS.

      ERROR SqlExceptionHelper  - Duplicate entry '446758988-447807489' for key 'group_fk'
      ERROR OLATRuntimeException  - OLAT::ERROR ^%^ N1-E3103 ^%^ org.olat.core.logging
      Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0 ^%^
      **RedScreen** org.hibernate.exception.ConstraintViolationException: could not execute statement
      <dispatchinfo>
      	<componentinfo>
      		<compname>cmd.forward</compname>
      		<compclass>org.olat.core.gui.components.link.Link</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>cmd.forward</command>
      			<tostring>com:cmd.forward,org.olat.core.gui.control.Event@48b4a30</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.repository.controllers.RepositoryCopyController</controllername>
      		<controllername>org.olat.repository.controllers.RepositoryDetailsController</controllername>
      		<controllername>org.olat.repository.controllers.RepositoryMainController</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>
      >>>stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.olat.core.gui.exception.ExceptionWindowController.<init>(ExceptionWindowController.java:115)
         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:516)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:228)
         at org.olat.core.gui.components.Component.dispatchRequest(Component.java:192)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:241)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:197)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:261)
         at org.olat.core.servlets.OpenOLATServlet.doGet(OpenOLATServlet.java:197)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
      >>>stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: 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.QueryImpl.getResultList(QueryImpl.java:277)
         at org.olat.properties.PropertyManager.findProperties(PropertyManager.java:477)
         at org.olat.properties.PropertyManager.findProperties(PropertyManager.java:415)
         at org.olat.properties.PropertyManager.findProperty(PropertyManager.java:568)
         at org.olat.group.manager.BusinessGroupPropertyDAO.findProperty(BusinessGroupPropertyDAO.java:186)
         at org.olat.group.manager.BusinessGroupPropertyDAO.updateDisplayMembers(BusinessGroupPropertyDAO.java:101)
         at org.olat.group.manager.BusinessGroupImportExport.importGroups(BusinessGroupImportExport.java:321)
         at org.olat.group.manager.BusinessGroupServiceImpl.importGroups(BusinessGroupServiceImpl.java:1727)
         at org.olat.course.groupsandrights.PersistingCourseGroupManager.importCourseBusinessGroups(PersistingCourseGroupManager.java:367)
      >>>stack of 3.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74)
         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:189)
         at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079)
         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
         at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
         at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:393)
         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:385)
      >>>stack of 4.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '446758988-447807489' for key 'group_fk'
      -> 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:1041)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
      

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 30 minutes
                30m