Symptom
- This XML query
select top 50 *
from dbo.test_table sb
inner join XMLTABLE('/ROOT/CC' PASSING @xml COLUMNS CC int PATH '') sec
on sec.CC = sb.CD
select @x=@x+1
- Raises this Error
Error: 712, Severity: 17, State: 3 There is insufficient heap memory to allocate xxxxx bytes.
Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system.
- An ASE memory dump may contain a stack similar to what is shown next
xml_malloc_fragment
XmlMallocFragment
sybnewm
RefHashTableOfI
XMLTransService
XMLPlatformUtils
AseXercesSession
PortalUtil
XmlQuery
bi__xml_query
bi_xmlextract
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) ASE 15.7
- SAP Adaptive Server Enterprise (ASE) ASE 16
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
XML heap stack , KBA , sql712 , 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.