Kbase P42672: MM- Sorting error (7722) when running large SQL-92 queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/17/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
MM- Sorting error (7722)
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-16025
[JDBC Progress Driver]:MM- Sorting error (7722)
Running query from either a JDBC or ODBC client.
Running a very large SQL-92 query
CAUSE:
The SQL-92 engine has run out of disk space while expanding the sort file on the database server.
FIX:
The sort files (or temporary files) are created in the default working directory unless specified by the WRKDIR environment variable. These temporary files have a size limit of 500MB. In order to solve this problem please do the following:
1.) Make sure there is enough free disk space for the temporary files in the working directory to reach 500MB.
- OR -
2.) Increase the temporary file limit of 500MB by defining the TPE_MM_SWAPSIZE environment variable on the database server. The default value is 500000 (500MB) in units of 1KB. The database needs to be restarted for the changes to take effect. Alternatively you can use the -SQLTempDisk database startup parameter when using Progress 9.1D Service Pack 6 or higher.