Data load issue in BW

[Former Member]

Hi Experts,

We have a load (DSO --> DSO) which is taking 3 hours daily. But for past 2 days it is taking 5hr.we checked if any changes moved to production in last one week and found nothing also we check the volume of data, it is increased just 50 records.The total load was handled in 3 data packets and check the Background job availability... and found all three packets got background jobs but still unable to find out the reason why it was increased in data load time.

Can any one kindly provide you valuable inputs to find the issue.

Thanks in advance.

Regards,

Senthil K.

[RamanKorrapati]

Hi,

Have you checked BW (server) load status during your loads?

During your load how many others loads are triggered in last week and this week?

Check about any special loads are scheduled.

As my guess FI Data loads might be triggered to refresh hourly basis.

You can compare last week data load(which took 3hrs) details and present week data loads(which taking 5hrs) in SM37.

Observe and find the step at which points its taking more time.

Use t code - RSODSO_SETTINGS to improve DSO load and activation time.

Thanks

[Former Member]

While you have triggered load, look at how system is processing loads using SM66, this is more of basis transaction but this will help you trouble shoot your load time. You can also do following.

- Increase your DTP batch settings to 12.

- If you can remove SID tick settings from DSO if this is not used for reporting.

- Take help of basis to see if there are free background processes available to so that your loads can resume timely.

Thanks & Regards,

Mahen

[KodandaPani_KV]

Hi,

may be i think some other loading is happening parrell at the same time.

please check process avalibility at the SM51.

incresae the parallel process at the DSO dtp screen -> select the DTP -> go to the batch manager -> increse the parellel process -> save it.

check the RSODSO_SETTINGS.

Thanks,

Phani.

[Former Member]

Hi Phani,

Thanks for your input.

We have already increased the parallel process using RSODSO_SETTINGS as below.

Activation Processes - 8

Rollback - 3

SID activation - 8

No parallel process and no special loads are scheduled.

Regards,

Senthil K.

[KodandaPani_KV]

Hi,

the problem is the some other loads happeing parallely.

you need to check the RSODSO_SETTINGS and increse the parellel process.

you can check the same target tomorrow - let us know how is it happeing the loads.

Thanks,

Phani.