-
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
-
Funded by:
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>org.olat.core.gui.control.Event</class> <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)