SAP Knowledge Base Article - Preview

2047409 - Connection from Embeded SQL program hangs in "recv sleep" due to error 9501 - SAP ASE

Symptom

  • A connection from an Embeded SQL program hangs in "recv sleep"
  • The 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 

  • A Ribo trace shows that the application encountered:  Error: 9501, Severity 10 "Warning - null value eliminated in set function".


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) Not platform specific.

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 for Me (Login required).

Search for additional results

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