[Babase] errors

Jeanne Altmann babase@www.eco.princeton.edu
Tue, 13 Jul 2004 15:12:22 -0400


hi,
for tomorrow:
--status of speedup
--conversion of other tables?
--changing repstat table?
other?
j

At 11:17 AM 7/12/2004 -0500, you wrote:

>On 2004.07.12 09:06 Jeanne Altmann wrote:
>>Thanks Steph,
>>just a few notes at this point:
>>At 05:38 PM 7/9/2004 -0400, you wrote:
>>>Hi again everyone,
>>>(Susan - I'm copying you on this, but if you don't want all of this info 
>>>in the future, let me know).
>>>
>>>  I've looked through some of the errors (those that are listed on the 
>>> first 40 pages or so).  Here's a list of ones that we need to discuss 
>>> or that make me go "hmmm".  Email input is fine, or note whether 
>>> certain ones need to be discussed on Wed.
>>
>>>1) Biograph statdate can't be less than mature dates.  This happens for 
>>>JUN and NIN.  We are changing this, correct? i.e. statdate won't really 
>>>be the reference, but something that also checks their status (alive or not).
>>RIGHT, THAT WAS AGREED ON LAST WEEK
>
>Right. Havnen't changed the rule yet.
>
>>
>>>2) Rule violation: mature dates must be between 3 and 7 years of birth. 
>>>This is violated for ALEX who matures around 7.5ish.  Leave rule and 
>>>ignore Alex?
>>
>>SUSAN, WHAT DO YOU THINK?  ALEX IS A TOTAL OUTLIER, AND WE DON'T HAVE A 
>>GOOD BIRTHDATE FOR HIM AS HE WAS A JUVIE IMMIGRANT. COULD HE HAVE BEEN SO 
>>MUCH YOUNGER THAN WE HAVE RECORDED?  DO WE WANT TO UP THIS TO 
>>7.5?  REMEMBER, WHATEVER AGE WE USE, THE PROGRAM WILL HOLD US TO IT, WE 
>>CAN'T DO A 'BYPASS', RIGHT?
>
>Right.
>
>>
>>>3) Cycles must be sequential for each female and the first seq for each 
>>>female must be 1.  While these are sensible rules, it's messing up on a 
>>>lot of females.  All of the females I checked (and I checked most of 
>>>them) have seq's (in cycles) from 1 to whatever BUT there are many 
>>>situations where their order in cycles goes something like 
>>>2,3,4,1,5,6,etc.  The conversion program doesn't seem to like this.
>>>Look at DAD or EST for examples, although there are others.
>>KARL, WHAT IS THIS ABOUT?
>
>When one of the cycles won't go in due to an error, all the rest with
>higher numbers won't go in either because that'd make a 'gap'.  Fix
>the one that won't go in and these errors go away.
>
>>
>>>4)  cycle is not a conception and has no dates.  This is ok, right? 
>>>Apparently these are "fillers"? - because in some cases these lines are 
>>>totally blank in cycles.  Of course, I am a little confused as to why 
>>>there are totally blank lines in there in the first place.
>>>help.
>>WE NEED FOR INFO ON THIS
>
>We talked about this.  This is for pregnancy conception cycles.  I thought
>I got the rule changed, but maybe I didn't or havn't installed it yet.
>Been busy with speeding things up.  Can Steph take a look and see
>if these are pregancy conception cycles?
>
>>
>>>5)biograph statdate can't be less than cycles tdate or ddate.
>>>Similar to error 1 above.  again - status is being added as a reference 
>>>correct?  of course, this particular kind of error did help me catch one 
>>>female who apparently cycled after she died.  oops.
>>RIGHT
>
>Right. See above.
>
>>
>>>6) sexskins dates overlap with the following cycles M date.  Yes, does 
>>>happen for LULU (see LUL seq 43).  help jeanne.  I'm thinking that the M 
>>>date should have gone with the previous cycle? or is this rule not quite 
>>>fine-tuned enough?
>>I'M NOT CLEAR ON THIS
>
>Check to see if it's a data problem or a rule problem.
>
>>
>>>7) error: sexskins cid blah: maturedates.matured cannot be less than 
>>>sexskins.date.  OK, in theory this error makes sense to me.  But, the 
>>>female it's referring to matures well before the listed sexskin 
>>>dates.  So karl, where is it looking?  what's maturedates.matured?
>>KARL?
>
>Maturedates is now on the MATURES table, not biograph.
>
>I think this rule is just wrong and it should be the other way around.
>Right?
>
>
>>
>>>8) cid on cyles - key referenced from sexskins not found in cycles. 
>>>scary message.  couldn't find source of error.  I'm still trying to 
>>>figure out which female this is referring to.
>
>Doesn't it give you the bad cid on sexskins in the message?  Very likely
>this is a cycle row that didn't make it into the new database because of
>another error.
>
>
>Karl <kop@meme.com>
>Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>_______________________________________________
>Babase mailing list
>Babase@www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase