cancel
Showing results for 
Search instead for 
Did you mean: 

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

srini_walgreens
Explorer
0 Kudos
179

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
Explorer
0 Kudos
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.
View Entire Topic
roland_szajko
Product and Topic Expert
Product and Topic Expert
0 Kudos

Check the guided answer:

https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/3347/actions/52968/?version=current

It's important to know:

  • ABAP or HANA runtime
  • Which part takes long (extraction, transformation, update)?
  • ST12 trace
srini_walgreens
Explorer
0 Kudos
Hi, The transformation is running on ABAP runtime, the extraction part is taking more time. The trace is also showing more time at DB: Open
roland_szajko
Product and Topic Expert
Product and Topic Expert
0 Kudos
What is the SQL statement? Was a planviz generated and analysed by your HANA admins?