Error downloading spreadsheet responses
Description
Attachments
Activity
Michael "Maka" Gradin March 31, 2010 at 11:14 AM
I wasn't able to reproduce this either, but it sounded similar to a problem we came across at Rutgers last year; one of our professors somehow had entered ctrl-k and ctrl-m characters into questions. is the ticket. Hope this helps.
Stephen Marquard January 12, 2010 at 12:39 AM
Could this be merged to 2-6-x please?
Hui Tsao December 15, 2009 at 3:25 PM
Jasmine,
Because this is hard to reproduce, please include this as part of your regression test.
Thanks,
Karen
Stephen Marquard November 23, 2009 at 3:35 AM
We don't know how to reproduce it either. But it appears there is some structural issue in how the questions or answers are recorded, as in the export, we see in one column responses like
|
Yes|
No|
No Answer
In the UI under Questions, there are always 2 responses the 2nd of which is "No Answer", e.g.
Yes
No Answer
The question is "Multiple Choice Survey" for which only a single response is possible.
Hui Tsao November 19, 2009 at 4:30 PM
Stephen,
Can you please let us know how to verify the fix? I don't quite understand how to reproduce this issue. Thanks.
Karen
In one particular site, downloading spreadsheet responses generates an error:
java.lang.NullPointerException
at org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.getExportResponsesData(AssessmentGradingFacadeQueries.java:1893)
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:592)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy92.getExportResponsesData(Unknown Source)
at org.sakaiproject.tool.assessment.services.GradingService.getExportResponsesData(GradingService.java:1709)
at org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.getSpreadsheetData(ExportResponsesBean.java:192)
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:592)
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
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)
which leads to
Caused by: java.lang.NullPointerException
at org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.getSpreadsheetData(ExportResponsesBean.java:193)
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:592)
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
... 52 more