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

RS in archive course log if the number of excluded identities is bigger than 1000

    XMLWordPrintable

    Details

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

      Description

      <dispatchinfo>
          <componentinfo>
              <compname>cmd.start</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.start</command>
                  <tostring>com:cmd.start,org.olat.core.gui.control.Event@904fdecd</tostring>
              </event>
          </componentinfo>
          <controllerinfo>
              <controllername>org.olat.course.archiver.ScoreAccountingArchiveController</controllername>
              <controllername>org.olat.course.archiver.ArchiverMainController</controllername>
              <controllername>org.olat.course.run.RunMainController</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>
      
      Throwable: org.olat.core.logging.DBRuntimeException
      
      logmsg:Error in list()
      message:Error in list(),org.olat.core.logging.DBRuntimeException
      
      at org.olat.core.commons.persistence.DBQueryImpl.list(DBQueryImpl.java:180)
      at org.olat.course.properties.PersistingCoursePropertyManager.getAllIdentitiesWithCourseAssessmentData(PersistingCoursePropertyManager.java:242)
      at org.olat.course.archiver.ScoreAccountingHelper.loadUsers(ScoreAccountingHelper.java:397)
      at org.olat.course.archiver.ScoreAccountingArchiveController.doStartExport(ScoreAccountingArchiveController.java:97)
      at org.olat.course.archiver.ScoreAccountingArchiveController.event(ScoreAccountingArchiveController.java:85)
      at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:195)
      at org.olat.core.gui.components.Component$1.run(Component.java:238)
      at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      at org.olat.core.gui.components.Component.fireEvent(Component.java:236)
      at org.olat.core.gui.components.link.Link.dispatch(Link.java:188)
      
      1. cause:
      
      message:could not extract ResultSet,org.hibernate.exception.SQLGrammarException
      
      at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
      at org.hibernate.loader.Loader.doQuery(Loader.java:906)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
      
      2. cause:
      
      message:ORA-01795: maximum number of expressions in a list is 1000
      ,java.sql.SQLSyntaxErrorException
      
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
      

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              jeff Jeff Underwood
              Tester:
              Jeff Underwood
            • 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
                1h