[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