Problem happen SAP connectgion

[Anonymous]

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.

[Anonymous]

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

[trm]

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

[anandsai4u]

Hi Kei,

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

Regards

Anand Sai

[Anonymous]

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?

[Anonymous]

HI

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.

[Tomas_Sommergyll]

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/Conn...

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

[anandsai4u]

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

[trm]

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

[Anonymous]

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?