Kbase P151933: Error 11353 and 129 when creating a temp-table record with a large index key
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/08/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 11353 and 129 when creating a temp-table record with a large index key
(11353) The total length of the fields in an index exceeds max key size. Index <index-name> of table (TEMP-TABLE)<temptable-name> (129)
FACT(s) (Environment):
Temptable blocksize has been set to 1Kb using -tmpbsize 1
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
The large index key enhancement was added in 10.1B.
Temptables are held within a locally created database and therefore the rules for large index keys also apply to temptables. Large keys are only supported in databases with 4Kb or 8Kb block sizes.
FIX:
There are two solutions to this problem:
1. Reduce the size of your index keys by reducing the number of index components or by reducing the size of the data within the components.
or
2. Change the temptable block size to either 4Kb or 8Kb by using the -tmpbsize client startup parameter:
-tmpbsize 4 (default)
or
-tmpbsize 8