Question:
Mate,
I have a question if u can help me with. My ODS datamart loading to three other infocube has not updated the infocube from yesterday. It happened after I initialised a load to QA from this ODS (Prod) for other reasons. I deleted all QA connections and delted the init request off the table ROOSPRMSC.
Should I reconstruct the ODS request. ODS request is OK now, But the datamart update is not ok. When I run the Datamart update from ODS to infocube, It give an error "problem at the source system". (Probably due to my init - and I have replicated / activated and did all of that sort).
Do I need to reconstruct the ODS again (Request are OK)
Should I take care of any other control table whcih has QA init in prod.
Need help asap as its prod
I am confused....Can u help me ??
Thanks & Rgds
Danny25
Answer:
It give an error "problem at the source system".
I'm sure it gives a bit more info than just these 5 words? Please post the entire message (and check OSS on the message number first).
El Belgio
Answer:
Sounds like you screwed up trying to hack the system.
Remove the ODS data from the cube then do a new init load form the ODS to cube.
Answer:
Hi danny25,
I need to delete some records of the table ROOSPRMSC of the R/3 source system.
I read bellow that you have do it. Please can you explain how, this table is not available for maintenance, and so it is impossible to do with SM30.
Thanks for your help.
Quentin