Symptom
- When 15 or more connections simultaneously run an XML query using such as xmlextract() or xmltable(), some of them may encounter a 712 error with state 3:
Msg 712, Level 17, State 3:
Server 'ASE', Line 5:
There is insufficient heap memory to allocate <nn> bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system.
- Even if you increase "heap memory per user", a 712 error still occurs.
Read more...
Environment
- SAP Adaptive Server Enterprise 16.0
- SAP Adaptive Server Enterprise 15.7
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
CR809773, CR#809773, 809773 , KBA , sql712 , cr809773 , 'pss heap memory' , 809773 , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.