SAP Knowledge Base Article - Preview

2515782 - Error 712 State 3 occurs when 15 or more XML queries run concurrently - SAP ASE

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 , 'pss heap memory' , 809773 , cr809773 , 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.