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

• 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).

• 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

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