[Building Sakai] SITEASSOC_CONTEXT_ASSOCIATION and TAGGABLE_LINK

Tue Jul 12 13:27:43 PDT 2011

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"
>> 
>> 
>> 
> 
> 
> 

-------------- 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/a895d642/attachment.bin 