Symptom
- ASE became unavailable due to procedure cache usage at 100%.
- 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."
- Some processes raised error 701 due to no free memory in procedure cache memory pool. Message of error 701:
- 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
Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR 825378, 825378, CR 825414, 825414, error 1622, infinite loop, tdsrecv_errorhdl , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
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.