SAP Knowledge Base Article - Preview

2097527 - Error SQL712 in R3load migration to SAP ASE - SAP BW on ASE

Symptom

  • During Migration of the core BW system you encounter problems in the last ABAP package to be imported, in this sample, the ABAP package _BIC_FZLMI02A, which returned this error:

Index creation stops persistently with error (DB) ERROR: DDL statement failed (/* MIGR_SYB_EXTRA_CREATE_INDEX */ CREATE INDEX "/BIC/FZLMI02A~P" ON "/BIC/FZLMI02A" ( "KEY_ZLMI02AT", "KEY_ZLMI02A1", "KEY_ZLMI02A2", "KEY_ZLMI02A3", "KEY_ZLMI02A4", "KEY_ZLMI02A5", "KEY_ZLMI02A6", "KEY_ZLMI02A7 ", "KEY_ZLMI02A8", "KEY_ZLMI02A9", "KEY_ZLMI02AU", "KEY_ZLMI02AP") LOCAL INDEX )
DbSlExecute: rc = 99 (SQL error 712)

  • The error message is returned by the DBSL on work processes developper trace file looks like this:

[ASE Error SQL712][SAP][ASE ODBC Driver][Adaptive Server Enterprise] There is insufficient heap memory to allocate 2172720 bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system. (DB) ERROR: DDL statement failed with same message for all indexes in that package.

  • You already tried increasing 'number of user connections' to a higher value as well as increasing 'heap memory per user' to the largest value the system accepts in the configuration with your max memory value (Best practice guide).
  • The problem involves creation of indexes on this partitioned F-fact table during the system import. Index creation is failing with SQL712 & SQL702 errors -- insufficient heap memory/memalloc() failures.
  • The system is in the process of migration, hence inaccessible for DDIC command access.
  • ASE error log is reporting error Msg 712 followed by a stack trace on module "memalloc".


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

702, 712, index, CR#766754, CR766754, 766754, memalloc , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.