Updating attributes for Infoobject taking long runtime

[former_member440105]

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?

[former_member440105]

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.

[Former Member]

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

[former_member186445]

could be linked to number range buffering...