[Building Sakai] Night build "tests & Quizzes"
Jaques Smith
jaques at opencollab.co.za
Fri Feb 21 00:37:52 PST 2014
Hi Guys,
I'm a little behind on my mails and only saw this now, I also added a patch
to https://jira.sakaiproject.org/browse/SAM-1943 for the conversion scripts
from 2.9 to 10 (attached here). There was some Oracle stuff missing and the
scripts was still incorrectly in the 2.8 to 2.9 conversion scripts.
Thanks for all the merging.
Cheers,
Jaques
On 19 February 2014 21:15, Neal Caidin <neal.caidin at apereo.org> wrote:
> Thanks Karen, that would be a huge help.
>
> -- Neal
>
>
> Karen Tsao <ktsao at stanford.edu>
> February 19, 2014 at 2:09 PM
> 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
>
>
>
> Neal Caidin <neal.caidin at apereo.org>
> February 19, 2014 at 12:46 PM
> 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"
>
>
> --
> 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
>
>
> _______________________________________________
> 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"
>
--
------------------------------
See OpenCollab email disclaimer at
http://www.opencollab.co.za/email-disclaimer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140221/e05e6b17/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/20140221/e05e6b17/attachment.jpg
-------------- next part --------------
Index: docs/conversion/samigo_2_8_x-2_9_0_mysql_conversion.sql
===================================================================
--- docs/conversion/samigo_2_8_x-2_9_0_mysql_conversion.sql (revision 306169)
+++ docs/conversion/samigo_2_8_x-2_9_0_mysql_conversion.sql (working copy)
@@ -29,25 +29,3 @@
AND TYPEID='142' AND ISTEMPLATE=1),
'lockedBrowser_isInstructorEditable', 'true')
;
-
--- SAK-17243
-alter table SAM_ATTACHMENT_T add ITEMTEXTID bigint(20) DEFAULT NULL;
-alter table SAM_ITEMTEXT_T add REQUIRED_OPTIONS_COUNT int(11) DEFAULT NULL;
-alter table SAM_ITEM_T add ANSWER_OPTIONS_RICH_COUNT int(11) DEFAULT NULL;
-alter table SAM_ITEM_T add ANSWER_OPTIONS_SIMPLE_OR_RICH int(11) DEFAULT NULL;
-
-create index SAM_ATTACH_ITEMTEXTID_I ON SAM_ATTACHMENT_T (ITEMTEXTID);
-alter table SAM_ATTACHMENT_T add CONSTRAINT FOREIGN KEY (ITEMTEXTID) REFERENCES SAM_ITEMTEXT_T (ITEMTEXTID);
-
-alter table SAM_PUBLISHEDATTACHMENT_T add ITEMTEXTID bigint(20) DEFAULT NULL;
-alter table SAM_PUBLISHEDITEMTEXT_T add REQUIRED_OPTIONS_COUNT int(11) DEFAULT NULL;
-alter table SAM_PUBLISHEDITEM_T add ANSWER_OPTIONS_RICH_COUNT int(11) DEFAULT NULL;
-alter table SAM_PUBLISHEDITEM_T add ANSWER_OPTIONS_SIMPLE_OR_RICH int(11) DEFAULT NULL;
-
-create index SAM_PUBATTACH_ITEMTEXTID_I ON SAM_PUBLISHEDATTACHMENT_T (ITEMTEXTID);
-alter table SAM_PUBLISHEDATTACHMENT_T add CONSTRAINT FOREIGN KEY (ITEMTEXTID) REFERENCES SAM_PUBLISHEDITEMTEXT_T (ITEMTEXTID);
-
-INSERT INTO SAM_TYPE_T (TYPEID ,AUTHORITY ,DOMAIN, KEYWORD, DESCRIPTION,
- STATUS, CREATEDBY, CREATEDDATE, LASTMODIFIEDBY, LASTMODIFIEDDATE )
- VALUES (14 , 'stanford.edu' ,'assessment.item' ,'Extended Matching Items' ,NULL ,1 ,1 ,
- '2009-11-23 12:00:00',1 ,'2009-11-23 12:00:00');
\ No newline at end of file
Index: docs/conversion/samigo_2_8_x-2_9_0_oracle_conversion.sql
===================================================================
--- docs/conversion/samigo_2_8_x-2_9_0_oracle_conversion.sql (revision 306169)
+++ docs/conversion/samigo_2_8_x-2_9_0_oracle_conversion.sql (working copy)
@@ -26,13 +26,6 @@
"LASTMODIFIEDDATE" )
VALUES (13 , 'stanford.edu' ,'assessment.item' ,'Matrix Choices Survey' ,NULL ,1 ,1 ,
SYSDATE ,1 ,SYSDATE);
-
-INSERT INTO SAM_TYPE_T ("TYPEID" ,"AUTHORITY" ,"DOMAIN" ,"KEYWORD",
- "DESCRIPTION" ,
- "STATUS" ,"CREATEDBY" ,"CREATEDDATE" ,"LASTMODIFIEDBY" ,
- "LASTMODIFIEDDATE" )
- VALUES (14 , 'stanford.edu' ,'assessment.item' ,'Extended Matching_Items' ,NULL ,1 ,1 ,
- SYSDATE ,1 ,SYSDATE);
-- SAM-1255
Update SAM_ASSESSEVALUATION_T
Index: docs/conversion/samigo_2_9_x-10_0_mysql_conversion.sql
===================================================================
--- docs/conversion/samigo_2_9_x-10_0_mysql_conversion.sql (revision 0)
+++ docs/conversion/samigo_2_9_x-10_0_mysql_conversion.sql (working copy)
@@ -0,0 +1,21 @@
+-- SAK-17243
+alter table SAM_ATTACHMENT_T add ITEMTEXTID bigint(20) DEFAULT NULL;
+alter table SAM_ITEMTEXT_T add REQUIRED_OPTIONS_COUNT int(11) DEFAULT NULL;
+alter table SAM_ITEM_T add ANSWER_OPTIONS_RICH_COUNT int(11) DEFAULT NULL;
+alter table SAM_ITEM_T add ANSWER_OPTIONS_SIMPLE_OR_RICH int(11) DEFAULT NULL;
+
+create index SAM_ATTACH_ITEMTEXTID_I ON SAM_ATTACHMENT_T (ITEMTEXTID);
+alter table SAM_ATTACHMENT_T add CONSTRAINT FOREIGN KEY (ITEMTEXTID) REFERENCES SAM_ITEMTEXT_T (ITEMTEXTID);
+
+alter table SAM_PUBLISHEDATTACHMENT_T add ITEMTEXTID bigint(20) DEFAULT NULL;
+alter table SAM_PUBLISHEDITEMTEXT_T add REQUIRED_OPTIONS_COUNT int(11) DEFAULT NULL;
+alter table SAM_PUBLISHEDITEM_T add ANSWER_OPTIONS_RICH_COUNT int(11) DEFAULT NULL;
+alter table SAM_PUBLISHEDITEM_T add ANSWER_OPTIONS_SIMPLE_OR_RICH int(11) DEFAULT NULL;
+
+create index SAM_PUBATTACH_ITEMTEXTID_I ON SAM_PUBLISHEDATTACHMENT_T (ITEMTEXTID);
+alter table SAM_PUBLISHEDATTACHMENT_T add CONSTRAINT FOREIGN KEY (ITEMTEXTID) REFERENCES SAM_PUBLISHEDITEMTEXT_T (ITEMTEXTID);
+
+INSERT INTO SAM_TYPE_T (TYPEID ,AUTHORITY ,DOMAIN, KEYWORD, DESCRIPTION,
+ STATUS, CREATEDBY, CREATEDDATE, LASTMODIFIEDBY, LASTMODIFIEDDATE )
+ VALUES (14 , 'stanford.edu' ,'assessment.item' ,'Extended Matching Items' ,NULL ,1 ,1 ,
+ '2009-11-23 12:00:00',1 ,'2009-11-23 12:00:00');
\ No newline at end of file
Index: docs/conversion/samigo_2_9_x-10_0_oracle_conversion.sql
===================================================================
--- docs/conversion/samigo_2_9_x-10_0_oracle_conversion.sql (revision 0)
+++ docs/conversion/samigo_2_9_x-10_0_oracle_conversion.sql (working copy)
@@ -0,0 +1,23 @@
+-- SAK-17243
+alter table SAM_ATTACHMENT_T add ITEMTEXTID number(20,0) DEFAULT NULL;
+alter table SAM_ITEMTEXT_T add REQUIRED_OPTIONS_COUNT number(11,0) DEFAULT NULL;
+alter table SAM_ITEM_T add ANSWER_OPTIONS_RICH_COUNT number(11,0) DEFAULT NULL;
+alter table SAM_ITEM_T add ANSWER_OPTIONS_SIMPLE_OR_RICH number(11,0) DEFAULT NULL;
+
+create index SAM_ATTACH_ITEMTEXTID_I ON SAM_ATTACHMENT_T (ITEMTEXTID);
+alter table SAM_ATTACHMENT_T add CONSTRAINT FK_SAM_ATTACH_ITEMTEXT FOREIGN KEY (ITEMTEXTID) REFERENCES SAM_ITEMTEXT_T (ITEMTEXTID);
+
+alter table SAM_PUBLISHEDATTACHMENT_T add ITEMTEXTID number(20,0) DEFAULT NULL;
+alter table SAM_PUBLISHEDITEMTEXT_T add REQUIRED_OPTIONS_COUNT number(11,0) DEFAULT NULL;
+alter table SAM_PUBLISHEDITEM_T add ANSWER_OPTIONS_RICH_COUNT number(11,0) DEFAULT NULL;
+alter table SAM_PUBLISHEDITEM_T add ANSWER_OPTIONS_SIMPLE_OR_RICH number(11,0) DEFAULT NULL;
+
+create index SAM_PUBATTACH_ITEMTEXTID_I ON SAM_PUBLISHEDATTACHMENT_T (ITEMTEXTID);
+alter table SAM_PUBLISHEDATTACHMENT_T add CONSTRAINT FK_SAM_PATTACH_PITEMTEXT FOREIGN KEY (ITEMTEXTID) REFERENCES SAM_PUBLISHEDITEMTEXT_T (ITEMTEXTID);
+
+INSERT INTO SAM_TYPE_T ("TYPEID" ,"AUTHORITY" ,"DOMAIN" ,"KEYWORD",
+ "DESCRIPTION" ,
+ "STATUS" ,"CREATEDBY" ,"CREATEDDATE" ,"LASTMODIFIEDBY" ,
+ "LASTMODIFIEDDATE" )
+ VALUES (14 , 'stanford.edu' ,'assessment.item' ,'Extended Matching_Items' ,NULL ,1 ,1 ,
+ SYSDATE ,1 ,SYSDATE);
More information about the sakai-dev
mailing list