Wednesday, November 27, 2013

Mating Records in Mosaic Vivarium

A mating record in Mosaic Vivarium represents a list of possible parents for a set of litters.  When you put animals together, Vivarium will inspect the list of existing mating records for the same set of parents – if the exact same set of parents exists for a mating record, Vivarium will re-use that mating record for the new mating cage.  That means new litters seen in the cage will be added to the existing mating record.

If the set of possible parents in a cage has not been seen together before, a new mating record is created.  New litters seen in the cage will be added to the new mating record.

The mating record serves at the basis of your pedigree.  To find all ancestors of an animal, Vivarium inspects the parents associated with the mating ID from which the animal came.  Then Vivarium looks at the mating IDs from which those parents came, etc., until it finds animals from the “N/A” mating ID.  Those animals are ones which were received into the system (not bred in the facility).

IMPORTANT:  The only reason to modify the parent animals associated with a mating ID is to correct an error in the identity of one or more of the parents.  When you attempt to make such a change, you will see the following message:

image

In rare cases, we have seen cases of people modifying a mating record and recording a descendant as a parent.  If you do this, you will see one of the following two messages:

image

or:

image

Some earlier versions of Mosaic Vivarium did not perform this check for you, and it was possible to make an error leading to an impossible pedigree (like me being my own grandfather).  We have seen one or two instances of this out of hundreds of thousands of matings.

If you do have a pedigree loop, you will see an error when you try to setup a mating indicating the loop.  The specific animal will be identified.  The easiest way to fix this is:

  1. Search for the animal on the Animal Worksheet.
  2. Right-click on the animal’s row, and choose Mating –> “All Matings with these Parents”.
  3. Next, remove that animal from the list of parents in oldest mating record.

All your animal records will remain, but you will have incomplete pedigree information for some animals.  Of course the pedigree is already incomplete since this error likely occurred by replacing a correct parent in the mating record with a new one.

The important thing to understand is that setting up new matings is the process of putting a different set of possible parents together, resulting in a new mating ID.  Existing mating records which have litters recorded are the birth records for those animals.  Changing the parents in the offspring’s birth records (mating ID) only makes sense as an error correction if the original parents were misidentified.

Wednesday, November 13, 2013

ORACLE Bug Potentially Affecting Sites Hosting Mosaic Vivarium

If you are running unpatched ORACLE 11.2.0.1.0 64bit Production, you may experience incomplete query results.  The issue is described here:

http://arjudba.blogspot.com/2011/12/select-query-returns-wrong-result-after.html

If you do not apply patches, a work around is to add:

_index_join_enabled=false

to your init.ORA

If you use an spfile, you can issue the following command:

alter system set "_index_join_enabled"=false scope=spfile;

Monday, November 11, 2013

Update to Mosaic Online Help Site

We have migrated our online help site to a dedicated server to improve reliability.  To continue to use context-sensitive help (the “How Do I…” links) in Mosaic, sites that host Mosaic internally will need to take these steps:

Login as the “mosaic” user

Visit the Mosaic Settings page at Administration | Maintenance –> Mosaic Settings

In the Mosaic Application Configuration group, modify the following two settings:

image

The complete URLs are:

https://m1.mosaicvivarium.com/MosaicHelp/MosaicHelpHandler.aspx

https://m1.mosaicvivarium.com/MosaicHelp/SaasAlerts/alerts.aspx

NOTE:  these URLs will return a blank page if accessed directly via browser.  Content becomes available only when accessed through a Mosaic web site.