[SOLVED] Re: afinderr

"James B. Byrne via Aubit4gl-discuss" <[email protected]> Tue, 9 Feb 2021 10:40:49 -0500
Newsgroups gmane.comp.lang.4gl.aubit.general
Message-ID <[email protected]>

On Tue, February 9, 2021 10:17, James B. Byrne wrote:
>
> I read in the Aubit4GL manual this:
>
> 12.2 afinderr
>
> Usage:
> $ afinderr errornumber
> This will trawl through all of the message files in the $AUBITDIR/etc directory
> looking for any help messages associated with that help number. This is useful
> because the same error numbers could come from multiple places (eg. either
> Informix or Postgres) and hence may well have a different meaning.
>
> But I cannot see any message files in that directory:
>
> $ ll $AUBITDIR/etc/*.msg
> ls: /etc/*.msg: No such file or directory
>
> The reason I ask is that I am getting an error in exercise-09 of Informix by
> Example which states:
>
> -239: Unable to complete customer insert.
>
> I believe that the program is attempting to add a duplicate id number into a
> serialized column.  But I would like to know what error 239 specifically means.
>
>

I discovered two things after writing this:

1. I should be looking for \*hlp and not \*msg.  This did not matter as there
were no .hlp files in $AUBITDIR/etc either.

2. The gmake program evidently did not run in aubit4glsrc/help/help so the
necessary files were neither created nor copied to $AUBITDIR/etc.  This has
been remedied.

Now I obtain this:

afinderr -239
/opt/aubit4gl/etc/helpsql_POSTGRES8.hlp:
-239 duplicate key violates unique constraint




-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[email protected]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3