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

Tue Jul 6 08:01:42 PDT 2010

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"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100706/4d42969f/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2419 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100706/4d42969f/attachment.bin 