Symptom
- Using the hashbytes function or hash function with MD5 algorithm (Message Digest Algorithm 5) increases procedure cache utilization and generates a 701 error:
Msg 701, Level 17, State 3:
Server '<server>', Line 1:
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.
- Other algorithm such as SHA and PTN will not generate the error.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR821662, CR#821662, 821662701 hashbytes, MD5, algorithm, FASTCMP, HASH-TYPE, rs_subcmp, Data Assurance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.