[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