[Babase] VIV sexskin not uploading due to missing mdate
nlearn at princeton.edu
nlearn at princeton.edu
Sat May 30 08:43:05 EDT 2009
On Fri 29/05/09 6:31 PM , "Karl O. Pinc" kop at meme.com sent:
On 05/21/2009 12:05:41 PM, Niki Learn wrote:
> -----Original Message-----
> From:
javascript:top.opencompose(\'babase-bounces at eeblistserv.Princeton.EDU\',\'\',\'\',\'\')
[1]
>
[javascript:top.opencompose(\'babase-bounces at eeblistserv.Princeton.EDU\',\'\',\'\',\'\')
[2]] On Behalf Of kfenn
> Sent: Wednesday, May 20, 2009 12:37 PM
> To: The Baboon Database Project
> Subject: [Babase] VIV sexskin not uploading due to missing mdate
>
> 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.
>
> However, in the following update period, I removed her pregnancy
from
> PREGS when Jeanne decided this was not a real pregnancy.
I think Tabby nailed the problem: The automatic mdates were
not updated when a pregnancy (PREGS row) was deleted.
I believe I have (finally) fixed this. It would be good
if somebody besides me would double check the fix by
deleting a pregnancy and watching what happens to the
automatic Mdates.
Cool. Lacey will still be working on her uploads for at least part
of next week and Tabby and I are starting the process of determining
the female ranks on Monday. I do have a false pregnancy from
December I can delete to test this soon when I have a good
opportunity.
The next step is to fix the database. Either we need to
remember all the pregnancies that have been deleted
and manually make changes or we need to schedule a time
for me to temporarily turn off all the data validation
and rebuild the automatic Mdates.
I should be able to figure out what other pregnancies have been
deleted if that is the safer way to do this.
> FYI, today WEN has an mdate for the cycle in question - guess it
just
> took a
> while for it to be automatically generated after we added her
ddate.
That does not sound right. When a Ddate goes in there should always
be an automatic Mdate right away. Did you see a time when there was
a Ddate but not an automatic Mdate?
Hmm... It is possible that we only checked it once the day we added
the ddate. If that is the case, we did it all it one query so perhaps
it wouldn't have shown up until we did the query again. I will check
this when I do the final upload on the 2007 sexskins in the next
couple weeks and will let you know what I find.
Thanks!
Niki
Links:
------
[1] mailto:babase-bounces at eeblistserv.Princeton.EDU
[2] mailto:babase-bounces at eeblistserv.Princeton.EDU
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20090530/694012ed/attachment.html
More information about the Babase
mailing list