Clipper - Internal error 4412

Author

Internal error 4412

John Linville

2005-09-22, 6:55 pm

Hello

Got a strange one here on creating a CDX.

get a OrdCreate(0) internal error 4412

..
..
if file opened and able to delete the old cdx
PrnH := true

endif

if PrnH
select PrnHst
@ 7,2 say "Invoice Print History"
ordCreate("PrnHist","Invoice","Invno")
send PrnHst->DbCommit:
send Prnhst->DbCloseArea:
* Index on Invno to "PrnHist"
@ 7,20 say Transform(prnHst->(lastrec()),"99,999,999")+" Records Indexed"
endif
There are 270,000 plus records in the dbf

Using "DBU" ( a database utility) I can create the cdx file ok

--
Don't go around saying the world owes you a living. The world owes you
nothing. It was here first.
Mark Twain (1835 - 1910)

John Linville

AUGE_OHR

2005-09-22, 6:55 pm

hi,

> get a OrdCreate(0) internal error 4412

*** snip ***
4412 Indexing miscalculation

This error occurs during indexing if there has been a miscalculation of
how indexing should occur.

This error may be a "magic number" type of error. It's possible that
this error will disappear if more or less records are present in the
database.

4412 Indexing miscalculation

Explanation: This error occurs during indexing if there has been a
miscalculation of how indexing should occur.

Action: Some suggestions to resolve the problem are:

1. Try increasing available conventional memory for indexing operation.

2. Try indexing using a small test program.

3. Test recreating the index with one more or one less database record.

4. Test recreating the index with one more or one less byte in the key
expression.

5. Test adding CHR(0) to the key.

6. Test with the E:0 parameter in the SET CLIPPER environment variable.

Note: The LEN( CHR(0) ) is one byte, the LEN("") is 0 bytes. Test
with combinations of the above suggestions.

*** eof ***

> Using "DBU" ( a database utility) I can create the cdx file ok

DBU & CDX ? did you modify it ?

greetings by OHR
Jimmy

John Linville

2005-09-22, 6:55 pm

Created the index in DBU the same field as in the app module. Was doing it
with a smaller number of records. Also tried using a Char field instead of a
numeric in the app and it still gives the same error.

"DBU" is a third part utility written in Clipper. all indexing works within
it. Got to be something in my app emviroment. Will try the SET CLIPPER=E:0

Will keep you posted

Thanks

--
Don't go around saying the world owes you a living. The world owes you
nothing. It was here first.
Mark Twain (1835 - 1910)

John Linville

"AUGE_OHR" <AUGE_OHR_NOSPAM_@CSI.COM> wrote in message
news:dguomc$i46$04$1@news.t-online.com...
> hi,
>
>
> *** snip ***
> 4412 Indexing miscalculation
>
> This error occurs during indexing if there has been a miscalculation of
> how indexing should occur.
>
> This error may be a "magic number" type of error. It's possible that
> this error will disappear if more or less records are present in the
> database.
>
> 4412 Indexing miscalculation
>
> Explanation: This error occurs during indexing if there has been a
> miscalculation of how indexing should occur.
>
> Action: Some suggestions to resolve the problem are:
>
> 1. Try increasing available conventional memory for indexing
> operation.
>
> 2. Try indexing using a small test program.
>
> 3. Test recreating the index with one more or one less database
> record.
>
> 4. Test recreating the index with one more or one less byte in the key
> expression.
>
> 5. Test adding CHR(0) to the key.
>
> 6. Test with the E:0 parameter in the SET CLIPPER environment
> variable.
>
> Note: The LEN( CHR(0) ) is one byte, the LEN("") is 0 bytes. Test
> with combinations of the above suggestions.
>
> *** eof ***
>
>
> DBU & CDX ? did you modify it ?
>
> greetings by OHR
> Jimmy
>
>

John Linville

2005-09-22, 6:55 pm

I'm Sorry I used "DBA" not DBU. another blonde moment

John

--
Don't go around saying the world owes you a living. The world owes you
nothing. It was here first.
Mark Twain (1835 - 1910)

John Linville

"AUGE_OHR" <AUGE_OHR_NOSPAM_@CSI.COM> wrote in message
news:dguomc$i46$04$1@news.t-online.com...
> hi,
>
>
> *** snip ***
> 4412 Indexing miscalculation
>
> This error occurs during indexing if there has been a miscalculation of
> how indexing should occur.
>
> This error may be a "magic number" type of error. It's possible that
> this error will disappear if more or less records are present in the
> database.
>
> 4412 Indexing miscalculation
>
> Explanation: This error occurs during indexing if there has been a
> miscalculation of how indexing should occur.
>
> Action: Some suggestions to resolve the problem are:
>
> 1. Try increasing available conventional memory for indexing
> operation.
>
> 2. Try indexing using a small test program.
>
> 3. Test recreating the index with one more or one less database
> record.
>
> 4. Test recreating the index with one more or one less byte in the key
> expression.
>
> 5. Test adding CHR(0) to the key.
>
> 6. Test with the E:0 parameter in the SET CLIPPER environment
> variable.
>
> Note: The LEN( CHR(0) ) is one byte, the LEN("") is 0 bytes. Test
> with combinations of the above suggestions.
>
> *** eof ***
>
>
> DBU & CDX ? did you modify it ?
>
> greetings by OHR
> Jimmy
>
>

Sponsored Links