Kbase P123004: error (7707) when temporary file reaches 2GB when doing SQL-query in AIX and 9.1E
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/03/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 with heavy temporary file load fails with error:
Error: java.sql.SQLException: [JDBC Progress Driver]:MM- Bad swap block (7707)
temporary file reaches 2GB.
-SQLTempDisk is set to a value higher than 2GB.
it works on Solaris and Windows.
it works on 10.1B
FACT(s) (Environment):
Progress 9.1E
IBM AIX
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Upgrade to 10.1B or try improving the indexing.