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

[WayneFrank]

I am getting the error


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


When I look up error 129 it says the sum of the lengths of all the fields in an index cannot exceed 188.


I look at all the indexes in the tables I use and nowhere is an index longer than 188. Not even close.


One thing - There is a new table in this process, and it does not have any indixes defined. It just has


Flags Index Name Cnt Field Name
----- -------------------------------- --- ---------------------------------
p default 0 +




Could that be the problem?


Thanks

 

[TomBascom]

You seem to be using an ancient, obsolete and unsupported release... (the maximum key length has been increased significantly in 10.2).

Are any of the fields making up the indexes character fields? Are they ever manipulated by code? Does concatenation or substitution ever occur?

Have you checked all data in those fields with the length() function? Or are you assuming that the FORMAT is doing the job for you? (If you are making such an assumption you are in trouble...)

 

[WayneFrank]

Yes, my version of progress is ancient obsolete and unsupported. So am I but I digress.

I got new data and the problem has disappeared. Thanks anyway.

 

[TomBascom]

Yes, my version of progress is ancient obsolete and unsupported.

On the bright side you can add yet another good reason to upgrade to all of those that your previously had.

So am I but I digress.

Welcome to the club!

I got new data and the problem has disappeared. Thanks anyway.

Meaning that someone cleaned up something that was too big?