[Building Sakai] Night build "tests & Quizzes"

[Matthew Jones]

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> 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
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140217/908d63d7/attachment.html