We recently upgraded our Qlik Sense PROD from Nov 2023 SR 9 version to May 2025 SR3 version. After the upgrade, our Qlik Sense-Teradata Connection is not working, and it gives attached error message.

Error:

errror [08001][Qlik][socket error](439) WSA E HostUnreach: The teradata server can't be currently be reached over this network

 @Sonja_Bauernfeind @Elisabeth-Virc-Hall @Sandra_Mellstrand @Sebastian_Linser 

Has anyone run into similar issue? 

Any insights/thoughts on this topic are appreciated. 

Thank you!

Qlik Sense Enterprise on Windows  

Hello Community,

Last week we have upgraded the Qlik Sense to May 2024 Patch 4 from Nov 2022 Patch 1.

While upgrading the we got few issues and had to repair the installation.

Since then we are facing an issue with the native Teradata connections in the new version. The screenshot of the error message from HUB is attached.

And below is the error message found in the connector logs:

TestConnect was not successful: message='Error message:  Please check the values for Username‚ Password‚ Host and other properties. Description: Client unable to establish connection', detailMessage='ERROR [08001] [Qlik][socket error] (439) WSA E HostUnreach: The Teradata server can't currently be reached over this network'.  

The Teradata database has a NLB(Network Load Balancer) in front and if we specify the host of NLB, we are getting the issue. The same setup used to work before the upgrade.

However, if we provide the DB hostname directly, then the connection works fine. However, as per policy we cant specify the DB hostname directly and needs to use NLB.

Kindly suggest how can this be fixed.

Thanks.

Please review the following issue:

Qlik Replicate is altering the DB Oracle data type for NUMBER columns with precision greater than 38 when replicating from an Oracle data source. Specifically, it reduces the precision to 0.000000000000000.

During replication from Oracle to Azure Event Hub, columns defined as NUMBER with precision > 38 are not preserved as is.

Even when changing the data type to VARCHAR and stopping and restarting the task, Qlik Replicate continues to convert NUMBER > 38 columns, resulting in data loss or incorrect data.

Our current data flow setup is as follows:

• From Oracle (ODS) to local disk: T_LSS_ODS
• From local disk: S_ODS_LSS to Azure Event Hub
•  

Both T_LSS_ODS and S_ODS_LSS are located on the same Qlik application server.

The issue concerns the column ORA_LINE_ID, which has the NUMBER data type at the Oracle database level.

Currently, the setup involves converting NUMBER to VARCHAR at each step:

• ODS (NUMBER) → VARCHAR
• T_LSS_ODS (NUMBER as VARCHAR)
• S_ODS_LSS (NUMBER as VARCHAR)
•  

We would greatly appreciate your guidance on how to resolve this issue.

Hi,

Is there a possibility or an automation with which a QVS file can be executed without it having been imported into an app before?

Best regards

Christian

What is the best way to change the email id of an existing microsoft teams connection in automation for sending teams messages. Is there a way to create a config file which contains the email id and pass the same email id whatever is present in the config file in the microsoft teams connection?

@mbj , @richbyard , @pawwy1415, ,@ ErikWetterberg,@rohitk1609,@Mp3Leaks, @petter, @Michael_Tarallo

I am trying to replicate the Oracle data to the Target Database Postgres using Qlik Replicate. When I try to replicate numeric field from Oracle to Postgres, it is truncating the Decimal values. When I transformed the data time within the settings from numeric(10,0) to numeric (10,2) as well it is just replacing the decimal values to 00 rather than replicating the original source values. Any thoughts on how I can resolve it issue

I'm having difficulty summing this polynomial, I want to get a total of indvidual row results.  Any suggestions on how to go about this? Wrapping it in sum() or rangesum() is not working. 

10.384*pow([Normalized Month],5) - 33*pow([Normalized Month],4) + 38.831*pow([Normalized Month],3) - 20.218*pow([Normalized Month],2) + 4.1059*[Normalized Month] - 0.1037

*the Normalized Month dimension is a decimal