[Building Sakai] Missing SAM_PUBLISHEDACCESSCONTROL_T record from a published quiz

[Karen Tsao]

Hi George,

This might be due to import from another site or duplicate an assessment.
Do you have the fix in https://jira.sakaiproject.org/browse/SAM-1383,
https://jira.sakaiproject.org/browse/SAM-1431, and
https://jira.sakaiproject.org/browse/SAM-1559 applied?

Thanks,
Karen

On Mon, Sep 17, 2012 at 2:39 PM, George Pipkin <gpp8p at virginia.edu> wrote:

> Hi -
>
>    We have encountered a samigo quiz that somehow got corrupted in the
> database
> in a way that prevents T&Q from showing a list of published assessments.
>  When it
> tries to, it crashes with an NPE in PublishedAssessmentFacadeQuesi**es on
> line 1506
> where it is checking to see the releasedTo status of every quiz in the
> list:
>
>             releaseToGroups = null;
> null pointer error---> if (p.getReleaseTo().equals(**
> AssessmentAccessControl.**RELEASE_TO_SELECTED_GROUPS)) {
>                 if (groupsForSite == null) {
>
>    I poked around the database to see what I ciould find on this, and I
> noticed that a published assessment's
> SAM_PUBLISHEDASSESSMENT_T record in this site did not have an associated
>  SAM_PUBLISHEDACCESSCONTROL_T
> record.  The query appearing above this line:
>
>
>         String query = "select new PublishedAssessmentData(p.**publishedAssessmentId,
> p.title, "
>                 + " c.releaseTo, c.startDate, c.dueDate, c.retractDate,
> p.status, p.lastModifiedDate, p.lastModifiedBy, "
>                 + "c.lateHandling, c.unlimitedSubmissions,
> c.submissionsAllowed) "
>                 + " from PublishedAssessmentData p, PublishedAccessControl
> c, AuthorizationData z  "
>                 + " where c.assessment.**publishedAssessmentId =
> p.publishedAssessmentId "
>                 + " and p.publishedAssessmentId=z.**qualifierId and
> z.functionId=:functionId "
>                 + " and z.agentIdString=:siteId and
> (p.status=:activeStatus or p.status=:editStatus) "
>                 + " order by p." + orderBy;
>
> pulls data from three tables SAM_PUBLISHEDACCESSCONTROL_T,
> SAM_PUBLISHEDASSESSMENT_T, SAM_AUTHZDATA_T.
>
> To add to the mystery, I put some code around where the crash was
> happening so I could get into T&Q for this site
> without it crashing, and what I saw for the assessments in question is
> shown in the screen grab attached to this
> message.  Looking at the events table, I can see somebody trying to modify
> one of these at about the time when the
> problem started.
>
> My question to sakai-dev (and the samigo team) - is it always necessary
> for a published assessment to have an associated
> SAM_PUBLISHEDACCESSCONTROL_T, record ?  How could the query above
> "succeed" and yet return a null value if that record
> is somehow missing ?
>
>                - George Pipkin
>                   U.Va.
>
> _______________________________________________
> 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/20120917/bae1c39d/attachment.html