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

Cannot delete user with orphan ratings

    XMLWordPrintable

    Details

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

      Description

      The delete process is stopped by an error during recalculation of the ratings of a missing resource.

      https://xyz.olat.com/auth/UserAdminSite/0/usearch/0/table/0
      Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36
      Error while deleting identity::183894171 data for and element::CommentAndRatingUserDataManager. Aboring delete process, user partially deleted, but not yet marked as deleted javax.persistence.NoResultException: No entity found for query
       at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1583)
       at org.olat.repository.manager.RepositoryEntryStatisticsDAO.loadStatisticsForUpdate(RepositoryEntryStatisticsDAO.java:143)
       at org.olat.repository.manager.RepositoryEntryStatisticsDAO.update(RepositoryEntryStatisticsDAO.java:156)
       at org.olat.core.commons.services.commentAndRating.manager.UserRatingsDAO.recalculateDelegateRatings(UserRatingsDAO.java:331)
       at org.olat.core.commons.services.commentAndRating.manager.UserRatingsDAO.deleteRatings(UserRatingsDAO.java:296)
       at org.olat.core.commons.services.commentAndRating.manager.CommentAndRatingUserDataManager.deleteUserData(CommentAndRatingUserDataManager.java:81)
       at org.olat.user.manager.lifecycle.UserLifecycleManagerImpl.deleteIdentity(UserLifecycleManagerImpl.java:295)
       at org.olat.user.ui.admin.lifecycle.ConfirmDeleteUserController.doDeleteIdentities(ConfirmDeleteUserController.java:167)
       at org.olat.user.ui.admin.lifecycle.ConfirmDeleteUserController.doDelete(ConfirmDeleteUserController.java:157)
       at org.olat.user.ui.admin.lifecycle.ConfirmDeleteUserController.formInnerEvent(ConfirmDeleteUserController.java:145)
       at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:430)
       at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214)
       at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240)
       at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
       at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:136)
       at org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:737)
       at org.olat.core.gui.components.form.flexible.impl.elements.FormLinkImpl.dispatchFormRequest(FormLinkImpl.java:250)
       at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:568)
       at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:316)
       at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:105)
       at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1249)
       at org.olat.core.gui.components.Window.dispatchRequest(Window.java:429)
       at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:310)
       at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
       at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:282)
       at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:194)
       at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:269)
       at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:216)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
       at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:160)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.olat.core.servlets.HeadersFilter.doFilter(HeadersFilter.java:97)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
       at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:479)
       at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
       at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
       at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1699)
       at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
       at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1050)
       at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$4.completed(Nio2Endpoint.java:630)
       at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$4.completed(Nio2Endpoint.java:608)
       at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126)
       at sun.nio.ch.Invoker$2.run(Invoker.java:218)
       at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
       at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
       at java.lang.Thread.run(Thread.java:748)
      
      

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: