OpenOLAT: Group Administration

28 views
Skip to first unread message

Jeff Underwood

unread,
May 12, 2015, 2:21:06 PM5/12/15
to open...@googlegroups.com

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)

Stéphane Rossé

unread,
May 15, 2015, 4:06:16 AM5/15/15
to open...@googlegroups.com
Hi

I have fix the issue in OpenOLAT 9.4.x and on the development branch (10.3). You can see the issue here:


Best Regards
Stéphane Rossé
...

Jeff Underwood

unread,
May 15, 2015, 11:33:43 AM5/15/15
to open...@googlegroups.com
Thank you Stéphane. I'll take a look at it.
...

Jeff Underwood

unread,
May 15, 2015, 2:50:28 PM5/15/15
to open...@googlegroups.com
Stéphane,
I applied the fix and it's working just fine.

Thanks for your help.

regards,
Jeff

On Tuesday, May 12, 2015 at 1:21:06 PM UTC-5, Jeff Underwood wrote:
...
Reply all
Reply to author
Forward
0 new messages