Question:
Hi Bw Experts,
I am new in BW area.
I want to upload transaction data to the info cube HHR_PAOS_1 in my BW test client from SAP R/3. When I monitor the upload process it seems that data records are truely collected. But when the process finishes the system fails to upload the data from PSA to the info cube and the yellow light remains the same..When I manually try to upload data from PSA it also fails....
When I TRY directly updating the data target with data packages, it also fails, although BW system collects data from R/3.
I could not understand why this happens. The problem does not exist in the BW development system.
Please advise me.
Kind regards,
Taner Yuksel
4 years SAP SD, CS consultant with ABAP skills....
taner_yuksel@yahoo.com
Answer:
whats the error you get
Answer:
1. your update rules ( UR) . there are possibly abap rutines in update rules
that work in dev but dont in prod (enter endless loop for example ).
check it. you can set temporaly those UR to initial or no update (preferrably one by one ) and load each time and than see what UR made troubles.
2. before you do that you should check in your infopackage the next:
in MAIN menu ,SCHEDULER (up left corner of screen),enter datasoutse
transferr setiings . there you have "maximum packet size in KB"
by defoult its set to 20000 i think.
change it to something smaller 3000 for example . then run the load
again and see if this was helpfull.
if it was the synmpthom you expiriensed just big volume of data in
single load packet. it is understanderble if in dev you have considerably
fewer data than in prod.
regards.
Uri.