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

In groups member list, select in with too many keys

    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

      Append with Oracle if a group as more than 1000 members.

      message:ORA-01795: maximum number of expressions in a list is 1000,java.sql.SQLSyntaxErrorException
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>bgTree</compname>
      		<compclass>org.olat.core.gui.components.tree.MenuTree</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.components.tree.TreeEvent</class&gt;
      			<command>ctncl</command>
      			<tostring>TreeEvent:{cmd:ctncl, nodeid:MENU_ADMINISTRATION}</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.group.ui.run.BusinessGroupMainRunController</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.basesecurity.BaseSecurityManager.getIdentitiesByPowerSearch(BaseSecurityManager.java:1660)
        at org.olat.group.ui.main.AbstractMemberListController.updateTableModel(AbstractMemberListController.java:587)
        at org.olat.group.ui.main.AbstractMemberListController.reloadModel(AbstractMemberListController.java:540)
        at org.olat.group.ui.edit.BusinessGroupMembersController.(BusinessGroupMembersController.java:96)
        at org.olat.group.ui.edit.BusinessGroupEditController.(BusinessGroupEditController.java:144)
        at org.olat.group.ui.run.BusinessGroupMainRunController.doAdministration(BusinessGroupMainRunController.java:711)
        at org.olat.group.ui.run.BusinessGroupMainRunController.handleTreeActions(BusinessGroupMainRunController.java:664)
        at org.olat.group.ui.run.BusinessGroupMainRunController.event(BusinessGroupMainRunController.java:375)
        at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:195)
       
      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)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            underwoodjc 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 - 30 minutes
                30m