[Building Sakai] A site's samigo in broken state
Karen Tsao
ktsao at stanford.edu
Fri Sep 21 12:31:38 PDT 2012
Hi Jean-Francois,
Good to know your issue has been fixed.
> SAM-1559 is a duplicate of https://jira.sakaiproject.org/**browse/SAM-1398<https://jira.sakaiproject.org/browse/SAM-1398>which has not been fixed in the 2.8.x branch yet.
>
I have merged SAM-1398 to 2.8.x.
Thanks,
Karen
>
> Thanks,
>
> J-F
>
>
> On 20/09/2012 18:39, Karen Tsao wrote:
>
>> Hi Jean-Francois,
>>
>> This might be due to import from another site or duplicate an
>> assessment. If this is the case, I think you should have null ReleaseTo
>> column in your db, and this can be fixed by updating that field. Can you
>> run the following query:
>>
>> // the assessment causing problem
>> SELECT * FROM sam_authzdata_t a, sakai_site s, sam_publishedassessment_t
>> pa
>> where a.agentid = s.site_id
>> and functionid = 'GRADE_PUBLISHED_ASSESSMENT'
>> and a.qualifierid = pa.id <http://pa.id/>
>>
>> and s.title = :site_title
>> and pa.title = :assessment_title
>>
>> You can get the published assessment id from here. And use it for the
>> following query.
>>
>> // the setting data of that assessment
>> SELECT * FROM SAM_PUBLISHEDACCESSCONTROL_T S where assessmentid =
>> :published_assessment_id
>>
>> If the ReleaseTo coulmn null, you can change it to "Anonymous Users" if
>> the assessment releases to anonymous, change it to the site title if it
>> releases to Site, or change it to "Selected Groups" if it releases to
>> groups.
>>
>> Except SAM-1431, you might want to apply SAM-1383
>> <https://jira.sakaiproject.**org/browse/SAM-1383<https://jira.sakaiproject.org/browse/SAM-1383>>
>> and SAM-1559
>> <https://jira.sakaiproject.**org/browse/SAM-1559<https://jira.sakaiproject.org/browse/SAM-1559>
>> >.
>>
>>
>> Thanks,
>> Karen
>>
>> On Thu, Sep 20, 2012 at 6:48 AM, Jean-Francois Leveque
>> <jean-francois.leveque at upmc.fr <mailto:jean-francois.leveque@**upmc.fr<jean-francois.leveque at upmc.fr>
>> >>
>>
>> wrote:
>>
>> Hi all,
>>
>> I'm currently supporting a Sakai CLE 2.8.1 install.
>>
>> One of our users has been able to completely break samigo in his site
>> without being able to explain how.
>>
>> When looking for similar issues from the trace I get accessing the
>> course's Samigo, I only found the following.
>>
>> It should not be SAM-1376 because it has been fixed in Samigo 2.8.3
>> which is already part of CLE 2.8.1.
>>
>> It could have been SAM-1431 but upgrading CLE 2.8.1's Samigo from
>> 2.8.3
>> to 2.8.5 on a test server with restored production data does not fix
>> the
>> issue.
>>
>> Is it a different issue?
>>
>> Is there something to do in the database?
>>
>> The trace follows.
>>
>> Cheers,
>>
>> J-F
>>
>> java.lang.NullPointerException
>> at
>> org.sakaiproject.tool.**assessment.facade.**
>> PublishedAssessmentFacadeQueri**es.**getBasicInfoOfAllPublishedAsse**
>> ssments2(**PublishedAssessmentFacadeQueri**es.java:1506)
>> 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
>> org.springframework.aop.**support.AopUtils.**
>> invokeJoinpointUsingReflection**(AopUtils.java:307)
>> at
>> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**
>> invokeJoinpoint(**ReflectiveMethodInvocation.**java:182)
>> at
>> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**
>> proceed(**ReflectiveMethodInvocation.**java:149)
>> at
>> org.springframework.**transaction.interceptor.**
>> TransactionInterceptor.invoke(**TransactionInterceptor.java:**106)
>> at
>> org.springframework.aop.**framework.**ReflectiveMethodInvocation.**
>> proceed(**ReflectiveMethodInvocation.**java:171)
>> at
>> org.springframework.aop.**framework.JdkDynamicAopProxy.**
>> invoke(JdkDynamicAopProxy.**java:204)
>> at $Proxy37.**getBasicInfoOfAllPublishedAsse**
>> ssments2(Unknown
>> Source)
>> at
>> org.sakaiproject.tool.**assessment.services.**assessment.**
>> PublishedAssessmentService.**getBasicInfoOfAllPublishedAsse**ssments2(**
>> PublishedAssessmentService.**java:92)
>> at
>> org.sakaiproject.tool.**assessment.ui.listener.author.**
>> AuthorActionListener.**prepareAllPublishedAssessments**
>> List(AuthorActionListener.**java:132)
>> at
>> org.sakaiproject.tool.**assessment.ui.listener.author.**
>> AuthorActionListener.**prepareAssessmentsList(**
>> AuthorActionListener.java:128)
>> at
>> org.sakaiproject.tool.**assessment.ui.listener.author.**
>> AuthorActionListener.**processAction(**AuthorActionListener.java:100)
>> at
>> org.apache.jsp.jsf.index.**mainIndex_jsp._jspService(**
>> mainIndex_jsp.java:96)
>> at
>> org.apache.jasper.runtime.**HttpJspBase.service(**
>> HttpJspBase.java:98)
>> at
>> javax.servlet.http.**HttpServlet.service(**HttpServlet.java:729)
>> at
>> org.apache.jasper.servlet.**JspServletWrapper.service(**
>> JspServletWrapper.java:369)
>> at
>> org.apache.jasper.servlet.**JspServlet.serviceJspFile(**
>> JspServlet.java:308)
>> at
>> org.apache.jasper.servlet.**JspServlet.service(JspServlet.**java:259)
>> at
>> javax.servlet.http.**HttpServlet.service(**HttpServlet.java:729)
>> 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:598)
>> 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:**659)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.**processRequest(**
>> ApplicationDispatcher.java:**457)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.**doForward(**
>> ApplicationDispatcher.java:**395)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.forward(**
>> ApplicationDispatcher.java:**311)
>> at
>> com.sun.faces.context.**ExternalContextImpl.dispatch(**
>> ExternalContextImpl.java:322)
>> at
>> com.sun.faces.application.**ViewHandlerImpl.renderView(**
>> ViewHandlerImpl.java:130)
>> at
>> org.sakaiproject.jsf.app.**SakaiViewHandler.renderView(**
>> SakaiViewHandler.java:154)
>> at
>> com.sun.faces.lifecycle.**RenderResponsePhase.execute(**
>> RenderResponsePhase.java:87)
>> at
>> com.sun.faces.lifecycle.**LifecycleImpl.phase(**
>> LifecycleImpl.java:200)
>> at
>> com.sun.faces.lifecycle.**LifecycleImpl.render(**
>> LifecycleImpl.java:117)
>> at
>> javax.faces.webapp.**FacesServlet.service(**FacesServlet.java:198)
>> 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:598)
>> 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:**659)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.**processRequest(**
>> ApplicationDispatcher.java:**457)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.**doForward(**
>> ApplicationDispatcher.java:**395)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.forward(**
>> ApplicationDispatcher.java:**311)
>> at
>> org.sakaiproject.jsf.util.**SamigoJsfTool.dispatch(**
>> SamigoJsfTool.java:301)
>> at org.sakaiproject.jsf.util.**JsfTool.doGet(JsfTool.java:*
>> *241)
>> at
>> javax.servlet.http.**HttpServlet.service(**HttpServlet.java:627)
>> at
>> javax.servlet.http.**HttpServlet.service(**HttpServlet.java:729)
>> 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:**659)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.**processRequest(**
>> ApplicationDispatcher.java:**457)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.**doForward(**
>> ApplicationDispatcher.java:**359)
>> at
>> org.apache.catalina.core.**ApplicationDispatcher.forward(**
>> ApplicationDispatcher.java:**311)
>> at
>> org.sakaiproject.tool.impl.**ActiveToolComponent$**
>> MyActiveTool.forward(**ActiveToolComponent.java:511)
>> at
>> org.sakaiproject.portal.**charon.SkinnableCharonPortal.**forwardTool(
>> **SkinnableCharonPortal.java:**1429)
>> at
>> org.sakaiproject.portal.**charon.handlers.ToolHandler.**
>> doTool(ToolHandler.java:204)
>> at
>> org.sakaiproject.portal.**charon.handlers.ToolHandler.**
>> doGet(ToolHandler.java:96)
>> at
>> org.sakaiproject.portal.**charon.SkinnableCharonPortal.**
>> doGet(SkinnableCharonPortal.**java:862)
>> at
>> javax.servlet.http.**HttpServlet.service(**HttpServlet.java:627)
>> at
>> javax.servlet.http.**HttpServlet.service(**HttpServlet.java:729)
>> 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:659)
>> 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:172)
>> 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.jk.server.**JkCoyoteHandler.invoke(**
>> JkCoyoteHandler.java:200)
>> at
>> org.apache.jk.common.**HandlerRequest.invoke(**
>> HandlerRequest.java:291)
>> at
>> org.apache.jk.common.**ChannelSocket.invoke(**ChannelSocket.java:775)
>> at
>> org.apache.jk.common.**ChannelSocket.**processConnection(**
>> ChannelSocket.java:704)
>> at
>> org.apache.jk.common.**ChannelSocket$**SocketConnection.runIt(**
>> ChannelSocket.java:897)
>> at
>> org.apache.tomcat.util.**threads.ThreadPool$**ControlRunnable.run(**
>> ThreadPool.java:689)
>> at java.lang.Thread.run(Thread.**java:662)
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120921/f6c0aed1/attachment.html
More information about the sakai-dev
mailing list