cancel
Showing results for 
Search instead for 
Did you mean: 

HCI DS - ECC Datastore not able to import tables

former_member423067
Active Participant
0 Kudos
3,008

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Participant
0 Kudos

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

Answers (1)

Answers (1)

former_member414511
Discoverer
0 Kudos

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

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
Discoverer
0 Kudos

Hi Vijayaraja,

Thanks for your help, I will follow this steps.

Ralph