Kbase P54000: Error 129 with large Query in Lookups
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/18/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 129 with large Query in Lookups
The total length of the fields in an index exceeds max key size. (129)
Customer has large number of tables in Dynamic Lookup query string and
were hitting error 129:
The total length of the fields in an index exceeds max key size (129)'.
They discovered that the in the cache manager (rysdfcmngr.p) the lookups
are being stored in ttLookup and ttMasterLookup. To the ttMasterLookup
table an index with the buffer list field is added.
The buffer list of the lookup contains more than 180 characters (279).
When this lookup is being stored in ttMasterLookup they get the error
message 129.
As a workaround they customized the cache manager. They truncate the
buffer field list to 180 characters which seems to work.
FACT(s) (Environment):
Dynamics 2.1A
FIX:
None at this time