Skip to Content

BW Request remains in yellow when 0 records found in the source

Hi,

I'm having an issue with DataServices when loading data from a table (or file) and 0 records are found in the source.

The InfoPackage never gets notified about this and remains in yellow until it fails because of timeout.

Same thing happens when the job in dataservices fails.

Has anyone had the same issue?

I've managed to manually fix this by calling BAPI_ISOURCE_TD_T_SEND and set the load to error / finish, but i would expect DataServices to handle this.

Any input will be appreciated.

Thanks,

Cheers,

Diego

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2010 at 08:41 AM

    Hello Diego,

    There must be a note for this because if my job returns zero records my job completes successfully. I'm at BI 7.01 sp5 and don't experience this behaviour.

    Cheers,

    Kevin.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 01, 2010 at 05:00 PM

    Diego,

    I have faced the same issue in my environment ( SAP BW 7.01 SP5 , DS 3.2 ). Issue is with locale settings of SAP BW in designer. Go to designer and select your target BW data store in edit mode. Click on Advanced tab, you see Code Page under locale is default and change to us-ascii.

    Please let me know the results.

    Thanks,

    Barani

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 01, 2010 at 06:35 PM

    Hello Diego,

    This issue is with respect to settings in the process monitor setting.

    Go to process monitor and click on setting from the menu list.

    Then select "Evaluation of requests" and select "status: successful" under "If no data is available in the system, the request ".

    By doing this setting data load will be successful even if there are 0 from 0 records.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 04, 2010 at 12:40 PM

    Hi Diego

    I'm facing the same problem. Where you able to find a solution?

    Thanks and Regards

    João Felipe Neri

    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.