Kbase P84475: Error 290 with write to srt file at Run-Time
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/05/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
Progress 9.x
All Supported Operating Systems
SYMPTOM(s):
Error 290 with write to srt file at Run-Time
SYSTEM ERROR: I/O error <n> in <program>, ret <n>, file <n>, addr <n>. (290)
SYSTEM ERROR: I/O error 9 in writeto, ret -1, file 6 (srt), addr <n>. (290)
Srt file grows over 2GB
CAUSE:
The possible cause for a SRT file to grow is a query not possible to be resolved by the server.
As for example,
FOR EACH CUSTOMER BREAK BY PHONE
OR
FOR EACH CUSTOMER WHERE RECID(CUSTOMER) > 0
No index involved the whole bunch of rows is returned to the client side.
If the Query is complex an related to many tables, the SRT file can grow very big on the client and result on this error.
FIX:
Modify the query to be resolved by an index (Server side) or to return to the client side less records in case no index is involved.