SAP Knowledge Base Article - Preview

2453962 - Error 712 occurs for XML queries - stack has xml_malloc_fragment ()

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.