To homepage To homepage
Solved

Qlik Sense Enterprise endpoint cannot create/modify a Data Connection

  • 16 February 2023
  • 9 replies
  • 247 views
rory.smith
Rank
Userlevel 5
Badge +7

TX: 20.10.39

SQL Server: 2019

Endpoint settings:

  • Windows authentication
  • hostname matching case
  • https connection over the default proxy

 

I am trying to push a Qlik Sense Enterprise endpoint from TimeXtender and having trouble getting the deploy successfully running. Testing connection to Qlik Sense is successful, when I Deploy I get an error when TX tries to create a new Data Connection.

 

I see this issue pop up sometimes in other deployments and can usually overcome by manually making a Data Connection to the MDW database and giving it the same name TX would use: MDW_SLQV . In this case, I get the same error when TX tries to modify the connection.

TimeXtender does create the app (and is owner of it) and can successfully reload the app, it just doesn't insert the script. If I copy-paste the TX Qlik Script into the app it works fine. As neither TX nor Qlik actually log what is going on, I cannot see what about the connection string is causing the error.

icon

Best answer by Christian Hauggaard 24 February 2023, 11:17

View original

9 replies

Christian Hauggaard
Rank
Userlevel 6
Badge +5

@rory.smith can you please try installing this provider on the Qlik server?

rory.smith
Rank
Userlevel 5
Badge +7

OK, I am not sure if this was not already done - will need to get permission to do that.

rory.smith
Rank
Userlevel 5
Badge +7

Hi @Christian Hauggaard ,

 

just to let you know: the 19.3 version of the provider requires the 2022 C++ Redistributable for Visual Studio, but has problems with actually detecting this is installed. See also the comments: https://techcommunity.microsoft.com/t5/sql-server-blog/ole-db-driver-19-3-for-sql-server-released/ba-p/3742786

We installed 19.2 to avoid this error and successfully installed the driver. Now we get a “Connection to the server could not be established” connection error asking to check the network ports (this was working fine before) when trying Test Connection on the Qlik Sense server or when Deploying and Executing the endpoint I have verified that the port setup in Qlik is the default and that both port 80 and 443 (and the other Qlik ports) are reachable through Test-Netconnection. 

rory.smith
Rank
Userlevel 5
Badge +7

I switched to certificate authentication which got the connection to the Qlik Sense server working again, but now we get the original “cannot modify the connection something is wrong with the connection string” error again. It looks like installing the driver did not solve the underlying issue.

rory.smith
Rank
Userlevel 5
Badge +7

Also: installing the driver (and / or the C++ Redistributable for Visual Studio 2022) ended up making the Qlik Sense server no longer respond to requests coming from outside the server, so we had to revert to a previous state.

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Hi @rory.smith do you have time for a screen share today sometime between 8.30-10 or 11-12 or 13.30-15 CET?

rory.smith
Rank
Userlevel 5
Badge +7

Hi Christian,

 

I won't be able to access this customer's system, but luckily our own system suffers from the same problem. Would 11:00 CET work for you?

Christian Hauggaard
Rank
Userlevel 6
Badge +5

@rory.smith yes, I have sent you an invite now :)

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Thanks for the call @rory.smith, we were able to deploy successfully after installing version 18.2.3 of the Microsoft OLE DB Driver for SQL Server on the Qlik Server (instead of version 19.x). Another note that was made during the call, is that it is only for SQL Server 19 that requires this driver to be installed

 

Reply


Terms and ConditionsCookie settings