Question:
Hi Guys,
I have a Cube X with 2002,2003 and 2004 data.
I built a Cube Y and wanted to load only 2002 data into Y from X.
I have generated Export Data source.
Transfer rules and Update rules are fine and ACTIVE.
Everything worked in DEV and QA.
When I'm trying to load data in Production, its taking all the time in the World.The request has been running for the past 4 days.Nothings happening.
I thought its problem with Space and so I tried to load data with small data ( 30 records). It didnt work.
I tried to load data from a Flatfile into Y.It worked.
But when I try to load it from the Cube X, it is NOT working.
Can anyone please suggest me anything?
Answer:
I think you are having problem in loading data from cube to cube,Did you noticed any dump and also system log.
It will be great if you give us an update about your production environment and also error msg if any.
Good luck,
scy
Answer:
No Error Message.No Short Dump.
We set the Timeout Time to 2 hours.So After 2 Hours the Light goes RED.But the status it says " Request Still Running".
SAP BW release 310 and SP Level 19
PI_BASIS 2003_1_620 SP Leve; 7
Answer:
Hello,
I would suggest the following checks:
*Check ST22, sometimes you get a dump (typically with tablespace problems) there, but not in the Scheduler.
*Make sure u use a PSA, as you might be able to get some additional info
*Could be a problem with the update rules, in which case you should debug your program (however unlikely, as it's working on other systems).
*Check SM50, in order to see if the load process is really working
Is any data being processed at all? What are the kind of record quantities we are talking about here?
Answer:
TBR,
Checked ST22, no short Dumps.
I used Only PSA -- Update subsequently in data Targets
No problem with the Update Rules
SM50, a process is running under my name regarding the Data load.
No records are being loaded. 0 from 0 records.
Actually there are millions of records.But I tried to load some 30 records just to test when my first data load failed.
I'm trying to load in very small sets of data.
Answer:
What does sm21 say?
In sm50, do you see any sequential reads? Any inserts? I mean progressively increasing # of records? (not the time )
_________________
Keep smiling
Answer:
Hi
As apart of Sanity check...
Did data get loaded in PSA?? or load gets stuck even while loading PSA??
Which type of load did u execute
INIT +Delta or Full load??
Hope it Helps
_________________
Chetan
@ CP...
Answer:
Data Load got stuck even before coming to PSA.
No Data in the PSA.
I'm doing a Full Load.