Greetings,
When I go into the "groups" tab to do administration on a particular group I get the following error. it's similar to one I emailed with the subject "OpenOLAT archiving results.
I have over 2100 users and am using OpenOLAT 9.4.3 (Build openolat943-dev)
Thanks for your assistance.
Â
Â
message:ORA-01795: maximum number of
expressions in a list is 1000
,java.sql.SQLSyntaxErrorException
Â
Â
Any assistance would be great. Thank you.
Â
<dispatchinfo>
               <componentinfo>
                              <compname>bgTree</compname>
                              <compclass>org.olat.core.gui.components.tree.MenuTree</compclass>
                              <extendedinfo>n/a</extendedinfo>
                              <event>
                                             <class>org.olat.core.gui.components.tree.TreeEvent</class>
                                             <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)
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)
...
...
...