[Babase] VIV sexskin not uploading due to missing mdate

kfenn kfenn at princeton.edu
Wed May 20 12:36:59 EDT 2009


Hi Karl,

We have a perplexing question relation to uploading sexskin size date to 
the SEXSKINS_CYCLES view.

One female, VIV, cycled in June of 2007 but shut down until October of 
the same year.

Niki was trying to upload her October sizes and got the following error 
message:
ERROR: Sxid 144307: Cid 27583: 2007-10-17: No Mdate found for this cycle

OK, fair enough.  We thought she was pregnant in June and entered her 
June Ddate into Pregs as a conceive date.  According to the automatic 
mdate generation rules we violated #2 so an automatic mdate should not 
have been generated:

An Mdate will be generated from a Ddate when all of the following 
conditions are met:

    * Either there is no Mdate in the cycle following the Ddate's cycle
      or there is a gap in observation between the Ddate's cycle and the
      following cycle.
    * The Ddate is not the start of a pregnancy, its Cpid
      <http://papio.biology.duke.edu/babase_system_html/ch03s10.html#Cycpoints-Cpid>
      does not appear as a Conceive
      <http://papio.biology.duke.edu/babase_system_html/ch03s07.html#Pregs-Conceive>
      value on the PREGS
      <http://papio.biology.duke.edu/babase_system_html/ch03s07.html>
      table.
    * Observation proceeds without a gap for at least 13 days following
      the Ddate, or up to the Tdate immediately following the Ddate,
      which ever comes first,
    * The Ddate is not estimated. (Source
      <http://papio.biology.duke.edu/babase_system_html/ch03s10.html#Cycpoints-Source>
      is not E)
    * The individual is alive (BIOGRAPH
      <http://papio.biology.duke.edu/babase_system_html/ch03s02.html>.Status
      <http://papio.biology.duke.edu/babase_system_html/ch03s02.html#Biograph-Status>
      is 0) on the automatic Mdate.^[107
      <http://papio.biology.duke.edu/babase_system_html/ch04s05.html#ftn.id2947815>]



However, in the following update period, I removed her pregnancy from 
PREGS when Jeanne decided this was not a real pregnancy.  

I assume that Babase would generate an automatic mdate once the 
conditions changed and the conditions listed above were again all met.  
Is this what you would expect too?  If so, why do you think there is NO 
auto Mdate generated for Viv's June 2007 cycle? 

BTW I'm working in Babase_test.



Two more questions....
I missed uploading a ddate back in April 2007 for a female named WEN.  
She had a normal cycle right after that and I was allowed to skip the 
ddate in April and upload the subsequent cycle without the system 
throwing an error.  There was no gap in observation....any idea why I 
got away with this? 

As a follow-up to this question (because I need to enter her ddate now) 
it appears I am not allowed to run an UPDATE statement for the 
mtd_cycles view.  Do you want db managers /not/ to be able to update 
views and instead go to the raw tables?  I vaguely recall that you 
thought we could run UPDATE views...



Thanks,
Tabby

^






Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list