[Building Sakai] Night build "tests & Quizzes"
Neal Caidin
neal.caidin at apereo.org
Wed Feb 19 09:46:04 PST 2014
Is there a Jira associated with this revision?
I would like to ensure it gets into the Sakai 10 branch.
Thanks,
Neal
> Karen Tsao <mailto: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 <mailto: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 <mailto: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
> <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
> <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 <mailto: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
> <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 <mailto: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
> <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/92bdd46b/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/92bdd46b/attachment.jpg
More information about the sakai-dev
mailing list