[Building Sakai] Assignment "In/New" counts all read 0 after upgrade

Tue Jul 6 08:44:34 PDT 2010

I don't think so.
I see that the "XML" column in ASSIGNMENT_SUBMISSION table is populated.

For example, I get this warning:
2010-07-05 18:21:07,203  WARN main
org.sakaiproject.util.conversion.SchemaConversionController -   --> Source
is null for id: 8467e62c-29ae-4248-8088-bf2ef8be4bc6 [39 of 100]

but there seems to be as assignment submission with that id (at least it is
buried in the XML blob):

mysql> select * from ASSIGNMENT_SUBMISSION where XML like
"%8467e62c-29ae-4248-8088-bf2ef8be4bc6%"\G
*************************** 1. row ***************************
SUBMISSION_ID: 8467e62c-29ae-4248-8088-bf2ef8be4bc6
      CONTEXT: 7da77f66-fe12-407e-0054-162f9557a862
          XML: <?xml version="1.0" encoding="UTF-8"?>
<submission assignment="7da77f66-fe12-407e-0054-162f9557a862"
context="53ca8b17-e16c-428c-00e0-50ea76df8b31"
datereturned="20071022001130729" datesubmitted="20070917215614236"
feedbackcomment="VGhpcyBpcyBhIGNv...VzLg=="
feedbackcomment-html="PHA+VGhp...jwvcD4="
feedbacktext="UmVsZ....jdHVyZS4="
feedbacktext-html="PHA+UmV....J1Y3R1cmUuPC9wPg=="
graded="true" gradereleased="true" id="8467e62c-29ae-4248-8088-bf2ef8be4bc6"
lastmod="20071022001130729"
numberoffeedbackattachments="0" numberofsubmittedattachments="0"
numberofsubmitters="1" pledgeflag="false"
returned="true" reviewReport="Error" reviewScore="-2" reviewStatus=""
scaled_grade="30" submitted="true"
submittedtext="UmVsZW...gc3RydWN0dXJlLg=="
submittedtext-html="PHA+...iBzdHJ1Y3R1cmUuPC9wPg=="
submitter0="a7a2f5b2-0bba-4053-8055-ad4ab34c134f">
<properties>
<property enc="BASE64" name="CHEF:creator"
value="YTdhMmY1YjItMGJiYS00MDUzLTgwNTUtYWQ0YWIzNGMxMzRm"/>
<property enc="BASE64" name="allow_resubmit_number" value="MA=="/>
<property enc="BASE64" name="CHEF:modifiedby" value="bmFzZWxsbWU="/>
<property enc="BASE64" name="DAV:getlastmodified"
value="MjAwNzEwMjIwMDExMzA3Mjk="/>
<property enc="BASE64" name="DAV:creationdate"
value="MjAwNzA5MTcyMTU2MTQxOTU="/>
</properties>
</submission>
 SUBMITTER_ID:
  SUBMIT_TIME: NULL
    SUBMITTED: NULL
       GRADED: NULL
1 row in set (2.18 sec)

Sean Keesler
130 Academy Street
Manlius, NY 13104
315-682-0830
sean.keesler at threecanoes.com

On Tue, Jul 6, 2010 at 11:01 AM, Maurer, Christopher Wayne <
chmaurer at iupui.edu> wrote:

