[Building Sakai] Samigo exception - markup text

[Karen Tsao]

Hi Sonette,

You don't need to delete that assessment. I think this should be caused by
ReleaseTo column is null and 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
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

Is the ReleaseTo coulmn null? If yes, 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.

Please let me know if this can fix your issue.

Thanks,
Karen


On Tue, Aug 21, 2012 at 5:42 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.
>  ------------------------------
>
>  Good day,****
>
> ** **
>
> I am from Unisa and we are on Sakai 2.8.0****
>
> ** **
>
> We are getting the following exception on Samigo.****
>
> ** **
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException****
>
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
> ****
>
> caused by: org.sakaiproject.tool.api.ToolException****
>
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1429)
> ****
>
> caused by: org.apache.jasper.JasperException****
>
>     at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
> ****
>
> caused by: java.lang.NullPointerException****
>
>     at
> org.sakaiproject.tool.assessment.facade.PublishedAssessmentFacadeQueries.getBasicInfoOfAllPublishedAssessments2(PublishedAssessmentFacadeQueries.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)****
>
> ** **
>
> The user used markup text to create the assessment.  I see that this
> exception was handled in SAM-1376 and SAM-1431.****
>
> We are using Sakai 2.8.0, so Sam_2.8.0.****
>
> I see that the changes for SAM-1376 and SAM-1431 is in
> /sam/branches/samigo-2.8.x****
>
> I checked /sam/branches/samigo-2.8.x out but the error still occurs.****
>
> ** **
>
> I don’t know what I am missing. Maybe I should delete the assessment but
> this will include deletes from many tables and I am not sure which ones.**
> **
>
> ** **
>
> Hope someone can help.****
>
> ** **
>
> Regards****
>
> Sonette****
>
> ** **
>
> Sonette Yzelle****
>
> Analyst Developer****
>
> Portal and Academic Solutions****
>
> ICT****
>
> UNISA****
>
> ** **
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120821/aa731efc/attachment.html