Kbase P24197: SYSTEM ERROR (290) when temporary directory size is too small.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
SYMPTOM(s):
Temporary directory is running out of space when running a 4GL procedure.
SYSTEM ERROR: I/O error <n> in <readit>, ret <n> file <n>, addr <n>. (290)
SYSTEM ERROR: I/O error <0> in <readit>, ret <539>, file <13>, addr <0>. (290)
CAUSE:
Running the whole procedure as one transaction in a major loop against several tables and the size temporary directory is too small to accommodate the temporary files being generated.
FIX:
1) Ensure that the temporary directory size is large enough to accommodate the temporary files progress needs to generate during processing. The startup parameter -T may be used to point for the session's temporary directory.
2) Optimize the code by narrowing the scope of the transaction if possible or introducing appropriate indexes.