Kbase P97054: Error: HResult 0x80004005 attempting to retrieve quite a large quantity of data via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/01/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Error: HResult 0x80004005
Unexpected error occurred. An error result was returned without an error message.
ODBC SQL-92 engine used
attempting to retrieve quite a large quantity of data
Same query works fine with 4GL
running the query through SQL Explorer fails with:
[JDBC Progress Driver]:MM- Sorting error (7722)
ErrorCode=-16025
CAUSE:
Running out of disk space on the server for the sorting of data
FIX:
Make sure the disk space available is greater than the default limits (unit = 1kb):
set TPE_MM_CACHESIZE=1000
set TPE_MM_SWAPSIZE=500000
set TPE_MM_BLOCKSIZE=7
For the case the problem persists increase the limits:
Examples:
set TPE_MM_CACHESIZE=8000
set TPE_MM_SWAPSIZE=1000000
and
set TPE_MM_BLOCKSIZE=10
before starting the database.