Kbase P6206: Error 454 occurs with Progress/400 DataServer when there are more than 16 columns per index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/5/2002 |
|
Solution ID: P6206
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
** The maximum number of index components is <number>. (454)
Error 454 occurs when performing a synchronize of PROGRESS/400 client
Tables exist with more than 16 Columns (key components) per index
CAUSE:
Tables exist with more than 16 Columns (key components) per index. This cannot exist as Progress allows a maximum of 16 columns per index.
FIX:
Eliminate these indexes from the p__ files.
To find out which indices have more than 16 components,
1. Do STRSQL on the AS/400.
2. Then issue the following SQL command:
select forname, indexname, numcomp from <dictionary library
name>/p__index
3. This will list the AS/400 file name, library, the index name, and the
number of columns in the index.