2018-01-03 16:30:26,698 [ajp-nio2-8008-exec-290] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N8-E126 ^%^ org.olat.core.logging
https:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36
**RedScreen** org.hibernate.exception.ConstraintViolationException: could not execute statement
<dispatchinfo>
<componentinfo>
<compname>ffo_main_confirm_delete_permanent</compname>
<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
<extendedinfo>n/a</extendedinfo>
<event>
<class>org.olat.core.gui.components.form.flexible.impl.FormEvent</class>
<command>done</command>
<tostring>com:done,org.olat.core.gui.components.form.flexible.impl.FormEvent@2f23a1</tostring>
</event>
</componentinfo>
<controllerinfo>
<controllername>org.olat.repository.ui.author.ConfirmDeletePermanentlyController</controllername>
<controllername>org.olat.repository.ui.author.AuthorDeletedListController</controllername>
<controllername>org.olat.repository.ui.author.OverviewAuthoringController</controllername>
<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</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:116)
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:549)
at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:242)
at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:273)
at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:190)
at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:289)
at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:232)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
>>> stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
-> at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1514)
at org.olat.modules.portfolio.manager.AssignmentDAO.deleteAssignmentReference(AssignmentDAO.java:342)
at org.olat.modules.portfolio.manager.BinderDAO.deleteSection(BinderDAO.java:610)
at org.olat.modules.portfolio.manager.BinderDAO.deleteBinderTemplate(BinderDAO.java:421)
at org.olat.modules.portfolio.manager.PortfolioServiceImpl.deleteBinderTemplate(PortfolioServiceImpl.java:272)
at org.olat.modules.portfolio.handler.BinderTemplateHandler.cleanupOnDelete(BinderTemplateHandler.java:217)
at org.olat.repository.manager.RepositoryServiceImpl.deletePermanently(RepositoryServiceImpl.java:437)
at org.olat.repository.ui.author.ConfirmDeletePermanentlyController.deleteEntries(ConfirmDeletePermanentlyController.java:293)
at org.olat.repository.ui.author.ConfirmDeletePermanentlyController.doCompleteDelete(ConfirmDeletePermanentlyController.java:240)
>>> stack of 3.cause::org.hibernate.exception.ConstraintViolationException: could not execute statement
-> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3325)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3562)
at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:99)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
>>> stack of 4.cause::org.postgresql.util.PSQLException: ERROR: update or delete on table "o_pf_section" violates foreign key constraint "pf_assign_section_idx" on table "o_pf_assignment"