data mart red-yellow-green

[Former Member]

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

[former_member188975 · Accepted solution]

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...

[Former Member]

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.

[Former Member]

Are you receiving some dump in ST22 ?

[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