Ingress Error Codes

[John Fulmer INET]

While working with a custom SQL program (insertDB) trying to
populate an empty database with data extracted from a second
database, we received the following error.

E_US1194 duplicate key on INSERT detected

I can not find "US" in my Ingress manuals.

Anyone have any suggestions as to where to look to find out what
this error is really trying to tell me ?


-= John F =-

fulm...@pulua.hcc.hawaii.edu
ful...@cc.ims.disa.mil

John R. Fulmer, RMCS(SW), RET |
+1 808-623-7856 |
fulm...@pulua.hcc.hawaii.edu |"I ain't nothing but a poor ol' country
ful...@cc.ims.disa.mil | boy, trying to make a livin'."

,,,
(. .)
-------------------------o00-(_)-00o------------------------------

[Glenn Travis]

Look in the /sig/errhelp directory (on Unix), [.sig.errhelp] on VAX, for the err
rhelp exe program. this nifty little utility lets you query an error for a comp
lete description. There is DOCUMENTATION so read it, or type errhelp ? for onli
ne syntax.

I used it for your error and got the same message. No more explanation. the de
cimal error code for ingres is 4500. Next look in the errlog.log file for more
error help. There is usually more in there or accompanying errors.

This sounds pretty clear, though. Are you inserting into a table with unique ke
ys? this would cause it.

[bkc@cauchy]

In article <CGxpM...@news.Hawaii.Edu>, <fulm...@pulua.hcc.hawaii.edu>
writes:
> Newsgroups: comp.databases.ingres
> Path:
dirac!uunet!news.moneng.mei.com!howland.reston.ans.net!agate!ames!news.Hawaii.E
du!pulua!fulmerjo
> From: fulm...@pulua.hcc.hawaii.edu (John Fulmer INET)
> Subject: Ingress Error Codes
> Message-ID: <CGxpM...@news.Hawaii.Edu>
> Sender: ne...@news.Hawaii.Edu
> Organization: Honolulu Community College
> Distribution: comp.databases.ingres
> Date: Tue, 23 Nov 1993 07:47:14 GMT
> Expires: Mon, 22 Nov 1993 10:00:00 GMT
> Lines: 29

>
> While working with a custom SQL program (insertDB) trying to
> populate an empty database with data extracted from a second
> database, we received the following error.
>
> E_US1194 duplicate key on INSERT detected

I am a little rusty but I'll give it a try ....

I think you are trying to insert a value into a unique key column that already
has that value in it. In other words, table foo has column foo_1 that is
specified to contain only unique, non-duplicate key values. This means that
a value may appear only once in that column for that table. So if the value
1 is already in the column than trying to insert 1 again will generate this
error.

>
> I can not find "US" in my Ingress manuals.

US stands for user error, meaning the user caused the error by some invalid
activity like trying to insert a duplicate key.

>
> Anyone have any suggestions as to where to look to find out what
> this error is really trying to tell me ?

Should be in your error codes manual. A large, white, bland looking 3 ring
binder about 3 inches thick. Also, if you look in the DBA guides they list
error code classes there in one of the Appendices.