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

data mart red-yellow-green

Hello all,

I have some trouble with my data mart. It has worked ok before, but not anymore.

Even though I see a request in the source cube (and thereby should be availale for delta load into the target cube), it doesn't work to load it! The load gets stuck in yellow... No records are selected in monitor...

However, when I then delete the data mart status from the last loaded (into the target cube) request (green) and execute the load again, it works... But when I then want to load it again, it once again gets stuck in yellow and I have to delete the data mart status of the last load again...

Has anyone seen this problem before? What can I do to solve it?

Best regards,

Fredrik

Message was edited by: Fredrik Carlsson

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    Posted on Aug 01, 2006 at 02:35 PM

    Hi Fredrik,

    As you are loading from a cube to another cube, try to regenerate the FactViews: SE38 : SAP_FACTVIEWS_RECREATE. Then try the load again.

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

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

    Are you receiving some dump in ST22 ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi guys and thanks for helping!

      - I have now run SAP_FACTVIEWS_RECREATE.

      - There are some dumps in ST22 with the names "DBIF_REPO_SQL_ERROR" & "SYSTEM_CORE_DUMPED". However, the core dumps are forced by me via SM50 when I aborted the loads (because it was stuck in yellow)...

      - I can imagine that this is database resource related and will check the notes out..

      Thanks!!!

      Best regards,

      Fredrik

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

    Hi Fredrick,

    I think you have a problem of resources readind the view for E anf F fact table.

    Take a look at notes: 862809 - 561961.

    Ciao.

    Riccardo.

    Add comment
    10|10000 characters needed characters exceeded