Skip to Content
author's profile photo Former Member
Former Member

Data load gets stuck- full load from ODS to Cube

Hi Experts,

I have a problem with daily full load from ODS to info cube (drop and reload every day). It fetches more than 1 million records. But from some days it fetches upto 13-15 packages and gets stuck. At this time there are normally 3 TRFCs stuck for this job. Rest all TRFCs will be progressing in the system.

Basis says Job becomes ideal at data base level. And at this time % CPU utilization randomly increases from 75% to 95%, making the whole system slow.
Please give your suggestions on how to solve this issue.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 24, 2014 at 04:53 AM

    Hi,

    why your are loading full load every day?

    get delta records from source to target.

    have you set delta in info package or DTP?

    please confirm.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2014 at 05:09 AM

    Hi,

    Try to run your load some other time and see the CPU utilization.

    if its below 70% then your load will process in time.

    if need you can increase packet sizes at dtp level which have default value 50,000 records.

    increase parallel settings or your dtp. Even before running your load, cross check available application severs, based on that you can use increase or use available application servers.

    T code - SM50 or SM51.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.