Skip to Content
avatar image
Former Member

Data load issue in BW

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 23, 2014 at 10:29 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Dec 23, 2014 at 10:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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