TCPIP RFC connection test failed between SAP Data Services & SAP BW

[Former Member]

Hi all,

we are trying to connect SAP Data Service to SAP BW (via TCP/IP RFC connection).

Below are the versions of system that we have:

SAP BW: 7.30

SAP Data Services: 4.2

I have tried the steps (provided by the SAP Data Services gurus) on the connection part.

however, i have failed on the connection test in SAP BW.

Below are the error message that i've got from the connection test:

Logon	Connection Error
Error Details	Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=67
Error Details	ERROR: program DS_BW_POC not registered
Error Details	LOCATION: SAP-Gateway on host mgs6db1.internal.mgc.com.au / sapgw00
Error Details	DETAIL: TP DS_BW_POC not registered
Error Details	COMPONENT: SAP-Gateway
Error Details	COUNTER: 4719
Error Details	MODULE: gwr3cpic.c
Error Details	LINE: 1908
Error Details	RETURN CODE: 679
Error Details	SUBRC: 0
Error Details	RELEASE: 721
Error Details	TIME: Fri Jan 10 15:52:22 2014
Error Details	VERSION: 2

it seems like i have missed a step in registering the program ID in SAP data services server.

do you know what's the steps required to register a program ID in SAP Data Services?

thanks in advance.

regards,

will

[Former Member · Accepted solution]

Hi All,

i have managed to fix the issue with the RFC connection (SAP Data Services & SAP BW).

all i did was to ensure that in the SAP Data Services VM Server, the "service" file has the "SAPGW00" registered as a gateway.

regards,

will

[former_member185239]

Hi Willie,

When you have created the RFC on DS side it will get started automatically.

Check the error at DS side and try to start the RFC on DS side.

also telnet the hostname with the port

telnet mgs6db1.internal.mgc.com.au 3300

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Willie

Is the RFC Connection Started in the BO DS End ?  Can you login to the DS Admin console and check if the connection test is working ..

See the following links

Thanks

Rishi

[Former Member]

Hi Rishi,

No, the RFC connection that was created at the DS Admin console does not even started. it was stopped and showing red colour in it status.

regards,

willie

[Former Member]

Hi Willie

The connection test from the DS side needs to be working . Then the RFC connection from BW will work.

What is the error message you get when you try to test the connection.  Also can you check the parameters maintained for the same in the DS side.

Thanks

Rishi

[Former Member]

Hi,

Please check the below note..

353597 - Registering RFC server programs

When did the issue start or this is the first time you are configuring it.

Thanks

Rishi Abrol

[Former Member]

Hi Rishi,

This is the first time i am configuring it.

i have tried to log into the Server and register the program ID, but somehow it wasnt able to find the command "rfcexec".

Could you please advise me on where can i find the command "rfcexec" in the server?

or am i using the wrong command here?

regards,

will

[karthikeyan_natarajan4]

Hi Willie,

Check in \usr\sap\<SID>\sys\exe\run

regards

kartik

[Former Member]

Have you checked the below note.

The 720 versions of the kernel do not contain the program rfcexec (UNIX and IBM i) or rfcexec.exe (Windows) any longer. As this might break some application scenarios, by following the steps described above for UNIX or Windows, the old versions of these programs are kept (for IBM i these steps are ignored). For various reasons, it is highly recommended - and for IBM i it is mandatory - to move to a new version of these files, contained in the NW RFC SDK 720. Please refer to SAP Notes 1581595 and 1025361for detailed instructions and further information.

http://wiki.scn.sap.com/wiki/display/ABAPConn/Download+and+Installation+of+NW+RFC+SDK

Thanks

Rishi Abrol

[Former Member]

Hi Rishi,

so do i need to download this NW RFC SDK 720 into BOBJ Data Services VM? and install it?

that doesnt sounds right.

please advise, thanks.

regards,

willie

[Former Member]

Hi,

No you need this in the BW system.

Can you please go in kernel directory and see if you have nwrfcsdk folder and all the env set . This directory will have the rfcexec file .

Thanks

Rishi Abrol

[Former Member]

Hi,

Please also check the below blog.

Can you also check that if firewalland antivirus is active on the BOBJ box . If active deactivate then and than try the same.

Thanks

Rishi Abrol