[Building Sakai] Samigo Export of scores times out

[Stephen Marquard]

For very large sites (we saw this problem in a site with 4500 users), you may want to check your logs for this:

Aug 12, 2013 11:31:49 AM org.apache.tomcat.util.http.Parameters processParameters
INFO: More than the maximum number of request parameters (GET plus POST) for a single request ([10,000]) were detected. Any parameters beyond this limit have been ignored. To change this limit, set the maxParameterCount attribute on the Connector.

In this case, it appears that the JSF request to move to the "Export" page in T&Q posts a very large set of parameters which is exceeding this limit. We worked around this for one specific site with a temporary change by adding maxParameterCount to the connector in conf/server.xml (you'd need to change this to the AJP connector on port 8009 or whatever):

<Connector port="8444" protocol="HTTP/1.1" SSLEnabled="true"
               maxThreads="150" scheme="https" secure="true"
               maxParameterCount="150000"
               clientAuth="false" sslProtocol="TLS" />

This looks like some sort of weird JSF behaviour. With the above change, it worked OK (although the POST request is extremely large).

Regards
Stephen

---
Stephen Marquard, Acting Director
Centre for Educational Technology, University of Cape Town
http://www.cet.uct.ac.za<http://www.cet.uct.ac.za/>
stephen.marquard at uct.ac.za<mailto:stephen.marquard at uct.ac.za>
Phone: +27-21-650-5037 Cell: +27-83-500-5290

From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Nguni Phakela
Sent: 21 August 2013 10:08 AM
To: Sakai Developers; Zaahirah Bhamjee
Subject: [Building Sakai] Samigo Export of scores times out

Hi All,

We are attempting to export scores of Tests&Quizzes in a class of about 27 000 with quite a few questions. The request takes a long time and then times out. I have noted this JIRA,

SAM-753<https://jira.sakaiproject.org/browse/SAM-753?page=com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel>: Spreadsheet export is too slow with large classes

where it looks like this was fixed but with a much smaller class (400). Has anyone else had this issue? Or is there another way we can export the data?

Thanks in advance,

--
Nguni Phakela
________________________________
UNIVERSITY OF CAPE TOWN

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130821/9dc1723f/attachment.html