[Building Sakai] Night build "tests & Quizzes"

Wed Feb 19 11:09:39 PST 2014

Hi Neal,

This is the JIRA: https://jira.sakaiproject.org/browse/SAM-1943. I guess
the last two checkin need to be merged into 10 branch. I will do it.

Thanks,
Karen

On Wed, Feb 19, 2014 at 9:46 AM, Neal Caidin <neal.caidin at apereo.org> wrote:

> Is there a Jira associated with this revision?
>
> I would like to ensure it gets into the Sakai 10 branch.
>
> Thanks,
> Neal
>
>
>   Karen Tsao <ktsao at stanford.edu>
>  February 18, 2014 at 1:48 AM
> I have committed the fix. Please verify it once nightly is rebuilt.
>
> Thanks,
> Karen
>
>
>
>   Neal Caidin <neal.caidin at apereo.org>
>  February 17, 2014 at 2:21 PM
>  Thanks Stephen!
>
> I think we will be able to branch once trunk is compiling on nightly again
> (and depending upon availability of resources to do the branching, which
> looks promising for later today).
>
> Cheers,
> Neal
>
>
>   Stephen Marquard <stephen.marquard at uct.ac.za>
>  February 17, 2014 at 2:14 PM
>  The T&Q Oracle failure is caused by an inadvertent reversal of this
> change:
>
>  http://source.sakaiproject.org/viewsvn?view=revision&revision=85662
>
>  in the EMI merge. I've sent a patch to Karen to commit so it should run
> correctly again on nightly2 trunk soon.
>
>  Cheers
> Stephen
>
>  ------------------------------
> *From:* sakai-dev-bounces at collab.sakaiproject.org [
> sakai-dev-bounces at collab.sakaiproject.org] on behalf of Stephen Marquard [
> stephen.marquard at uct.ac.za]
> *Sent:* 17 February 2014 05:38 PM
> *To:* Matthew Jones; igor Novopashenny
> *Cc:* dev sakai
> *Subject:* Re: [Building Sakai] Night build "tests & Quizzes"
>
>  It could be some sort of Oracle vs mysql difference in schemas or
> hibernate mappings or query syntax.
>
>  We are taking a look at the trunk build on mysql and if that works fine
> will investigate the Oracle-specific issues further.
>
>  Regards
> Stephen
>
>  ------------------------------
> *From:* sakai-dev-bounces at collab.sakaiproject.org [
> sakai-dev-bounces at collab.sakaiproject.org] on behalf of Matthew Jones [
> matthew at longsight.com]
> *Sent:* 17 February 2014 05:27 PM
> *To:* igor Novopashenny
> *Cc:* dev sakai
> *Subject:* Re: [Building Sakai] Night build "tests & Quizzes"
>
>  Yeah, it looks like some recent change to Samigo (SAM-1943) removed a
> "groupby" and is not working under Oracle now (
> https://source.sakaiproject.org/viewsvn/sam/trunk/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentFacadeQueries.java?r1=121508&r2=305964)
>
> Stacktrace:
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
> caused by:
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; SQL [select assessment2_.ID as col_0_0_, count(*) as
> col_1_0_ from SAM_ITEM_T itemdata0_, SAM_SECTION_T sectiondat1_,
> SAM_ASSESSMENTBASE_T assessment2_, SAM_AUTHZDATA_T authorizat3_ where
> assessment2_.isTemplate='0' and assessment2_.ID=sectiondat1_.ASSESSMENTID
> and sectiondat1_.SECTIONID=itemdata0_.SECTIONID and
> assessment2_.ID=authorizat3_.QUALIFIERID and authorizat3_.FUNCTIONID=? and
> authorizat3_.AGENTID=?]; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
> at
> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
> caused by: org.hibernate.exception.SQLGrammarException: could not execute
> query
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> caused by: java.sql.SQLException: ORA-00937: not a single-group group
> function
>
>
>
>    ------------------------------
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27
> 21 650 9111. This e-mail is intended only for the person(s) to whom it is
> addressed. If the e-mail has reached you in error, please notify the
> author. If you are not the intended recipient of the e-mail you may not
> use, disclose, copy, redirect or print the content. If this e-mail is not
> related to the business of UCT it is sent by the sender in the sender's
> individual capacity.
>   _______________________________________________
> 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"
>   Stephen Marquard <stephen.marquard at uct.ac.za>
>  February 17, 2014 at 10:38 AM
>  It could be some sort of Oracle vs mysql difference in schemas or
> hibernate mappings or query syntax.
>
>  We are taking a look at the trunk build on mysql and if that works fine
> will investigate the Oracle-specific issues further.
>
>  Regards
> Stephen
>
>  ------------------------------
> *From:* sakai-dev-bounces at collab.sakaiproject.org [
> sakai-dev-bounces at collab.sakaiproject.org] on behalf of Matthew Jones [
> matthew at longsight.com]
> *Sent:* 17 February 2014 05:27 PM
> *To:* igor Novopashenny
> *Cc:* dev sakai
> *Subject:* Re: [Building Sakai] Night build "tests & Quizzes"
>
>  Yeah, it looks like some recent change to Samigo (SAM-1943) removed a
> "groupby" and is not working under Oracle now (
> https://source.sakaiproject.org/viewsvn/sam/trunk/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentFacadeQueries.java?r1=121508&r2=305964)
>
> Stacktrace:
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
> caused by:
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; SQL [select assessment2_.ID as col_0_0_, count(*) as
> col_1_0_ from SAM_ITEM_T itemdata0_, SAM_SECTION_T sectiondat1_,
> SAM_ASSESSMENTBASE_T assessment2_, SAM_AUTHZDATA_T authorizat3_ where
> assessment2_.isTemplate='0' and assessment2_.ID=sectiondat1_.ASSESSMENTID
> and sectiondat1_.SECTIONID=itemdata0_.SECTIONID and
> assessment2_.ID=authorizat3_.QUALIFIERID and authorizat3_.FUNCTIONID=? and
> authorizat3_.AGENTID=?]; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
> at
> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
> caused by: org.hibernate.exception.SQLGrammarException: could not execute
> query
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> caused by: java.sql.SQLException: ORA-00937: not a single-group group
> function
>
>
>
>    ------------------------------
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27
> 21 650 9111. This e-mail is intended only for the person(s) to whom it is
> addressed. If the e-mail has reached you in error, please notify the
> author. If you are not the intended recipient of the e-mail you may not
> use, disclose, copy, redirect or print the content. If this e-mail is not
> related to the business of UCT it is sent by the sender in the sender's
> individual capacity.
> _______________________________________________
> 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"
>   Matthew Jones <matthew at longsight.com>
>  February 17, 2014 at 10:27 AM
> Yeah, it looks like some recent change to Samigo (SAM-1943) removed a
> "groupby" and is not working under Oracle now (
> https://source.sakaiproject.org/viewsvn/sam/trunk/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentFacadeQueries.java?r1=121508&r2=305964
> )
> Stacktrace:
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
> caused by:
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; SQL [select assessment2_.ID as col_0_0_, count(*) as
> col_1_0_ from SAM_ITEM_T itemdata0_, SAM_SECTION_T sectiondat1_,
> SAM_ASSESSMENTBASE_T assessment2_, SAM_AUTHZDATA_T authorizat3_ where
> assessment2_.isTemplate='0' and assessment2_.ID=sectiondat1_.ASSESSMENTID
> and sectiondat1_.SECTIONID=itemdata0_.SECTIONID and
> assessment2_.ID=authorizat3_.QUALIFIERID and authorizat3_.FUNCTIONID=? and
> authorizat3_.AGENTID=?]; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
> at
> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
> caused by: org.hibernate.exception.SQLGrammarException: could not execute
> query
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> caused by: java.sql.SQLException: ORA-00937: not a single-group group
> function
>
>
>
> _______________________________________________
> 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"
>
>
> --
> Neal Caidin
> Sakai Community Coordinator
> Apereo Foundation
> neal.caidin at apereo.org
> Skype me! (but let me know in advance for the first interaction) - nealkdin
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140219/f6a3b9c6/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: compose-unknown-contact.jpg
Type: image/jpeg
Size: 770 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140219/f6a3b9c6/attachment.jpg 