Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

RfcCommunicationException using SAP Sql Connector

Hi experts,

i'm tring to use SAP Sql connector.

We setup all connection parameters and the connection succeeded:

2018-10-12 14_36_03-_SD-00-Extraction _ Editor caricamento dati - Qlik Sense.png

But if i try to extract a table qlik sense returns the following error:

2018-10-12 14_36_38-_SD-00-Extraction _ Editor caricamento dati - Qlik Sense.png

All rights/roles are correctly associated to the user.

Any suggestion ?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II
Author

The error was on the "Host" name.

By writhing only machine name "ssvsa112" without the domain it works!

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
Hakan_Ronningberg

Hi again Michele,

There are a few things to check with firewall and 'SAP services file'. Have a look in this document:

Qlik Connector for SAP - Tips and Tricks v1.8

Regards,

Hakan

micheledenardi
Specialist II
Specialist II
Author

Hi Hakan,

i've checked the document but we have no firewalls on both side (qlik - SAP).

I'm connectiong to an "Application Server" so a change into "SAP service file" (C:\WINDOWS\system32\drivers\etc\services) is not needed in this case.

Anyway i have tried to add a new row (sapmsTST  3600/tcs) on that file but nothing has changed.

2018-10-12 17_46_15-mRemoteNG - confCons.xml - QlikSense TST.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
micheledenardi
Specialist II
Specialist II
Author

The error was on the "Host" name.

By writhing only machine name "ssvsa112" without the domain it works!

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.