2139552 - Error 712, "insufficient heap memory" when running DBCC LISTOAM on a large table with high OAM page count - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2139552 - Error 712, "insufficient heap memory" when running DBCC LISTOAM on a large table with high OAM page count - ASE

Symptom

  • Database has large tables with high object allocation map (OAM) page counts 
  • Getting error 712 when running DBCC LISTOAM on a large table to check the OAM page count:


    dbcc listoam(<dbid | dbname>, <objid | objname>, <indid | indname>)
    go

  Msg 712, Level 17, State 1:
  Server 'XXXXXX', Line 1:
  There is insufficient heap memory to allocate 65052912 bytes. Please increase configuration parameter 'heap memory per user' or try again when
  
there is less activity on the system.DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , stack overflow , signal 11 , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.