[Building Sakai] Fwd: SITEASSOC_CONTEXT_ASSOCIATION and TAGGABLE_LINK

Anthony Whyte arwhyte at umich.edu
Tue Jul 12 13:42:30 PDT 2011 

23 Jul 2009 is the release date for sakai-2.6.0.

Anth

Begin forwarded message:

> From: Anthony Whyte <arwhyte at umich.edu>
> Date: July 12, 2011 4:27:43 PM EDT
> To: Martinez David <darolmar at upvnet.upv.es>
> Cc: Developers Sakai-Dev <sakai-dev at collab.sakaiproject.org>
> Subject: Re: [Building Sakai] SITEASSOC_CONTEXT_ASSOCIATION and TAGGABLE_LINK
> 
> Right.  I was providing a ticket number and a date (19 March 2008, to be a little more exact) in order to assist your research as you work through UPV's own upgrade history.
> 
> 19 March 2008.  Taggable moved out of assignments, trunk r42490-94.  See r42494 for the commit that made taggable a dependency of assignment.
> 
> 23 Jul 2008. 2.6.0 released
> 
> 
> Cheers,
> 
> Anth
> 
> 
> On Jul 12, 2011, at 4:05 PM, Maurer, Christopher Wayne wrote:
> 
>> It is linked with legacy assignments.  Anthony was perhaps speaking a
>> little more historically when he said taggable was removed from
>> assignments.  The code used to live in the assignments module but it was
>> pulled out into its own module.
>> 
>> Chris
>> 
>> On 7/12/11 3:57 PM, "DAVID ROLDAN MARTINEZ" <darolmar at upvnet.upv.es> wrote:
>> 
>>> Hmmm....Then I don't understand what can be happening...
>>> 
>>> If TAGGLABLE_LINK is not linked with legacy assignments, why our
>>> installation is trying to access that table?
>>> 
>>> Any idea?
>>> 
>>> Thanks a lot!!
>>> David
>>> ________________________________________
>>> De: Anthony Whyte [arwhyte at umich.edu]
>>> Enviado el: martes, 12 de julio de 2011 17:09
>>> Para: DAVID ROLDAN MARTINEZ
>>> CC: Developers Sakai-Dev; Maurer Christopher
>>> Asunto: Re: [Building Sakai] SITEASSOC_CONTEXT_ASSOCIATION and
>>> TAGGABLE_LINK
>>> 
>>> There is a hibernate mapping for TAGGABLE_LINK in the taggable project.
>>> It along with the rest of the taggable stuff was removed from assignments
>>> back in March 2008 (fix version Sakai 2.6.0) according to
>>> https://jira.sakaiproject.org/browse/SAK-13237.
>>> 
>>> /taggable/trunk/taggable-hbm/hbm/src/java/org/sakaiproject/taggable/impl/L
>>> inkImpl.hbm.xml
>>> 
>>> The only explicit reference to TAGGABLE_LINK in a *.sql conversion script
>>> involves a test script for assignment2.  See
>>> assignment2/selenium-test/sakaitrunk-db.sql.
>>> 
>>> Cheers,
>>> 
>>> Anthony
>>> 
>>> --
>>> -- Table structure for table `TAGGABLE_LINK`
>>> --
>>> 
>>> DROP TABLE IF EXISTS `TAGGABLE_LINK`;
>>> /*!40101 SET @saved_cs_client     = @@character_set_client */;
>>> /*!40101 SET character_set_client = utf8 */;
>>> CREATE TABLE `TAGGABLE_LINK` (
>>> `LINK_ID` varchar(36) NOT NULL,
>>> `VERSION` int(11) NOT NULL,
>>> `ACTIVITY_REF` varchar(255) NOT NULL,
>>> `TAG_CRITERIA_REF` varchar(255) NOT NULL,
>>> `RUBRIC` text,
>>> `RATIONALE` text,
>>> `EXPORT_STRING` int(11) NOT NULL,
>>> `VISIBLE` bit(1) NOT NULL,
>>> `LOCKED` bit(1) NOT NULL,
>>> PRIMARY KEY (`LINK_ID`)
>>> ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
>>> /*!40101 SET character_set_client = @saved_cs_client */;
>>> 
>>> --
>>> -- Dumping data for table `TAGGABLE_LINK`
>>> --
>>> 
>>> LOCK TABLES `TAGGABLE_LINK` WRITE;
>>> /*!40000 ALTER TABLE `TAGGABLE_LINK` DISABLE KEYS */;
>>> /*!40000 ALTER TABLE `TAGGABLE_LINK` ENABLE KEYS */;
>>> UNLOCK TABLES;
>>> 
>>> 
>>> 
>>> 
>>> On Jul 12, 2011, at 10:40 AM, Maurer, Christopher Wayne wrote:
>>> 
>>> David,
>>> I remember a bunch of strange issues with some past conversion scripts as
>>> well.  I forget what the final outcome was, as stuff went in and out of
>>> the conversion scripts based on various errors from folks running the
>>> conversion.  But those tables are related to OSP Matrix/Assignments (1 and
>>> 2) integration.
>>> 
>>> Rows are created in the SITEASSOC_CONTEXT_ASSOCIATION table when you
>>> associate sites (currently done through a link in the Matrix tool).
>>> (as as aside, we will eventually investigate the duplication of
>>> functionality of this with the site linking that came in 2.7)
>>> 
>>> To get records in TAGGABLE_LINK, you'd have to first make the above
>>> mentioned site association, then, you can link an assignment to a matrix
>>> cell (provided that you have created an assignment and a matrix!).
>>> 
>>> Chris
>>> 
>>> On 7/12/11 10:12 AM, "DAVID ROLDAN MARTINEZ"
>>> <darolmar at upvnet.upv.es<mailto:darolmar at upvnet.upv.es>>
>>> wrote:
>>> 
>>> 
>>>           Hi,
>>> 
>>> Short description: Does anybody know what these tables are used for?
>>> 
>>> Detailed description:
>>> 
>>> We are on the process of migration from 2.6 to 2.8 and I've found two
>>> strange issues:
>>> * SITEASSOC_CONTEXT_ASSOCIATION is created at
>>> sakai_2_7_0_oracle_conversion.sql. I can create the table but it's empty.
>>> I've tried creating new objects (Assignments and Announcements) but it
>>> seems no to do nothing (no row is inserted in this table), though
>>> enabling hibernate.show_sql I've seen that Sakai tries to SELECT rows
>>> each that display assignment list. Does anybody know the aim of this
>>> table? where rows should be inserted?
>>> 
>>> * TAGGLABLE_LINK. I haven't found this table at any of the migration
>>> scripts. However, when deleting as assignment tries to delete rows from
>>> it and, as it not exists, Oracle lauches an exception and the assignment
>>> can not be deleted. To top it off, Sakai locks the assignment and nobody
>>> can do anything with it. Searching in the code, I've found that is
>>> referenced in taggable module but, unfortunately, I don't know what's the
>>> intent of this module. To try to figure out when this table is created, I
>>> was thinking about to run migration scripts 2.6 -> 2.7 -> 2.8 and then
>>> set auto.ddl before to start Tomcat but I'm not sure if this will help.
>>> Any idea?
>>> 
>>> I absolutely appreciate any suggestion, idea, etc. I'm really stuck with
>>> this. :(
>>> 
>>> Thank you very much in advance.
>>> 
>>> Cheers,
>>> David
>>> _______________________________________________
>>> 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
>>> @collab.sakaiproject.org> with a subject of
>>> "unsubscribe"
>>> 
>>> _______________________________________________
>>> 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 with a subject of
>>> "unsubscribe"
>>> 
>>> 
>>> 
>> 
>> 
>> 
> 
> _______________________________________________
> 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/20110712/0e3690f6/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3829 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110712/0e3690f6/attachment.bin

More information about the sakai-dev mailing list