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

Error in the data loading

Hi All

One infopackage is loading data to two ODS. It is taking long time and failed with short dump. But if we goto st22 it is not displaying any short dump. I have deleted the red requests from both the data targets and scheduled the infopackage. it is giving the same error.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 10:20 AM

    Have you see if the dump is in the sourcesytem?

    Can you specified the error you received?

    Mario

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 10:24 AM

    Hi,

    Can u provide me with some more info? is it from some source system or is it from Data mart? Do u have PSA? Wat abt the no records being transferred/updated in targets before failure?

    If its in source system you have to check th job log in source system (REQ) or ST22 to find the reasons for failure.

    Thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      The normal procedure to correct this error will first to identify if you have the data in PSA between ODS and cube. In that if you have all the data in PSA u can update it to target.

      In ur case as u dont have a PSA you may have to force the request to red and delete it from target Cube then go to source ODS find the data mart (Tick mark) Confirm by making that the request that you deleted from Cube is the same as that you are going to reset datamart status in ODS (when you click on the tick mark in ODS a pop up will come asking if you want to reset datamart..there scroll to right it will show the request name in target).If its same delete the datamart status and then Trigger the infopackage again. But better to pull it to PSA only or to both PSA and target so that in case it fails again you can pull it from PSA.

      If you had pulled it before resetting data mart and the request is successful but without data then u may have lost delta and may need to do a full repair.

      this should solve your issue,

      JituK

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 02:04 PM

    HI,

    You can try loading the data into only psa first. There you will be able to find out wether some error is occuring while data loading into psa. Then you can check psa maintainence and rectify if there is some error in data format. If this help please assign points.

    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.