[Building Sakai] Night build "tests & Quizzes"

[Stephen Marquard]

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


On Mon, Feb 17, 2014 at 10:08 AM, igor Novopashenny <Igor at escience.uni-bremen.de<mailto:Igor at escience.uni-bremen.de>> wrote:
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<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"

________________________________
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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140217/9c28f6c1/attachment.html