Thursday, January 18, 2007

SAP BW: BEx Connectivity Issue

In today’s off shored world we connect SAP systems which are hidden beyond several network’s firewalls. When some project starts normally basis people are investigating if connection to SAP GUI via standard DIALOG protocol is working. In case we need to connect SAP BW server there is a reporting tool called BEx which needs to be connected to BW backend for creation/testing reports.

If we do not pay enough attention developers get following error while trying connection to BW via BEx.

Error Group

RFC_ERROR_COMMUNICATION

Message

Connect from SAP gateway to RFC server failed

Connect_PM GWHOST=148.100.100.1, GWSERV=sapgw02, ASHOST=148.100.100.1,

SYSNR=02

LOCATION SAP-Gateway on host sapbw1 / sapgw02

ERROR connection to host sapbw1.mycompany.com, service sapgw02

timed out

TIME Fri Jun 4 09:22:47 2006

RELEASE 620

COMPONENT NI (network interface)

VERSION 36

RC -12

MODULE nixxi.c

LINE 812

DETAIL NiPConnect

COUNTER 2

This problem can be resolved by implementing of SAP note no. 447882 (you need SAP OSS account to access this site). Basically you need to adjust firewall settings. Firewall must be able to accept listening on port 33xx (where xx corresponds to your SAP BW system number).

2 comments:

  1. Open Port 33XX where xx = sap sysnr and port 49168 and 59270 if your sap server behind firewall.

    ReplyDelete
  2. Hi Tjandra,

    thanks for your comment. Can you elaborate some more details about purpose of the ports 49168 and 59270? What function are using those?

    Thanks!

    ReplyDelete