Kbase P121762: QUERY/RESULTS generates error 778 when running a specific query against Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2007 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Query/Results
Executing query against an Oracle database via Oracle DataServer
Error 778 occurs when running specific 4GL query
Error <read/writing> socket, ret=<n>, errno=<n>. (778)
Error reading socket, ret=0, errno=2. (778)
4GL query has been generated using Query/Results
Same error occurs if the query is run via a Progress client
Query uses nested FOR EACH blocks
Dataserv.lg shows the following entries:
HH:MM:SS (pid #) : ogetccno called from oradbnxt
HH:MM:SS (pid #) : oradbnxt cursid 8193 <0> mode 8 (NEXT) readloop -1
HH:MM:SS (pid #) : Select list too long -- cursor changed to no-lookahead (6408)
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Use the following parameter:
-Dsrv qt_no_lookahead