SAP Knowledge Base Article - Preview

1997967 - Execution of large XML query fails with error 712 "There is insufficient heap memory to allocate..." or corrupt (very large or negative) error with stack trace - ASE

Symptom

  • A query accessing large XML files fails with ASE error 712:

There is insufficient heap memory to allocate <value> bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system.

  • A corrupt (very large and/or negative) error number is returned:

02:0008:00000:08508:2013/11/22 14:48:41.44 server Error: -1397969760, Severity: 538976288, State: 538976288

  • A stack trace accompanies the corrupt error

bi_xml_xquery_close()

  • Query using XMLTABLE() function
  • Failed query is executed multiple times concurrently

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.