Short dump while Data Loading

[Former Member]

I added some new infoobjects to the inventory cube in different dimensions. After that when I am doing init load through 2LIS_03_BX it is getting short dumped.

There are only 85,557 records. Data Package size is 40,00 records. So it got divided into 3 Data Packages. Data Package 3 with only 5557 records got completely uploaded. But the 1st and 2nd Data Packages with 40,000 records are not getting updated. I have done the same loading many times. Everytime the same is happening.

Update PSA ( 40000 Records posted ) : No errors

Transfer rules ( 40000 -> 40000 Records ) : No errors

Update rules ( 40000 -> 78058 Records ) : No errors

Update ( 0 new / 0 changed ) : Errors occurred

Processing end : Missing messages

It is going through Update rules but not through Update. For this problem is there anything to do with other performance reasons?

REVIEW IN ST22

Whathappened?

-

---

The program "GP40LYQVJ0114605AY6CK2CP6DU" has exceeded the maximum permitted

runtime without interruption, and has therefore been terminated.

Information on where terminated

-

---

The termination occurred in the ABAP program "GP40LYQVJ0114605AY6CK2CP6DU" in

"GET_DIMID_D4".

The main program was "SAPMSSY1 ".

Thee termination occurred in line 3368 of the source code of the (Include) program "GP40LYQVJ0114605AY6CK2CP6DU" of the source code of program "GP40LYQVJ0114605AY6CK2CP6DU" (when calling the editor 33680).

Source Code Extract

-

---

3367 **@ if not l_s_dim-type = rsd_c_lineitem. " lineitem

>>>> READ TABLE G_TH_D4 WITH TABLE KEY

3369 INDSPECSTK = I_S_CUBE-INDSPECSTK

3370 SHIP_STCK = I_S_CUBE-SHIP_STCK

3371 STOCKCAT = I_S_CUBE-STOCKCAT

3372 STOCKTYPE = I_S_CUBE-STOCKTYPE

3373 INTO G_S_D4.

Any help would be greatly appreciated.

Thanks

[Former Member]

Hi,

I guess there is something wrong with your dimensions but anyway delete the request and do a new init. Before that, change the data transfer parameters for that particular request in your infopackage by Scheduler->DataSource Settings for DataTransfer. In there, setup half the size of the default setting right now. Save that change and reload.

kind regards

Siggi

PS: After successful load analyze your cube using SAP_INFOCUBE_DESIGNS.

[Former Member]

Hi,

Have you tried to load the missing data packages manually?

Right click on data package and choose option Manually.

Another option is to load to PSA only and load manually afterwards.

Udo

[Former Member]

Even when I am trying to manually update, it is again going to short dump with the same error.

[Former Member]

Hi,

Use transaction SBIW --> General settings --> Maintain Control Parameters for Data Transfer to make the data packages smaller.

Another option is to load in parts (use selection options in infopackage)

Udo