SAP Knowledge Base Article - Preview

2047409 - connection from Embeded SQL Program stays hanging in "recv sleep": - SAP ASE

Symptom

dbcc stacktrace output of spid in "recv sleep" shows:

kpsuspend
upsleepgeneric
usrfill
conn_hdlr

Application log shows:

ERROR IN 7110-FETCH-WQ-CURSOR
RETURN CODE = -000000000084083974
SQLERRMC: ct_fetch(): network packet layer: internal net library error: Net-Library operat
SQLERRMC: ion terminated due to disconnect
SQLERRMC: SQLCO

error executing batch COBOL program

7110 ERROR- IN FETCH OF ROW
7110 SQLCODE = -974, ERROR: ct_fetch(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)  On All Supported Platforms

Product

SAP Adaptive Server Enterprise 15.7

Keywords

isnull, Error: 9501, usrfill, Ribo trace, ansinull, Embedded SQL , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.