Hi
I am trying to connect create datastore of type SAP application . ERP is SAP ECC 6.0 hosted on linux x86_84(Application server) and DB is HANA on linux
I am able to successfully create a datastore and read a table using a normal dataflow from my BODS server ( machine where Job server is installed)
This machine is a windows server 2008 64 bit OS
However, I am not able to connect to datastore from my local machine ( windows 7 32 bit) .
Am I missing some client components. I have SAP logon in my local PC through which I can connect to this SAP ERP.
I am able to connect from my local machine to another ERP hosted on windows and DB as SQL server . I am able to connect to SQL Server 2008 and SQL server 2012 and also oracle from my local PC .
Please see the error text below
Cannot connect to SAP Applications datastore < XX> using host , client <200>, user ,
and system number <00: CRFC error: RFC_COMMUNICATION_FAILURE-
LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR connection to partner ‘sao sever name:3300’ broken
TIME Thu Feb 06 15:03:39 2014
RELEASE 720
COMPONENT NI (network interface)
VERSION 40
RC -6
MODULE gwxx.c
LINE 646
DETAIL NiIRead: P=SAP SERVER IP:3300; L=Local PC IP::53771
SYSTEM CALL GwRead
COUNTER 5
[SAP Partner]>. Make sure the SAP server is running and the login information is correct.
UPDATE
This has been rectified by adding the IP address range in the allowed list of IP Addresses in gateway access control file
Can you ping that SAP Host from your local machine and see what happens?
Can you create the Datastore from a server machine and open that created datastore in the same repository from your local machine and simply re-apply and say OK and see what happens?
I have couple of my users in 32-bit Windows 7 and they never had this issue against ECC. We run DS 4.1. The message is simply a communication failure to the ECC system and you say that you are also able to connect to ECC to the system.
I can see a size difference in size of the dll which is used for connecting to SAP
sapnwrfc.dll .
The one on my 32 bit machine is 4264 KB
The one on my 64 bit machine is 4887 KB
Both has modified date of 7/9/2011 slightly different time
Can you give the connection information and do a direct connect? Because, I think the information in sapnwrfc.dll will override what will exist in the Datastore Config…I need to confirm this. Can you try that way of not using this file?
I tried copying the one from server to to my local PC bin directory but I get an error sapnwrfc.dll is missing.
I didnt quite understand what you asked. I thought sapnwrfc.dll is the equivalent of ODBC drivers for connecting a SAP application ie you need client drivers(native or odbc) to connect to database and similarly application needs a client component and in this case its sapnwrfc.dll
Correct me if I am wrong
I can connect to ERP via the netweaver client from my local PC
Don’t use the sapnwrfc. There is almost never a reason for using that.
In order of likelyhood:
You filled in incorrect connection details
You cannot reach the host name. Try the ip-address
SAP refuses the connection. Check ST01. Unlikely though, but could be an authorization issue.
I can ping and even telnet the server on the particular port . Connection details I havent changed anything because I am able to successfully connect from my server ( job server machine) and for testing I tried to open the same datastore from my local PC designer and i get the error (see my original post)
I havent checked ST01 though which I have to get support from by basis team.
For databases dataservices use ODBC or native client, whats the similar component while connecting to SAP application
Can somebody explain whats the underlying events while a datastore is created ie is it a 2 way communication or is it just a one way communication?
Whats the client component used during this step ? I am wondering if that component is corrupted in my machine. And also my ECC underlying DB is HANA and I am hoping it shouldnt make any difference because for data service db is abstracted by the application.
A clean install with BODS 4.x does not require an install of for example the SAP GUI to connect to SAP. BODS can handle the SAP connections out of the box.
Hm
Interesting because I can connect to another SAP ERP(IDES) from the same client and so it must be some security setting in SAP which is blocking connection from my machine and as usual BASIS team is very supportive ( ) not ready to see anything from their end.
I have already tried 1&3 . 1&3 fails with the same error
2 I am able to connect only to IDES system ( based on windows and SQL server) and all other systems ( sandpit and dev clients) which have similar config (Linux and HANA) fails.
Do you foresee any issue due to 32 bit client . Is there any place where i can see the RFC trace ?
This has been rectified by adding the IP address range in the allowed list of IP Addresses in gateway access control file by BASIS security team
This was already maintained but the syntax was wrong ie for allowing all users of desktop 10.* was maintained but 10...* should have been the correct entry
(BOB member since 2008-07-17)
(BOB member since 2012-03-20)
) not ready to see anything from their end.