[Building Sakai] Portfolio Matrix Entries Don't Show

[Mark J. Norton]

The dump came from 2.8.0, which is why we built that environment rather 
than a more recent build.  There were one or two DB table 
inconsistencies which I resolved.  The only one I couldn't fix was:

WARN main 
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean 
- Unsuccessful schema statement: alter table osp_scaffolding add index FK651
35779C73F84BD (id), add constraint FK65135779C73F84BD foreign key (id) 
references osp_workflow_parent (id)
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Cannot add or update a child row: a foreign key constraint fails 
(`sau53`.<result 2 when explaining filename
  '#sql-6dc_1c3'>, CONSTRAINT `FK65135779C73F84BD` FOREIGN KEY (`id`) 
REFERENCES `osp_workflow_parent` (`id`))

This is troubling because the new constraint isn't satisfied by the 
existing data.  Normally such a constraint would be in place before data 
was added to osp_scaffolding.  Not much I can do about it now, though.  
I don't think this has much to do with a Matrix, though I could be wrong.

- Mark

On 9/3/2012 6:56 PM, Steve Swinsburg wrote:
> Hi Mark,
>
> Presumably, once the older db dump was restored back into a database, the relevant upgrade scripts were run to bring it up to 2.8.0?
>
> cheers,
> Steve
>
>
> On 04/09/2012, at 2:21 AM, Mark J. Norton <markjnorton at earthlink.net> wrote:
>
>> One of my clients has a data migration issue.  The older Sakai database
>> was saved out as a SQL dump.  A new instance of Sakai (2.8.0) was
>> created and the database initialized from the SQL dump. Content
>> resources were also migrated and configured in sakai.properties.
>>
>> Generally, things work just fine.  The old courses are there, rosters, etc.
>>
>> Many of these courses (this is a K12 school system) use the Portfolio
>> and Matrix tools.  When I click on the Matrix Tool for a course that
>> should contain entries, nothing appears.
>>
>> I had a look int the database.  I can an entry for a Matrix in the
>> osp_matrix table that is associated with a Scaffolding item in the
>> osp_scaffolding table with a worksiteid that corresponds to the course
>> in question.  In other words, it looks like the data is there, but not
>> being displayed by the Matrix tool.
>>
>> Any suggestions on why the Matrix entries are not showing up?
>>
>> - Mark Norton
>>
>> _______________________________________________
>> 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/20120903/bcf9cbdb/attachment.html