Skip to Content
0

Updating attributes for Infoobject taking long runtime

Jun 14, 2017 at 10:54 AM

101

avatar image

The Updating attributes for Infoobject step of DTP_LOAD is taking long time.

"Check Duplicated Key Values" step is taking too much time.

Any suggestion?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mario Tibollo Jun 14, 2017 at 11:46 AM
0

could be linked to number range buffering...

Share
10 |10000 characters needed characters left characters exceeded
Neha Singla Jun 15, 2017 at 08:55 AM
0

Hello Anish,

There can be different reasons why DTP running taking long time:

1. Check if it is full upload from PSA and yes if it full load check how many PSA requests are coming when you pull the data.

It is also possible that might be there are duplicate entries in any of the PSA request.

Thereby when we pull the data from DTP as Full it will select all the requests from PSA.

2. Another check to ensure if no more background (BGD) jobs running in system using SM50.

3. Also is this issue came after any upgrade. You need to create indexes on IO table.

Regards

Neha


index-creation.png (61.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
Anish Kumar
Jun 15, 2017 at 11:52 AM
0

Hello Neha and Mario,

Let me elaborate the issue which I am facing here.The database here is HANA 1.00.112.0.

SAP_BW 7400 009 SAPKW74009SAP Business Warehouse.

Extraction Mode is Delta.

Processing Mode -> Serial Extraction, Immediate Parallel Process.

Data Records Inserted 1.557.260

this DTP _Load step is taking a long time. When checked I found out that "Check Duplicate key values" is taking more time here(see the screenshot)

I collected trace for this DTP_Load and the following loop statement is consuming 56% of the net time.This appears to be standard SAP code, so can't do much about this.

LOOP AT l_t_map ASSIGNING <l_s_map2>.
IF <l_s_map2>-tabix > l_prev_tabix.
SUBTRACT 1 FROM <l_s_map2>-tabix.
ENDIF.
ENDLOOP.


long-runtime.png (21.5 kB)
Share
10 |10000 characters needed characters left characters exceeded