[Babase] Re: conversion errors for you
Karl O. Pinc
babase@www.eco.princeton.edu
Fri, 21 Oct 2005 20:21:08 +0000
On 10/21/2005 03:06:57 PM, MAILER-DAEMON@mail21.sea5.speakeasy.net
wrote:
Hi. This is the qmail-send program at mail21.sea5.speakeasy.net.
I'm afraid I wasn't able to deliver your message to the following
addresses.
This is a permanent error; I've given up. Sorry it didn't work out.
For additional assistance, please contact Speakeasy Customer Support via
one of the following methods:
o Phone: 800.556.5829 (Seattle-area, please call 206.728.9770);
o Email: From your Speakeasy or primary contact email address, please
email support@speakeasy.net with your issue;
o Online: Login to MySpeakeasy (http://www.speakeasy.net/myspeak) and
select Customer Support from the navigation menu.
<babase@bwf-master.princeton.edu>:
Sorry, I couldn't find any host named bwf-master.princeton.edu. (#5.1.2)
--- Below this line is a copy of the message.
Thanks.
Mostly, I get to the conversion errors when I get to trying to
nail down being done with that part of the database. If there
are ones you want me to concentrate on because they're in your
way then let me know.
On 10/21/2005 01:29:10 PM, Leah Gerber wrote:
> Karl,
>
> These are examples of the conversion errors that I think you need to
> deal with. Most types have multiple thousand errors. Possible bugs
> etc. The cycles stuff and ranks stuff is not included in this list.
> The last three error types are different and I am not sure about
> them. We will cover two of them in the conference call. the last I
> have no idea. Let me know if there is anything you would like me to
> do about thses errors. As it stands I have no idea what I could do.
>
> Talk to you later
> Leah
>
> psql:<stdin>:4: ERROR: insert or update on table "interact" violates
> foreign key constraint "Sid on SAMPLES"
> DETAIL: Key (sid)=(0) is not present in table "samples".
This one should be fixed but I've not tested.
The rest I've not looked at.
> psql:<stdin>:103407: ERROR: insert or update on table "neighbors"
> violates foreign key constraint "Pntid on POINTS"
> DETAIL: Key (pntid)=(255541) is not present in table "points".
>
> psql:<stdin>:171: ERROR: insert or update on table "adlibs" violates
> foreign key constraint "Sid on SAMPLES"
> DETAIL: Key (sid)=(26248) is not present in table "samples".
>
> psql:<stdin>:168591: ERROR: insert or update on table "fpoints"
> violates foreign key constraint "Pntid on POINTS"
> DETAIL: Key (pntid)=(255548) is not present in table "points".
>
> psql:<stdin>:4: ERROR: insert or update on table "parts" violates
> foreign key constraint "Iid on INTERACT"
> DETAIL: Key (iid)=(1) is not present in table "interact".
>
> psql:<stdin>:3: ERROR: insert or update on table "points" violates
> foreign key constraint "Sid on SAMPLES"
> DETAIL: Key (sid)=(4) is not present in table "samples".
>
> psql:<stdin>:9594: ERROR: INTERACT 421764: A : 1999-11-05: Agonisim
> and grooming dates must be the first of the month
>
> psql:<stdin>:374907: ERROR: INTERACT 543535: C : 2004-10-29:
> 06:59:00: 00:00:00: Start must be before Stop unless Act is C and
> Stop is 00:00
>
> psql:<stdin>:69411: ERROR: new row for relation "neighbors" violates
> check constraint "Either an Sname or a Unksname but not both is
> required"
>
>
>
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein