[Building Sakai] Strange behaviour in OSP after DB migration

[Maurer, Christopher Wayne]

We had the same thing happen at IU about a year ago (though not as a result of a db migration, we just noticed "wrong" content).
I'm not sure if we ever came to a decision about how it happened, we just worked through figuring out how to get the correct content, deleted the dups and added a constraint on the table to prevent it from happening again.
Damian or Lynn might be able to give some more details about the resolution.

Chris

From: Mark Breuker <mbreuker at loi.nl<mailto:mbreuker at loi.nl>>
Date: Thursday, November 7, 2013 10:42 AM
To: "sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>" <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Subject: Re: [Building Sakai] Strange behaviour in OSP after DB migration

Hi again,

We have found the cause for this issue. Somehow there are multiple versions (records) of the matrix for some students in the DB where the code only expects one record. Migrating the database caused the order of the result set to be different and thus different matrices being shown.

We don't know yet why these duplicate records where created but when we find out we will file a JIRA.

Cheers,

Mark
________________________________
Van: Mark Breuker
Verzonden: donderdag 7 november 2013 13:35
Aan: sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Onderwerp: Strange behaviour in OSP after DB migration

Hi all,

We have migrated our Oracle DB to a new server last night and are seeing some strange behavior in OSP. In the old database we see a student's matrix with cells that are completed (see attached screenshots). In the new database these cells are still open and some evidence is missing. It seems as if we are looking at an older version of the data. We checked the DB records and it seems as if all the records are identical in both databases.

Has anyone seen this before or maybe a clue about what might be happening here?

Thanks,

Mark

Mark Breuker
Product Owner
Tel.: +31 71 5451 203

Leidse Onderwijsinstellingen bv
Leidsedreef 2
2352 BA Leiderdorp
www.loi.nl

________________________________

[Nederland wordt steeds slimmer. Leidse Onderwijsinstellingen]

De informatie verzonden met dit e-mailbericht (en bijlagen) is uitsluitend bestemd voor de geadresseerde(n) en zij die van de geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik door anderen dan geadresseerde(n) is verboden. De informatie in dit e-mailbericht (en de bijlagen) kan vertrouwelijk van aard zijn en kan binnen het bereik vallen van een wettelijke geheimhoudingsplicht. Indien u deze e-mail ten onrechte ontvangen hebt, wordt u verzocht ons daarvan zo spoedig mogelijk per e-mail of telefonisch op de hoogte te stellen, en het ontvangen bericht (en de bijlagen) te wissen zonder deze te lezen, te kopiëren of aan derden bekend te stellen.

P  Denk aan het milieu voordat u dit bericht print

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131108/50c26b38/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nwss_loi99bdcb
Type: image/gif
Size: 4378 bytes
Desc: nwss_loi99bdcb
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131108/50c26b38/attachment.gif