Hi Ravi,
In a situation like this you've got to find out which is the reason causing RFC fails. A good start point would be analyzing the dumps and related system logs using transactions ST22 and SM21, first in BW system and afterwards, if applies, in R/3 system.
Hope it helps,
Andreu
Add a comment