HCI DS - ECC Datastore not able to import tables

[former_member423067]

Hi Experts,

I have created a SAP ECC Data store in HCI DS. Test Connection works fine, but when i try import tables, I'm getting below error.

Did anyone face the same error? we are connecting for the first time, is this RFC User Authorization related.

Cannot retrieve children nodes - browse remote error: SAP error dynamically importing SAP table: <Error creating RFC function <RFC_ABAP_INSTALL_AND_RUN>: <RFC_INVALID_PARAMETER- Invalid parameter 'RFC_CONNECTION_HANDLE' was passed to the API call>. Notify Customer Support.>.

Cannot retrieve table metadata - Table does not exist: Get metadata object errors: SAP error dynamically importing SAP table: <Error creating RFC function <RFC_ABAP_INSTALL_AND_RUN>: <RFC_INVALID_PARAMETER- Invalid parameter 'RFC_CONNECTION_HANDLE' was passed to the API call>. Notify Customer Support.>.

Thank You,

Nazeer

[former_member596468]

Hi,

I am getting issue while connecting HCI dS to ECC :

Please help.

using host <10>, client <400>, user , and system number <04>. Please make sure the SAP server is running and the login information is correct." id="__alert23--msg" style="direction: inherit;">Test failed for the default configuration ‘default’ of datastore: ‘KP’:
Cannot connect to SAP Applications datastore <> using host <12.350.2.311>, client <400>, user <STEP>, and system number <04: CRFC error: RFC_COMMUNICATION_FAILURE-
LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR partner ‘12.350.2.311:3304’ not reached
TIME Mon Nov 26 18:24:38 2018
RELEASE 721
COMPONENT NI (network interface)
VERSION 40
RC -10
MODULE nixxi.cpp
LINE 3283
DETAIL NiPConnect2: ‘12.350.2.311:3304
SYSTEM CALL connect
ERRNO 10060
ERRNO TEXT WSAETIMEDOUT: Connection timed out
COUNTER 34
[SAP Partner]>. Please make sure the SAP server is running and the login information is correct.

Regards

[Former Member · Accepted solution]

This seems to be authorization related . Please check below documentation link to make sure the user you use to connect to ECC has the required authorizations :

https://help.sap.com/viewer/7d9858e1309e459093ed397c6fc40f12/latest/en-US/e11999ba833e4d88afcf0b2820...

Also keep in mind that in order to import tables, the system you connect to needs to be open (so a dev/test system), on a closed production system you will not be able to import new tables.

Thanks,

Ben.

[former_member423067 · Accepted solution]

Thank You Ben.

This was an Authorization issue.

SAP OSS Note : 1891274 - How to set SAP user authorizations for Data Services 4.1 and 4.2 and Hana Cloud Integration

Above note has the important roles needed for HCI RFC user. This was used as reference by our security team to fix the issue. Some of the admin roles are not mandatory. This should help to fix Auth related issues.

with regards,

Nazeer

[former_member414511]

Hi Ben,

I have a question, would be great if you can give me your opinion.

So I have DEV that is an open system and I can import the tables that I need.

How it works when I need to turn it to Production system, do I have to open Production System and Import the tables and then close the system again? Or is there any other way to do this?

Thanks,
Ralph

[former_member361253]

Hi Ralph,

You need import the tables in the dev system to your sandbox HCI. when you promote the job in HCI from sandbox to Production it automatically carries over the tables in the datastore. We do not have to re-import or open the production system.

Thanks!!

[former_member414511]

Hi Vijayaraja,

Thanks for your help, I will follow this steps.

Ralph