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

ODS Update Failure

Tried to update ODS through Delta extraction, when I went to monitor, first it was showing as yellow "Processing/warning". So I left it there and checked again this morning. Light is RED and no records updated. Can anyone help?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2005 at 01:49 PM

    Hi,

    Let us know the further inforamtion by using Tcodes ST22,Sm21 in source system.And aslo check the PSA for wrong data

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Fran,

      To check the data load job, you would have to go to SM37 in your source system. The job name starts with BI_REQU* where REQU is the name of your request. You can get this from the data load monitor.

      Sometimes the system itself cancels the job like for memory issues. It is not necessary that some person cancelled it. The job log will be able to tell you.

      Hope this helps...

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2005 at 02:42 PM

    Fran,

    May be no one cancelled the job, it turns RED if it cannot process in some specified time. There could be many reasons. Give more details of error or messages in monitor. The reason could be anywhere from connection b/w the systems to simple bad data. I am not sure if this is the only load you are doing, but do check the RFC connections. More information will let others understand better and respond.

    Gokul

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Fran,

      Are you sure you are not able to see any dump?

      Because dump mesg can give you better idea to solve your problem.

      And you cannt manually activate your request unless your load is successfull.

      Try deleting that request and upload again and check if you get same error again.

      Rohini

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2005 at 04:29 AM

    HI,

    Any time if u got message like Sending packages from OLTP to BW leads to error... u have to wait for the job to finish first.. It comes when there is some Communication problem with the source system. So wait upto the load to finish..

    Hope it helps..

    Regards-

    MM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2005 at 02:48 PM

    the time it takes depends on the number of records and many other factors such as system load. how long was the default time set for loading. why did you have to change the QM status manually, that might effect your delta.

    As you mentioned it is a delta load, it should not take much time, unless there are unexpected number of records.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I'm not trying to change the QM status status manually. it is set to change automatically. But its taking too long. As far as I know only two new records were created. Just cant figure out why its taking so long. Also, while the light is yellow, it still shows (0 from 0 records updated)

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.