SAP Knowledge Base Article - Preview

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


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. You have this returned:

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' from 500 (Best practice guide) 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.

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.



SAP NetWeaver 7.0


702 index DDL failed, CR#766754, CR 766754, 766754 , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.