[Building Sakai] Gradebook2 and Sakai 2.6.x

[John Bush]

If I recall correctly, I mostly just followed the instructions.  When  
I originally did it, there wasn't a gradebook2 2.6.x patch available,  
I moved it forward myself as well as the pom changes.  Since then I've  
had to manually adjust things a little because I've been taking new  
drops that have impacted things in gradebook2 at least once.  For what  
its worth, you could download our source, if that helps, http://www.rsmart.com/assets/rSmart-CLE-2.6.2-source.tar.bz2

John Bush
Development Manager
rSmart




On Nov 19, 2009, at 5:24 PM, Kevin Chan 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"
>>
> _______________________________________________
> 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"