The total length of the fields in an index exceeds max key size. (129)

B

brong5

New Member
Hello, there,

I use character-based Progress v9, having an error message like "The total length of the fields in an index exceeds max key size. (129)", checked code found there is only 1 primary index with char (30).

The detailed error description is below.

"A PROGRESS index consists of one or more fields. For an individual record, the sum of the lengths of all fields in an index cannot be more than 188".

Wonder if anyone here can shed some light on ? Thanks.

Robin, Cincinati, OH.
 
do you have any other index other than the primary. are you sure of which table. do a index check on the database using proutil.

HTH


brong5 said:
Hello, there,

I use character-based Progress v9, having an error message like "The total length of the fields in an index exceeds max key size. (129)", checked code found there is only 1 primary index with char (30).

The detailed error description is below.

"A PROGRESS index consists of one or more fields. For an individual record, the sum of the lengths of all fields in an index cannot be more than 188".

Wonder if anyone here can shed some light on ? Thanks.

Robin, Cincinati, OH.
Click to expand...
 
Even though the indexed field has a display format of "x(30)" it is possible for it to contain more characters than that. The format is just a default display format and does not restrict the number of characters the DB actually stores.

I would say that you have assigned a large string to your indexed field and this is causing the progress error.
 
I know this is an older thread but I have version 10.1c and was wondering if there is an upper limit to character field. I've heard in previous versions we had a character field length of 256 as the default. this does not seem to be the case in 10.1c. can someone please confirm? i am getting this error if the field is associated with a index that has been migrated but when i create a new character field...we can put in whatever we want from the looks of it.
 
Starting 10.1B the maximum size of an index increased to 1972 bytes.

HTH,

Casper.
 
That's correct.

Plus if you migrate a database from a version prior of which the limit of the max key size was increased you need to switch it on manually.

Heavy Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top