Discussion board for collaboration related to QlikView Connectors.
I have a problem after QV server ver up and SAP connector ver up.
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.
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:
// Thomas Örnmarker
SAP Connectors developer
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.
Or how do you think about SAPConnecter downgrade?? it may solved?
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.
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:
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
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.
Can you update your SAP related entries in hosts and services file in the mentioned path accordingly.
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
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?