2333298 - DTP fails with ASE Error SQL712 "There is insufficient heap memory to allocate..." | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2333298 - DTP fails with ASE Error SQL712 "There is insufficient heap memory to allocate..."

Symptom

  • Execution of DTP/Process Chain generate ABAP dump when trying to insert data on F table:
Category                Installation Errors
Runtime Errors          DBSQL_SQL_ERROR
Except.                 CX_SY_OPEN_SQL_DB
Date and Time           <datetime>
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short Text                                                                                                                                                
|    SQL error "SQL code: 712" occurred while accessing table "/BI0/Fxxxxxxx".               
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened?                                                                                                                                    
|    Database error text: "SQL message: [ASE Error SQL712][SAP][ASE ODBC                      
|     Driver][Adaptive Server Enterprise]There is insufficient heap memory to                       
|     allocate 2126124 bytes. Please increase configuration parameter 'heap memory        
|     per user' or try again when there is less activity on the sy"                                                  
----------------------------------------------------------------------------------------------------
  • The "Source Code Extract" of the ABAP dump points to this line:
|>>>>>|  INSERT (l_facttab) FROM TABLE g_t_u.                                                      
  • From SM21 you have similar messages:

 @5C\Qvery high priority@ BY4 Database error 712 at INS access to table /BI0/Fxxxxx
 @SR\Qinformation@ BY0 > [ASE Error SQL712][SAP][ASE ODBC Driver][Adaptive Server
 @SR\Qinformation@ BY0 > Enterprise]There is insufficient heap memory to allocate
 @SR\Qinformation@ BY0 > 2175888 bytes. Please increase configuration parameter 'heap
 @SR\Qinformation@ BY0 > memory per user' or try again when there is less activity on
 @SR\Qinformation@ BY0 > the system.
 @5C\Qvery high priority@ AB0 Runtime error "DBSQL_SQL_ERROR" occurred.
 @SR\Qinformation@ AB1 > Short dump "xxxxxx xxxxx xxxx_xxx_xxx xxxxxx" created.
 @5C\Qvery high priority@ xxx Transaction Canceled xx xxx (DBSQL_SQL_ERROR xxxxxx xxxxx xxxx_xxx_xxx xxxxxx)

  • You have increased the below parameter "'heap memory per user" of the ASE configuration, but issue is still there.
  • The last version of the SAP Note BW Correction Collection is implemented (please refer on the "See Also" section of this KBA the SAP Note related to your BW version).

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

SQL712, heap memory, 712, process chain, DTP, DBSQL_SQL_ERROR , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , BW-BEX-OT-DBIF , Interface to Database , BW-WHM-DST-DTP , Data Transfer Process , BW-WHM-DBA-ICUB , InfoCubes , Problem

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.