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

RS in coaching tool with PostgreSQL

    XMLWordPrintable

    Details

      Description

      How to reproduce:

      • In user management, search a user
      • Select the statements tab
      • Click the button "Coaching"
        -> Red screen
      2016-03-07 07:52:41,611 [ajp-nio2-8003-exec-6] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N3-E1 ^%^ org.olat.core.logging 
      
      https://xyz.olat.com/auth/UserAdminSite/0/usearch/0/table/0/Identity/4784257/tab/7 ^%^ Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/601.4.4 (KHTML, like Gecko) Version/9.0.3 Safari/601.4.4
      **RedScreen** org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_cert_statement_list</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.components.form.flexible.impl.FormEvent</class&gt;
      			<command>done</command>
      			<tostring>com:done,org.olat.core.gui.components.form.flexible.impl.FormEvent@2f23a1</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.course.certificate.ui.CertificateAndEfficiencyStatementListController</controllername>
      		<controllername>org.olat.admin.user.UserAdminController</controllername>
      		<controllername>org.olat.core.gui.components.table.TableController</controllername>
      		<controllername>org.olat.admin.user.UsermanagerUserSearchController</controllername>
      		<controllername>org.olat.admin.UserAdminMainController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      
      >>> stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> 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:536)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:234)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:298)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:216)
         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.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
         at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)
         at org.olat.modules.coach.manager.CoachingDAO.getUsersStatisticsInfos(CoachingDAO.java:827)
         at org.olat.modules.coach.manager.CoachingDAO.getUsersStatisticsNative(CoachingDAO.java:797)
         at org.olat.modules.coach.manager.CoachingServiceImpl.getUsersStatistics(CoachingServiceImpl.java:74)
         at org.olat.modules.coach.ui.UserListController.loadModel(UserListController.java:127)
         at org.olat.modules.coach.ui.UserListController.search(UserListController.java:147)
         at org.olat.modules.coach.ui.UserSearchController.doSearchByIdentityKey(UserSearchController.java:100)
         at org.olat.modules.coach.ui.UserSearchController.activate(UserSearchController.java:79)
         at org.olat.modules.coach.ui.CoachMainController.activate(CoachMainController.java:112)
      >>> stack of 3.cause::org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
         at org.hibernate.loader.Loader.doQuery(Loader.java:910)
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
         at org.hibernate.loader.Loader.doList(Loader.java:2554)
      >>> stack of 4.cause::org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint ~~ bigint
      

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 15 seconds
                1h