Kbase P13440: Too much data being fetched causes error (163) at 2 GB.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/2/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3X
SYMPTOM(s):
SYSTEM ERROR: Seek error <value>, file <value>, addr <value>. (163)
SYSTEM ERROR: Seek error 22, file 7, addr -2147483648. (163)
Srt file of 2 GB size is present in the application working directoty.
Running query which produces huge output of data
Client is disconnected from a database
Query never ends
CAUSE:
Query contains non-indexed read which is causing .srt reaches the 2 GB limit
FIX:
It is neccesary to break the query in smaller parts or add indexes to the DB to avoid the non-idexed data.