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

DSO DTP Load Issue with RED status


The DSO data load is giving an issue with no error message.

The overall status is set to 'RED' on Header Tab after 1 day of load.

If you look at the Details Tab all the datapackage status will be Green, when expanded the last 3 data package the load is not complete, only the first step Extraction datasource is green and all other steps are greyed and in yellow status.

'Set Technical status to Red' is also in Green status.

'Set overall status to 'Rot' (user XXXXXX)' also in Green status.

There is no error message from this load.

I changed the RSODSO_SETTINGS for this specific DSO and still I get the above status. Process chain is used to run this load on weekly basis, a full load.

Is there a way to find out the exact reason for this behaviour?

Thank you


Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jan 27, 2014 at 09:13 AM

    As you are facing issue with the DTP data load ,have you tried increasing the No of parallel process in the DTP batch manager?

    DTP --> Menu -->Goto --> Settings for Batch Manager --> Increase the no of parallel processes to 6 and make sure background processing is selected with job priority.

    RSODSO_SETTINGS - this is used to change/config the settings for DSO activation not for executing the DTP.

    can you share the last 3 data packets expanded screen shot... Some time DTP load might get failed due to resource crunch. as you said its a full load , can you tell us what is the data volume of this load?

    At the time of this load are there any other data loads which are executed in BW system?

    have you tried executing the DTP manually?



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 27, 2014 at 08:44 AM

    HI Anima,

    its running through PC?

    some times mange will show red, in monitor level show green means some data packets data missing.

    it will happen some times some data packets will get all data and some data packets not get all data

    delete the red request from DSO again run the DTP. set data package is 20,000 then it will load without error.



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2014 at 08:21 AM

    Hi Anima,

    Probably when you rerun the DTP, you will not get any error. If the problem still exists during the run of scheduled process chain, then you may try changing the start time of the process chain or change the package size of the DTP. Generally, these kinds of problems occur memory related.

    Hope it gives an idea



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 27, 2014 at 09:08 AM


    Full loads better to load where there is no burden on bw server.

    When there is no error message then nothing to worry much. As my guess due to your server's busy schedule on particular day, its unable to process your request.

    Exactly to know about that, next time you can trigger your when there is less burden only our bw server.

    before triggering your process chain, check SM50 to know available free application servers to process your reqyest.


    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.