[Building Sakai] Gradebook2 and Sakai 2.6.x

[James Renfro]

Apologies, it looks like I managed to check in a slightly newer patch under
the 1.1.x branches, so the gradebook module's data model objects are now
up-to-date with trunk, rather than the 1.1.x sql scripts.

This is not an issue at all, since those fields will just be left null, but
you'll need to apply the following in your db:

https://source.sakaiproject.org/contrib/gradebook2/trunk/sakai/2-6-x/sql/oracle/GRBK-367.sql

and possibly also

https://source.sakaiproject.org/contrib/gradebook2/trunk/sakai/2-6-x/sql/oracle/GRBK-234.sql

I'll update the 1.1.x-dev and 1.1.x-test branches to fix this, and I'm
planning to bring gradebook2.sql up-to-date so that's the only script new
installers need to run.



On Thu, Nov 19, 2009 at 4:24 PM, Kevin Chan <kevin at media.berkeley.edu>wrote:

>  Hi James,
>
> Thanks for the notes. With the exception of using the 1.1.x-dev branch
> instead of 1.1.x-test, I had followed the instructions very closely (there
> was a part of a patch to Assignments.java that failed (easily merged) and
> some "alter table" SQL that were unnecessary as the added columns are
> already in our 2.6.x DB) and had gotten errors as I described previously.
>
> I rebuilt GB2 today with a clean copy of data from our production DB and
> got the same results.
>
> If I try to view GB2, I get:
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: Request processing failed; nested
> exception is
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:769)
> ...
> caused by: java.sql.SQLException: ORA-00904:
> "GRADEBOOK0_"."DO_SHOW_ITEM_STATS": invalid identifier
> --end of snippet
>
> I am not familiar with any table called "GRADEBOOK0", all Gradebook tables
> begin with "GB_".
>
> If I try to view Gradebook, I get:
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: Cannot get value for expression
> '#{bean.pageName ne 'gradebookSetup' && bean.userAbleToEditAssessments}'
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:769)
>
> caused by: org.sakaiproject.tool.api.ToolException: Cannot get value for
> expression '#{bean.pageName ne 'gradebookSetup' &&
> bean.userAbleToEditAssessments}'
> --end of snippet
>
> Let me know if I should open a Jira ticket or if it is something that I
> overlooked. Also, do you know if rSmart built GB2/2.6.x with the default
> Sakai modules (like portal, we have a slightly customized version of portal
> so maybe that is the problem) or if there were heavy changes/other modules
> needed to make it work?
>
>
> Thanks,
>
>   Kevin Chan
>
>   Operations Team
>   Educational Technology Services
>   University of California, Berkeley
>
>
> On 11/18/09 7:58 PM, James Renfro wrote:
>
> Hi Kevin,
> It is definitely possible to get Gradebook2 working with a Sakai 2.6.x
> deployment. RSmart has it running, and I'm working with it locally on my
> desktop. Most of the other institutions that are using Gradebook2 are
> running 2.5.x afaik.
>
> Not sure which tag you're installing. We're currently running 1.1.3 in
> production at UCDavis, and this is our current "recommended" build for all
> institutions, but ootb that tag is organized to build against 2.5.x right
> now.
>
> Versions 1.1.3, 1.1.4, and 1.1.5 are all the same as far as actual code,
> and represent incremental improvements to the build process.
>
> For 2.6.x compatibility I would recommend 1.1.5, which has not yet been
> cut, but which will soon be our latest fully QA'd version that has been put
> together explicitly to build against 2.6.x -- it will still require patches
> to be applied to both the original gradebook module and sam module, which is
> unfortunately going to be the case for gb2 in general at least until 2.7.x,
> but it should no longer require any patching to the gradebook2 code itself
> to run against 2.6.x -- you can run this code currently from our test
> branch.
>
> https://source.sakaiproject.org/contrib/gradebook2/branches/1.1.x-test
>
> We should be cutting 1.1.5 itself in the next week, depending how long the
> QA process takes, at which point the code will be at:
>
> https://source.sakaiproject.org/contrib/gradebook2/tags/1.1.5
>
>
> If you're running with auto.ddl off, you will also need to run one or more
> of the scripts included in:
>
>
> https://source.sakaiproject.org/contrib/gradebook2/branches/1.1.x-test/client/src/sql/oracle/
>
> For other instructions you may want to consult the 2.6.x install
> directions, if you haven't dug them out already (they have been updated in
> the last few days to match the current code).
>
>
> https://source.sakaiproject.org/contrib/gradebook2/branches/1.1.x-test/sakai/2-6-x/INSTALL.txt
>
> Finally, you may want to tweak the version of 2.6.x for the build... you
> can do this by running this script:
>
>
> https://source.sakaiproject.org/contrib/gradebook2/branches/1.1.x-test/setSakaiVersion.sh
>
>
> Please let me know if you run into any problems,
> James
>
>
>
> On Wed, Nov 18, 2009 at 5:06 PM, Kevin Chan <kevin at media.berkeley.edu>wrote:
>
>> Hi,
>>
>> I am looking to do a test build of Gradebook2 as a part of UC Berkeley's
>> Sakai 2.6.x deployment. It looks like rSmart has already completed this
>> implementation and the effort to document/implement this is happening in:
>>
>> http://jira.sakaiproject.org/browse/GRBK-330
>> http://jira.sakaiproject.org/browse/GRBK-422
>>
>> Although I managed to compile GB2 with our code, there were some DB
>> errors when I attempted to view both GB2 and the 2.6.x gradebook. This
>> issue may very well be self generated (I am not working with a clean
>> DB), but I just wanted to see if anyone can confirm that this is
>> possible and any instruction (perhaps something not currently in any
>> INSTALL.txt files) would be great.
>>
>> I am working with the GB2 1.1.x-dev branch as that appears to be the one
>> that is being used for 2.6.x integration.
>>
>> Thanks,
>>
>> --
>>   Kevin Chan
>>
>>   Operations Team
>>   Educational Technology Services
>>   University of California, Berkeley
>>
>> _______________________________________________
>> 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/20091120/06d7a494/attachment.html