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

How to Handle Errors in Loading

Hi,

I have a situation where in we are loading Sales Data for the Year. The loading is going fine, full of green light per data package. Until a yellow one comes along and was skipped since successive packets turns green again.

Question is how could I reprocess this yellow data packages to retry and reload? The only option when you right click is "HELP FOR NODE".

--Jkyle

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 Feb 14, 2005 at 09:07 AM

    Hi Jkyle,

    There are 2 possibilties

    Reload the request from the PSA back to the cube OR

    You could go to the Monitor of the load and make the request red. Then go to Details -> Processing (right click) and select the manual update.

    Hope this works.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 14, 2005 at 09:21 AM

    This depends a bit on the error. If this is a delta package you could request a repeat from your source system. If it was a full upload you could schedule it again. If the data is completely in the PSA you can delete the request from the cube, fix the error (either in PSA or your update/transfer rules) and reconstruct the cube. Sometimes you'll find a button under the status in your monitor that says Manually post the package (or similar).

    What error did you get?

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2005 at 09:01 AM

    Hi Jkyle,

    Since the issue is table space issue and you are not using PSA. You can deactivate the aggregates for some of the cubes which would provide you extra tablespace. After the cube is loaded you can then activate them.

    Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2005 at 09:15 AM

    Hi Jkyle,

    Another possibility is to split the data by giving the data selection in the infopackage, say 4 infopackages for 3 months for that year like Jan-Mar, Apr-June and so on..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Jkyle,

      if you have an existing init, you can perform full loads (but only if you are using a cube as destination provider, not an ODS; in this latter case you have to perform your full from another source than the init one) and no problem for your delta queue....you can execute several loading in parallel (and you can easily use the same infopackage or you can create different ones with no problem), but you have to be sure that no system bottleneck will be caused...

      Bye,

      Roberto

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.