[Using Sakai] Samigo Test shows 1 student in progress - crashes on export

Warwick Chapman warwickchapman at gmail.com
Thu Oct 21 00:57:43 PDT 2010


Pretty please...

Can someone help me with building an SQL query to extract the scores and
student names... its a bit of a crisis now.


-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com


On Thu, Oct 21, 2010 at 9:27 AM, Yzelle, Sonette <SYzelle at unisa.ac.za>wrote:

>  This message (and attachments) is subject to restrictions and a
> disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full
> details.
>  ------------------------------
>
>  Hi Karen,
>
>
>
> Thank you for your reply.
>
> No our problem is not the same as SAM-1026.
>
> I suspected that the error was happening in the mentioned rows below, but
> know after your email realize that I was on our development box and that
> there is no active students for that assessment.
>
>
>
> There are active students on production so the error below is caused by
> something else.
>
> Here is the error we are getting:
>
> 010-10-20 07:48:13,542 ERROR
> [com.sun.faces.lifecycle.InvokeApplicationPhase] -
> <java.lang.RuntimeException: failed to call histogramScores.>
>
> javax.faces.el.EvaluationException: java.lang.RuntimeException: failed to
> call histogramScores.
>
>       at
> com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:130)
>
>       at javax.faces.component.UICommand.broadcast(UICommand.java:305)
>
>       at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
>
>       at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
>
>       at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
>
>       at
>
>
>
> I am still investigating what is causing this bug but please if you’ve got
> any ideas on how to resolve it send it to me.
>
>
>
> Regards
>
> Sonette
>
>
>
> Sonette Yzelle
>
> Analyst Developer
>
> ICT
>
> UNISA
>
> South Africa
>
> email: syzelle at unisa.ac.za
>
>
>
> *From:* ktsao at hungs.org [mailto:ktsao at hungs.org] *On Behalf Of *Karen Tsao
> *Sent:* 20 October 2010 07:28 PM
> *To:* Yzelle, Sonette
> *Cc:* Warwick Chapman; sakai-user
>
> *Subject:* Re: [Using Sakai] Samigo Test shows 1 student in progress -
> crashes on export
>
>
>
> Warwick and Sonette,
>
> The lines you pointed out happens when there is no active student for that
> assessment, not just one student. Can you please check your assessment and
> let me know?
>
> Also, what make you think the error happens from these lines? Do you think
> http://jira.sakaiproject.org/browse/SAM-1026 report the same issue? We
> haven't been able to find out a case to figure out the cause. Can you
> reproduce this error consistently? If yes, can you do the follow queries and
> send me the results:
>
> SELECT * from sam_assessmentgrading_t ag, sam_publishedassessment_t pa
> WHERE ag.publishedassessmentid = pa.id AND pa.title = :assessment_title
> SELECT * FROM sam_itemgrading_t WHERE assessmentgradingid =
> :assessment_grading_id
>
> Thanks,
> Karen
>
>
>  On Wed, Oct 20, 2010 at 6:38 AM, Yzelle, Sonette <SYzelle at unisa.ac.za>
> wrote:
>
> This message (and attachments) is subject to restrictions and a disclaimer.
> Please refer to http://www.unisa.ac.za/disclaimer for full details.
>  ------------------------------
>
>
>
> I was going through the program to try and see what is wrong.
>
> I think our export might be breaking at this point:
>
>
>
> HistogramListener.java method: histogramScores
>
> If (!iter.hasNext)) {
>
>                 Log.info(“Students who have submitted may have been removed
> from this site”);
>
> Return false;
>
> }
>
>
>
> Will the export break if a user is not found?
>
> Any suggestions?
>
>
>
> Thanks
>
> Sonette
>
>
>
>
>
> Sonette Yzelle
>
> Analyst Developer
>
> ICT
>
> UNISA
>
> South Africa
>
> email: syzelle at unisa.ac.za
>
>
>
> *From:* sakai-user-bounces at collab.sakaiproject.org [mailto:
> sakai-user-bounces at collab.sakaiproject.org] *On Behalf Of *Yzelle, Sonette
> *Sent:* 20 October 2010 07:52 AM
> *To:* Warwick Chapman; Karen Tsao
>
>
> *Cc:* sakai-user
> *Subject:* Re: [Using Sakai] Samigo Test shows 1 student in progress -
> crashes on export
>
>
>
> This message (and attachments) is subject to restrictions and a disclaimer.
> Please refer to http://www.unisa.ac.za/disclaimer for full details.
>  ------------------------------
>
>
>
> Hi,
>
>
>
> We are also experiencing problems when we try to export.  However not the
> same as Warwick.
>
> Any ideas how to solve this problem please (patch for jira SAM_748 was
> applied).  We are on Sakai 2.6.2.
>
>
>
> Below the error report:
>
>
>
> 010-10-20 07:48:13,542 ERROR
> [com.sun.faces.lifecycle.InvokeApplicationPhase] -
> <java.lang.RuntimeException: failed to call histogramScores.>
>
> javax.faces.el.EvaluationException: java.lang.RuntimeException: failed to
> call histogramScores.
>
>       at
> com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:130)
>
>       at javax.faces.component.UICommand.broadcast(UICommand.java:305)
>
>       at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
>
>       at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
>
>       at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
>
>       at
> com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
>
>       at
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
>
>       at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
>       at
> org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:565)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
>       at
> org.sakaiproject.jsf.util.SamigoJsfTool.dispatch(SamigoJsfTool.java:285)
>
>       at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
>
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
>
>       at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
>       at
> org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:486)
>
>       at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1216)
>
>       at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:188)
>
>       at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:93)
>
>       at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:70)
>
>       at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1059)
>
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
>       at
> org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:616)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
>       at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
>       at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>
>       at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>
>       at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
>       at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>
>       at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>
>       at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
>
>       at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>
>       at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>
>       at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>
>       at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>
>       at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>
>       at java.lang.Thread.run(Thread.java:619)
>
> Caused by: java.lang.RuntimeException: failed to call histogramScores.
>
>       at
> org.sakaiproject.tool.assessment.ui.listener.evaluation.HistogramListener.getDetailedStatisticsSpreadsheetData(HistogramListener.java:1944)
>
>       at
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.getSpreadsheetData(ExportResponsesBean.java:181)
>
>       at
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.exportExcel(ExportResponsesBean.java:174)
>
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>       at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>       at java.lang.reflect.Method.invoke(Method.java:597)
>
>       at
> com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
>
>       ... 51 more
>
>
>
>
>
> Regards
>
> Sonette
>
>
>
>
>
>
>
> Sonette Yzelle
>
> Analyst Developer
>
> ICT
>
> UNISA
>
> South Africa
>
> email: syzelle at unisa.ac.za
>
>
>
> *From:* sakai-user-bounces at collab.sakaiproject.org [mailto:
> sakai-user-bounces at collab.sakaiproject.org] *On Behalf Of *Warwick Chapman
> *Sent:* 20 October 2010 07:48 AM
> *To:* Karen Tsao
> *Cc:* sakai-user
> *Subject:* Re: [Using Sakai] Samigo Test shows 1 student in progress -
> crashes on export
>
>
>
> Karen
>
> Not much information available I'm afraid...
>
> In browser, error is:
>
> An internal server error occurred. Please try again later.
>
> --
>
> This is all that shows in log:
>
> 2010-10-20 07:44:53,194  INFO http-8080-Processor9
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean -
> Samigo export (37 columns): Using xsl format
> 2010-10-20 07:44:53,206 ERROR http-8080-Processor9
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean -
> ClientAbortException:  java.net.SocketException: Broken pipe
> 2010-10-20 07:44:53,207 ERROR http-8080-Processor9
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean -
> ClientAbortException:  java.net.SocketException: Broken pipe
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>
> On Wed, Oct 20, 2010 at 1:23 AM, Karen Tsao <ktsao at stanford.edu> wrote:
>
> Warwick,
>
> Can you send me the error report and the related tomcat log?
>
> Thanks,
> Karen
>
>
>
> On Tue, Oct 19, 2010 at 9:41 AM, Warwick Chapman <warwickchapman at gmail.com>
> wrote:
>
> I don't get an exported file.  I get a crash report.
>
>
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>
> On Tue, Oct 19, 2010 at 6:20 PM, Karen Tsao <ktsao at stanford.edu> wrote:
>
> Warwick,
>
> What do you see after exported? An empty file or some errors? Do the scores
> pages (Total Scores, Question Score, View Student Score, etc) look ok?
>
> Thanks,
> Karen
>
> On Tue, Oct 19, 2010 at 9:13 AM, Warwick Chapman <warwickchapman at gmail.com>
> wrote:
>
>  Howdy
>
> I cannot export the test results of my Samigo test and I assume the cause
> is that, for some reason, the test shows 1 student in progress and 126
> completed.
>
> Any thoughts?
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
>
>
>
>
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20101021/d795633f/attachment-0001.html 


More information about the sakai-user mailing list