Kbase P24759: Getting 7568 when performing a SQL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/14/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.0A
All Supported Operating Systems
SYMPTOM(s):
Too many indexes on this table (7568)
Executing a SQL query
A table involved in the query has many (greater than 20) indexes.
There are more than 250 index components counted in all indexes on the table.
CAUSE:
Bug# 20030507-003
CAUSE:
The SQL engine imposed a limit on the number of 250 index components for a table. Therefore if there are (say) 50 indexes, each with 6 index components, the table uses a total of 50*6=300 index components, which is higher than the limit.
FIX:
Upgrade to Progress 9.1D09 or later release
Upgrade to OpenEdge 10.0B or later release
Workaround:
Remove some indexes or some of their field components so that there are no more than 250 index components for the table.