SAP Knowledge Base Article - Preview

3100503 - Bad TDS error 1622 caused infinite loop, out of memory error 701 and high CPU

Symptom

  • Some processes raised error 701 due to no free memory in procedure cache memory pool. Message of error 701:

"There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache."

  • There exists some processes which were taking high CPU time and memory, 'dbcc pss(0, high_cpu_spid)' or sybmon command 'pss high_cpu_spid' show:
    • plasterror=1622         --- last error = 1622, the bad TDS error message is 'Type xxx not implemented.'
    • pcpucur: high_value           --- cpu time for current statement was high
    • pmemusage: high_value     --- # of memory pages from procedure cache memory pool was high


  • The high_cpu_spid was running in infinite loop with the following stack:

ssl_nrpacket
       
ksmask_rpacket
        
kstcpnetctlrPostRead
       
ksmaskrpost
        
usrfill

flushtoeom
        
tdsrecv_errorhdl
        
conn_hdlr


        


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Keywords

CR 825378, 825378, CR 825414, 825414, error 1622, infinite loop, tdsrecv_errorhdl , 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.