[Building Sakai] Night build "tests & Quizzes"

[Neal Caidin]

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"
> igor Novopashenny <mailto:Igor at escience.uni-bremen.de>
> February 17, 2014 at 10:08 AM
>
> Hi!
>
> I see that the Tests & Quizzes doesn’t work at nightly build
>
> http://nightly2.sakaiproject.org:8085/portal/site/720d480b-4c16-4f86-9c84-6c8624a5036c/page/2feac4d9-3183-4d71-9853-59e397f1568a
>
> *Error*
>
> An unexpected error has occurred.
>
> *Send a bug report*
>
> To send a bug report, describe what you were doing when the problem 
> occurred, in the space below, and press the submit button.
>
> Regards Igor
>
> _______________________________________________
> 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/20140217/62757ad0/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/20140217/62757ad0/attachment.jpg