> Sean,
> I think if the source is null, it means that there is nothing in the xml
> blob field, hopefully because it is already using the new binary_entity
> field.
>
> Chris
>
> On Jul 6, 2010, at 9:50 AM, Sean Keesler wrote:
>
> Looking for some help here.
>
> I've run the sql conversion scripts against a 2.4 database in order to
> upgrade to 2.6.2. My next step is to try running the runconversion.sh script
> to convert the XML assignment blobs to the new columns:
> ./runconversion.sh -j
> "/data/installs/sakai_2_6_2_soe/apache-tomcat/common/lib/mysql-connector-java-5.0.8-bin.jar"
> -p "/data/inst
> alls/sakai_2_6_2_soe/apache-tomcat/sakai/sakai.properties" -k "1.0.13" -s
> "2.6.2" -m "/home/smkeesle/.m2/repository/" upgradeschema_mysql.config
>
> but I end up with what I assume is a lot of problems:
>
> 2010-07-05 20:37:40,318  INFO main
> org.sakaiproject.util.conversion.SchemaConversionController - Migrating 100
> records of 20487
> 2010-07-05 20:37:40,353  WARN main
> org.sakaiproject.util.conversion.SchemaConversionController -   --> Source
> is null for id: 0000447c-d8f8-4ada-8070-55fea20f100f [1 of 100]
> 2010-07-05 20:37:40,354  WARN main
> org.sakaiproject.util.conversion.SchemaConversionController -   --> Source
> is null for id: 0002774a-4f25-43e4-003b-a441f0abc922 [2 of 100]
>
> ...pages and pages of "Source is null for id:
> xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx".
>
> What exactly is this script looking for? What is NULL?
>
>
> Sean Keesler
> 130 Academy Street
> Manlius, NY 13104
> 315-682-0830
> sean.keesler at threecanoes.com
>
>
>
>
>
> On Fri, Jul 2, 2010 at 3:28 PM, Zhen Qian <zqian at umich.edu> wrote:
>
>>
>> Sean:
>>
>> A db conversion is required for moving Assignment tool from 2.4 to later
>> versions. Here is the readme file for the conversion:
>>
>> https://source.sakaiproject.org/svn/assignment/trunk/runconversion_readme.txt
>>
>> The post 2.4 Assignment tool depend on new db columns for showing the
>> in/new column counts. Without conversion, all old assignments would have
>> 0/0 display, while newly created or graded assignments would have normal
>> behavior.
>>
>> Please let me know if you run into any problem with the conversion script.
>>
>> Thanks,
>>
>> - Zhen
>>
>> On Fri, 2 Jul 2010 15:11:48 -0400, Sean Keesler
>> <sean.keesler at threecanoes.com> wrote:
>> > I notice that if I grade an assignment and them re- "Release Grades"
>> > for an assignment, the In/New counts display as expected.
>> > I sure don't want to click that link for every assignment in Sakai
>> > though. Is there an easier way?
>> >
>> > Sean
>> >
>> >
>> >
>> >
>> >
>> > On Wed, Jun 30, 2010 at 8:34 PM, Sean Keesler
>> > <sean.keesler at threecanoes.com> wrote:
>> >> Forwarding from sakai-user...
>> >> Does anyone know how this issue is solved?
>> >>
>> >> After upgrading a 2.4 instance to 2.6.2 I noticed that all assignments
>> >> display that there are "0/0" in the "In/New" column.
>> >> If I investigate a little further I can see that the assignments and
>> >> all grades ARE there.
>> >>
>> >> New assignments that I create and students turn in appear to display
>> >> the expected behavior.
>> >>
>> >> I guess this isn't a big problem for courses that have ended already,
>> >> but it looks odd for clases still in progress.
>> >> Any ideas?
>> >>
>> >>
>> >> Sean Keesler
>> >> 130 Academy Street
>> >> Manlius, NY 13104
>> >> 315-682-0830
>> >> sean.keesler at threecanoes.com
>> >>
>> >>
>> >>
>> >> ---------- Forwarded message ----------
>> >> From: Jim Doherty <jim at learning4u.nl>
>> >> Date: Wed, Jun 30, 2010 at 9:27 AM
>> >> Subject: Re: [Using Sakai] Assignment "In/New" counts all read 0 after
>> >> upgrade
>> >> To: Sean Keesler <sean.keesler at threecanoes.com>
>> >>
>> >>
>> >> Hello Sean,
>> >> We had this same problem in Nov 08 when we upgraded.
>> >> Its a known problem.  I found a reference in our JIRA that we solved
>> >> this problem with the 'Assignments tool conversion and update
>> >> procedure'... Unfortunately I don't have the code or more information
>> >> available, but it should be available in the community.  Your problem
>> >> is not unique.
>> >> best regards,
>> >> Jim
>> >> --
>> >> Jim Doherty
>> >> Learning4u
>> >> w: www.learning4u.nl
>> >> t: 0207163981
>> >> m: 06 48754913
>> >>
>> >>
>> >>
>> >> On Wed, Jun 30, 2010 at 12:17 PM, Sean Keesler
>> >> <sean.keesler at threecanoes.com> wrote:
>> >>>
>> >>> After upgrading a 2.4 instance to 2.6.2 I noticed that all assignments
>> >>> display that there are "0/0" in the "In/New" column.
>> >>> If I investigate a little further I can see that the assignments and
>> >>> all grades ARE there.
>> >>>
>> >>> New assignments that I create and students turn in appear to display
>> >>> the expected behavior.
>> >>>
>> >>> I guess this isn't a big problem for courses that have ended already,
>> >>> but it looks odd for clases still in progress.
>> >>> Any ideas?
>> >>>
>> >>>
>> >>> Sean Keesler
>> >>> 130 Academy Street
>> >>> Manlius, NY 13104
>> >>> 315-682-0830
>> >>> sean.keesler at threecanoes.com
>> >>> _______________________________________________
>> >>> sakai-user mailing list
>> >>> 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 with a subject of
>> >>> "unsubscribe"
>> >>
>> > _______________________________________________
>> > 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"
>>
>
> _______________________________________________
> 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"
>
>
>
> _______________________________________________
> 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/20100706/4c2d11f3/attachment.html 