Skip to Content
avatar image
Former Member

Updating attributes for Infoobject taking long runtime

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 14, 2017 at 11:46 AM

    could be linked to number range buffering...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 15, 2017 at 08:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 15, 2017 at 11:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded