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.
SAP Knowledge Base Article - Preview