QVX ERROR

[Thouria_54]

Bonjour 

je rencontre une erreur dans le chargement de donnée dans qlik pourriez vous me dire à quoi correspond l'erreur 

[bhaskar_sm · Accepted solution]

Hi,

Can you please share the script snapshot and script log in English? so that we can help you resolve this issue

Thanks,

BK

[Thouria_54]

06:34:45,303 [1] - Configuring connector
06:34:45,794 [1] - Running server
06:34:46,062 [1] - Command pipe connected...
06:34:46,095 [1] - RECEIVED: QvxRequest {Command=QVX_CONNECT, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:46,168 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:46,188 [1] - RECEIVED: QvxRequest {Command=QVX_EXECUTE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:46,286 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:47,473 [4] - RequestUriString: https://datamarket-api.qlik.com/api/v6/table.csv?ds=50e3!8olw=3:8olx=3:MEASURE=1
06:34:47,474 [4] - Sending JWT
06:34:47,719 [4] - Error processing data
System.Net.WebException: La demande a ?t? abandonn?e?: Impossible de cr?er un canal s?curis? SSL/TLS.
? System.Net.HttpWebRequest.GetResponse()
? Qlik.Connectors.DataMarket.Helpers.CreateResponse(String query, String postfix, String jwt)
? Qlik.Connectors.DataMarket.DataMarketConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)
06:34:47,757 [3] - QvxDataPipeWriter.Write: 0 rows sent.
06:34:47,757 [3] - Returning exception
System.Net.WebException: La demande a ?t? abandonn?e?: Impossible de cr?er un canal s?curis? SSL/TLS.
? System.Net.HttpWebRequest.GetResponse()
? Qlik.Connectors.DataMarket.Helpers.CreateResponse(String query, String postfix, String jwt)
? Qlik.Connectors.DataMarket.DataMarketConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)
06:34:47,757 [3] - Returning exception
System.Net.WebException: La demande a ?t? abandonn?e?: Impossible de cr?er un canal s?curis? SSL/TLS.
? System.Net.HttpWebRequest.GetResponse()
? Qlik.Connectors.DataMarket.Helpers.CreateResponse(String query, String postfix, String jwt)
? Qlik.Connectors.DataMarket.DataMarketConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)
06:34:47,758 [3] - Error occurred reading data from server:
06:34:47,758 [3] - La demande a ?t? abandonn?e?: Impossible de cr?er un canal s?curis? SSL/TLS.
06:34:47,761 [3] - QVX_UNKNOWN_ERROR: La demande a ?t? abandonn?e?: Impossible de cr?er un canal s?curis? SSL/TLS.
06:34:47,765 [1] - RECEIVED: QvxRequest {Command=QVX_GET_EXECUTE_ERROR, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:47,766 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:47,795 [1] - RECEIVED: QvxRequest {Command=QVX_TERMINATE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:47,797 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:47,797 [1] - TERMINATING

[Thouria_54]

here the log script thanks a lot 

06:34:45,303 [1] - Configuring connector
06:34:45,794 [1] - Running server
06:34:46,062 [1] - Command pipe connected...
06:34:46,095 [1] - RECEIVED: QvxRequest {Command=QVX_CONNECT, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:46,168 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:46,188 [1] - RECEIVED: QvxRequest {Command=QVX_EXECUTE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:46,286 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:47,473 [4] - RequestUriString: https://datamarket-api.qlik.com/api/v6/table.csv?ds=50e3!8olw=3:8olx=3:MEASURE=1
06:34:47,474 [4] - Sending JWT
06:34:47,719 [4] - Error processing data
System.Net.WebException: La demande a été abandonnée : Impossible de créer un canal sécurisé SSL/TLS.
à System.Net.HttpWebRequest.GetResponse()
à Qlik.Connectors.DataMarket.Helpers.CreateResponse(String query, String postfix, String jwt)
à Qlik.Connectors.DataMarket.DataMarketConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)
06:34:47,757 [3] - QvxDataPipeWriter.Write: 0 rows sent.
06:34:47,757 [3] - Returning exception
System.Net.WebException: La demande a été abandonnée : Impossible de créer un canal sécurisé SSL/TLS.
à System.Net.HttpWebRequest.GetResponse()
à Qlik.Connectors.DataMarket.Helpers.CreateResponse(String query, String postfix, String jwt)
à Qlik.Connectors.DataMarket.DataMarketConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)
06:34:47,757 [3] - Returning exception
System.Net.WebException: La demande a été abandonnée : Impossible de créer un canal sécurisé SSL/TLS.
à System.Net.HttpWebRequest.GetResponse()
à Qlik.Connectors.DataMarket.Helpers.CreateResponse(String query, String postfix, String jwt)
à Qlik.Connectors.DataMarket.DataMarketConnectorDataReader.Read(BlockingCollection`1 sourceDataRows)
06:34:47,758 [3] - Error occurred reading data from server:
06:34:47,758 [3] - La demande a été abandonnée : Impossible de créer un canal sécurisé SSL/TLS.
06:34:47,761 [3] - QVX_UNKNOWN_ERROR: La demande a été abandonnée : Impossible de créer un canal sécurisé SSL/TLS.
06:34:47,765 [1] - RECEIVED: QvxRequest {Command=QVX_GET_EXECUTE_ERROR, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:47,766 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:47,795 [1] - RECEIVED: QvxRequest {Command=QVX_TERMINATE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
06:34:47,797 [1] - SENDING: QvxReply {Result=QVX_OK}
06:34:47,797 [1] - TERMINATING

[bhaskar_sm]

Hi,

Please don't mark any comment as a solution until and unless solutions have been provided or suggested.

it seems to have an issue with SSL/TSL kindly follow the below steps and please let me know if that resolves your issue.

https://support.qlik.com/articles/000070276

Were certificates modified?

• If this has worked previously, verify that the correct certificates are still installed and were not modified.

Is the correct root certificate available?

• Download Baltimore CyberTrust Root certificate from Digicert.
• Install the root certificate in the "Trusted Root Certification Authorities" store in your Qlik Web Connectors server