Skip to Content
author's profile photo Former Member
0
Former Member
Nov 18, 2005 at 02:18 PM

no more SQL activity during INIT DELTA Load

39 Views

Hi,

I have an infopackage in 'init delta load' mode, wich run from a source BW to the same BW target.

When i run it, it keep running without doing anything after few SQL statements. For Exemple (SM37 on request) :

Job lancĀE

Etape 001 lancée (programme SBIE0001, va

DATASOURCE = 8ZCCA_C11

***************************************

  • Current Values for Selected

***************************************

  • abap/heap_area_nondia......... 200000

  • abap/heap_area_total.......... 200000

  • abap/heaplimit................ 400000

  • zcsa/installed_languages...... DEF

  • zcsa/system_language.......... F

  • ztta/max_memreq_MB............ 250

  • ztta/roll_area................ 200000

  • ztta/roll_extension........... 200000

***************************************

SQL: 18.11.2005 12:32:19 SOPRA20

drop index "/BI0/0P00000021~0"

SQL-END: 18.11.2005 12:32:19 00:00:00

...

SQL: 18.11.2005 12:37:39 SOPRA20

INSERT INTO "/BI0/0P00000026" ( "DIMID"

,"TC013" ,"TC014" ,"TC015" ,"TC020" ,"T

SELECT DISTINCT "D3"."DIMID"

...

BETWEEN 10 AND 20

SQL-END: 18.11.2005 12:37:39 00:00:00

=>After that : do nothing but still runing...

Thanks for help

Etienne