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

[Sean Keesler]

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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100706/a381e4d4/attachment.html