Question:
Hi Guys,
I have create a generic datasource, I used RSA3 to test in R/3 side it get only 1200 records, but when I use this datasource to load data from BW side, it now create over 1 million records already and is still running, looks like it get into a endless loop,but the monitor screen did not show any error, anybody has this kind of experience? how to fix this problem and cancell a request which is not finish?
Thanks in advance.
Answer:
annie,
check the no. of records on source system first using se16 on your view/table.
what you see in rsa3 is a sub set. restricted by the parameter data records/calls in your rsa3 transaction
Answer:
Looks lile u have an update routine or start routine code which is taking the entire load into an infinite loop. To kill this process go to sm50 select the process which is still running and forcefully kill it. Or u may go to sm37 and kill the job. Either way it works. We encountered the same problem here in our system and I just debugged my start routine and found that I forgot to refresh the data package and write the End loop statement in that routine. Now it is working fine.
_________________
Raj
Have a Nice Day:-)
Answer:
Hi Raj
I do not have any update routine ,transfer routine or start routine, it a straight map, also this job is not dispay from Tcode sm37, however it display in Tcode sm50, but after I cancell in sm50, it still running when I get into SM50m again. Where is the endless loop trigger from?
Answer:
annie
it may not be an endless loop.
Please check the number of records you are trying to extract....
what does your monitor say as far as number of records processed and number of data packages received?
Answer:
Every package is the same number of record, in the r/3 side only about thousand record need to be extract, but at the BW side, the monitor show over 2 million record already be extracted and is still running.
Answer:
if you are extracting from a view/table (and not using any selection condition) - please got to r/3
use tcode se16
put in your view/table and hit enter
then hit the button number of entries
can you tell me what that number is ???
Answer:
There is no view for this extractor it's a function module, wheh use RSA3 to test the extractor, it show total of 1254 records was extracted.
BTW, I have successfully cancel it, the trick is it should be cancell at th R/3 side through SM59. I am pretty sure there is a endless loop involved.but did not know how it happen and how to fix it.
Answer:
ok then your issue is in r/3
Please check your function module.
run rsa3 but now in data records / call put value 200.
you will get more than 1254 records ...
then change it to 300
bottom line is you funtion module is returning back more records than you expect.
one of two things is the problem here
1. there is a problem with the function module
2. (assuming the FM is correct) there are more than 2 million records to be extracted.