Kbase P124480: Progress/400 session hangs when running a stored procedure.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/06/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress/400 DataServer
IBM AS/400 (RISC)
SYMPTOM(s):
Progress/400 session hangs when running a stored procedure.
iSeries V5R3
iSeries V5R4
Progress/400 DSV V9.1C07
Client V9.1E04
When executing RUN STORED-PROCEDURE, Progress session stalls generating periodic context switch and I/O activity.
Progress client is tagged as "Not Responding" in Windows Task Manager
Requests to execute stored procedure don't reach PROSERVER job, which is idle (status: TIMW)
Compression is enabled: -Dsrv COMPRESS=1
Terminating the process manually produces drWatson memory dump.
Stack trace in drWatson file reads:
ntdll!KiFastSystemCallRet
mswsock
WS2_32!select
prow32!bsdssnddll
CAUSE:
There is a problem with data compression in 9.1E client running stored procedure on a remote server
FIX:
The only workaround is to disable compression in a connection string: -Dsrv COMPRESS=0