0CO_OM_NWA_2 data source take more time to extract data

[Former Member]

Hi Experts,

I am dealing with Project Systems in that 0CO_OM_NWA_2 (Network Activity Actual cost through delta extraction) data source take more time(around 3 hours) to extract data from R/3.

Could you please suggest how to improve the performance?

Your points are assured..

With kind Regards,

Madhu Ponnada

[Former Member · Accepted solution]

HI madhu,

Please provide more info... How many records in the source. BCoz sometimes it takes more than that ! Any routines it has in place?

Regards,

ARK

[Former Member · Accepted solution]

Hi ARK,

It is a delta upload and picks 2000 records per day and No routines.

Regards,

Madhu Ponnada

[Former Member]

3 hrs to extract 2000 records is abnormal.

PL check the following:

1. How many data loading jobs are scheduled at the same time when this data source gets loaded.

2. whether the master data is loaded before this load. If not, make the changes and load the master data before transaction data.

3. Try to load this info package outside of the process chain.

If the problem still persists, it is better to involve your DBA and basis.

Ravi Thothadri