DTP step stuck at Extract. from Datastore step in Data package

[srini_walgreens]

Hi Experts,

We are performing a delta data load from one ADSO to another ADSO and this runs like 8 times everyday. But during one of the loads the DTP is taking more time at Extract. from Datastore step in the Data Package. There is code in start and end routine, but it is taking time at the start only. 

The system has ample work processes available, and the tables used in the code for lookup doesn't have any load or activation while the actual load is in progress. We even got the trace enable and notice it is taking more time at the step DB:open.

We have 4 app servers and have allocated 25 work processes for this DTP. only thing is that there are multiple (around 4-5) activation jobs each having allocated 25 WPs trigger during this load. The load used to take 35-40 mins earlier is now taking 80-100 mins with no increase in data volume.

Any insights on this issue will be really helpful. 

Regards,

Srinivas

[srini_walgreens]

Hi all, The issue has been identified. the reason this is getting stuck at Extract step is that the tables that are part of the start routine lookup are being accessed by another program in a different load. This was not found out even in RSAABAP table as the current load is ABAP and the other load is done via hana procedure. If we cancel the second load mine is running faster now.

[srini_walgreens · Accepted solution]

The load is getting stuck as the same tables used in the start routine are being accessed by a different load at the same time. cancelling the latter helped the load to run faster now.

[roland_szajko · Accepted solution]

That's an oddly specific reason. Was the other parallel process an UPDATE/WRITE process or a simple SELECT process?