[Using Sakai] Samigo Test shows 1 student in progress - crashes on export
Yzelle, Sonette
SYzelle at unisa.ac.za
Thu Oct 21 01:05:31 PDT 2010
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________
Hi Warwick,
I think this select should do it?
SELECT AG.ASSESSMENTGRADINGID, AG.AGENTID, IM.EID, AG.SUBMITTEDDATE,AG.FORGRADE, AG.TOTALAUTOSCORE, AG.FINALSCORE
from sam_assessmentgrading_t ag, sam_publishedassessment_t pa, sakai_user_id_map im
WHERE ag.publishedassessmentid = pa.id
AND pa.title = :ASSESSMENT_TITLE
AND ag.agentid = im.user_id;
Please test and see if it returns what you need. You can just change the select columns to your need.
Regards
Sonette
Sonette Yzelle
Analyst Developer
ICT
UNISA
South Africa
email: syzelle at unisa.ac.za<mailto:syzelle at unisa.ac.za>
From: warwick.chapman at gmail.com [mailto:warwick.chapman at gmail.com] On Behalf Of Warwick Chapman
Sent: 21 October 2010 09:58 AM
To: Yzelle, Sonette
Cc: Karen Tsao; sakai-user
Subject: Re: [Using Sakai] Samigo Test shows 1 student in progress - crashes on export
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<mailto: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<mailto:syzelle at unisa.ac.za>
From: ktsao at hungs.org<mailto:ktsao at hungs.org> [mailto: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<http://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<mailto: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<mailto:syzelle at unisa.ac.za>
From: sakai-user-bounces at collab.sakaiproject.org<mailto:sakai-user-bounces at collab.sakaiproject.org> [mailto: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<mailto:syzelle at unisa.ac.za>
From: sakai-user-bounces at collab.sakaiproject.org<mailto:sakai-user-bounces at collab.sakaiproject.org> [mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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/9c714d34/attachment-0001.html
More information about the sakai-user
mailing list