Kbase 20455: Getting error 7711 when retrieving data via SQL92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/20/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Performing a SELECT with an ORDER BY
Total length of columns listed is 7K in size
MM- Row too big (7711)
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-16007
[JDBC Progress Driver]:MM- Row too big (7711)
Error: === SQL Exception 1 ===
SQLState=HY000
ErrorCode=-16007
[JDBC OpenEdge Driver]:MM- Row too big (7711)
HY000: [DataDirect][ODBC PROGRESS driver][PROGRESS]MM- Row too big (7711)
A .trc file contains: MM exception - status = -16007
CAUSE:
The SQL92 engine had to sort a result set and the result set is sorted in a temp table where the physical size of a row in the temp table is limited to 8K. The size of the records being sorted exceeded that limit.
FIX:
Starting with 9.1D07 you can use the database server startup parameter -SQLTempPgSize.
Increase the value to 16, which is twice the default. (It not recommend to have a value higher than 32k).