topic Re: Problem happen SAP connectgion in QlikView

Problem happen SAP connectgion

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

Hi All,

I have a problem after QV server ver up and SAP connector ver up.

QlikViewServer_x64Setup.exe(2017/11/07)

QlikSAP_x64Setup.exe(2017/11/22)

both file download from QV support site.

However. all QVD file cannot reload it. what happen!! if you will have a same ERROR about me. please let me know a solution.

I want to recover before ver up ASAP.

Re: Problem happen SAP connectgion

Anonymous — Tue, 19 Dec 2017 08:03:22 GMT

in Addition, I have to re-install old SAP connector?? after that, my problem will be gone.

Re: Problem happen SAP connectgion

trm — Tue, 19 Dec 2017 09:16:20 GMT

Hi Kei,

It looks like you upgraded your SAP Connectors from a much earlier version. Since that we have replaced the connector you are using, it's not a dll anymore but rather an exe file. That's why you get the error message:

"Connector connect error: Invalid custom connector QvSAPConnector.dll"

The best way forward would be to create a new connection using the QvSAPSqlConnector.exe, after that you can compare your old connection string to the new one and it will be obvious what you need to update to get your old scripts running. Also for getting datatype compatibility with the older version of SAP SQL Connector you need to tweak a few connection string properties like: MixedMode, NulldateLegacy, FLTPLegacy, TIMSLegacy

See the following help page for more information on the connection string properties:

Using the SAP SQL Connector ‒ Qlik Connectors

Regards,

// Thomas Örnmarker

SAP Connectors developer

Re: Problem happen SAP connectgion

anandsai4u — Tue, 19 Dec 2017 09:42:20 GMT

Hi Kei,

What type of connector are you using i.e., QvSAPExtractor or SAPSql Connector etc.,

Regards

Anand Sai

Re: Problem happen SAP connectgion

Anonymous — Tue, 19 Dec 2017 11:25:37 GMT

Hi Thomas-san,

Thank you very mush your help.

I used "QvBAPI connecter" at old SAP connecter.

righ now I use "QVSql connecter" but, i cannot connect SAP. if you can advice me, it higly appriciate.

Our SAP

Client=100

Instance=00

System ID=EP1

Or how do you think about SAPConnecter downgrade?? it may solved?

Re: Problem happen SAP connectgion

Anonymous — Wed, 20 Dec 2017 03:23:03 GMT

I used "QvSAPConnector.dll". before QV server and SAP Connecter upgrade. it works normally. however, after QV server and SAP Connecter upgrade, it cannot work normally. all QVW cannot get from the SAP.

and I tryed used "SAPSqlconnecter.exe" but, I cannot connect with SAP.

Re: Problem happen SAP connectgion

Tomas_Sommergyll — Wed, 20 Dec 2017 10:02:06 GMT

Hi Kei,

The error in the Test Connection dialog that has the text: "ERROR service '?' unknown" means that it needs an updated services-file. This file can be located in the folder: "C:\Windows\System32\drivers\etc". It needs added entries to be able to connect, depending on the Gateway. Typical entries is:

sapgw04 3304/tcp

sapgw05 3305/tcp

sapgw06 3306/tcp # 3306

For Message Server:

Add sapmsxxx 36nn/tcp, where xxx is the system ID and nn is the system number. E.g:

sapmsE6T 3607/tcp # 3607

Please see:

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.6/Configuration/Connector-configuration.…

Also, I noticed the other error: "EP1 is not a valid system number". I believe this has to be an actual number depending on your SAP system, e.g. 00 etc.

Br,

Tomas

Re: Problem happen SAP connectgion

anandsai4u — Wed, 20 Dec 2017 10:10:30 GMT

Hi Kei,

Can you update your SAP related entries in hosts and services file in the mentioned path accordingly.

C:\Windows\System32\drivers\etc\services

C:\Windows\System32\drivers\etc\hosts

Regards

Anand Sai

Re: Problem happen SAP connectgion

trm — Wed, 20 Dec 2017 15:30:59 GMT

Hi Kei,

As Tomas described you need to enter a valid system number in two digit format.

You should not need a downgrade, there's a lot to benefit from keeping the newer version. As of the system number you can find it in your old connection strings.

// Thomas Örnmarker

Re: Problem happen SAP connectgion

Anonymous — Thu, 21 Dec 2017 04:57:34 GMT

Hi colleagues,

Thanks a lot for the advice, but unfortunately, I cannot connect with SAP still now.

1. I install SAPGUI on BI server. I expect that, gateway port information will be created on BI server automatically. Am I correct?

Re: Problem happen SAP connectgion

Anonymous — Thu, 21 Dec 2017 09:13:58 GMT

Hi Again,

Righ now, I tried diffrent approach...

1.SAPSQLconnecter.exe licence activation. I create new QVD. it was successful.

2.I tried test conenction. but error appear.

I may install something to SAP side??

Re: Problem happen SAP connectgion

trm — Tue, 02 Jan 2018 12:36:34 GMT

Hi Kei,

Looks like you need to upgrade transports on SAP side. The needed transports are included when installing the SAP Connectors, bur requires some SAP Basis knowledge to import into the SAP system. From your screenshot it looks like v6.0 is installed on SAP side and such old version is now allowed when running the SAP SQL Connector.

Regards,

// Thomas Örnmarker

SAP Connectors Developer