topic Re: ERROR [08S01] TDSConnectionFailed in App Development

ERROR [08S01] TDSConnectionFailed

Ruan_Sasse — Thu, 29 Aug 2024 17:41:25 GMT

Boa tarde,

Meu relatório está carregando dados de uma tabela de sql-server localizada na nuvem, e algumas vezes ocorre esse erro TDSConnectionFailed. O erro não ocorre sempre na mesma tabela, já realizei um teste e o banco retorna quando ocorre o erro, caso acontecer e iniciar novamente a carga ela volta a funcionar. Esse problema já aconteceu com algum dos senhores, alguém tem alguma ideia do que é possível fazer.

Desde já agradeço.

Exemplo do erro no log do QMC em anexo

Re: ERROR [08S01] TDSConnectionFailed

SterreKapteijns — Fri, 30 Aug 2024 07:24:01 GMT

Could you provide the question in english?

Re: ERROR [08S01] TDSConnectionFailed

Ruan_Sasse — Fri, 30 Aug 2024 11:15:10 GMT

My report is loading data from a SQL Server table located in the cloud, and sometimes I encounter this error: TDSConnectionFailed. The error does not always occur on the same table. I have conducted a test, and when the error occurs, the database does respond. If I restart the load, it works again.

Has anyone experienced this issue before? Does anyone have any ideas on what can be done to resolve it?

Thank you in advance.

Example of the error in the QMC log attached.

Re: ERROR [08S01] TDSConnectionFailed

Ruan_Sasse — Fri, 30 Aug 2024 12:12:43 GMT

Sure! Below is the text in English

Re: ERROR [08S01] TDSConnectionFailed

p_verkooijen — Fri, 30 Aug 2024 12:30:41 GMT

Hi @Ruan_Sasse check

https://community.qlik.com/t5/Official-Support-Articles/Reload-Fails-With-Error-Message-quot-Microsoft-ODBC-SQL-Server/ta-p/1711726

Also

https://community.qlik.com/t5/New-to-Qlik-Analytics/ERROR-08S01-TDSConnectionBroken-TDSConnectionFailed/td-p/1998266

It's mainly network or database server related, does not have to be more than a glitch so if you check database connectivity after the error you will not able to verify the issue.

That's also why it does not happen regularly or on the same table.

Re: ERROR [08S01] TDSConnectionFailed

Ruan_Sasse — Fri, 30 Aug 2024 14:17:49 GMT

Good morning, everything alright? Thanks for your response. In the first link, the information refers to an ODBC connection, but in my case, the native Qlik Sense connector for Microsoft SQL Server was used, so I believe the suggestions mentioned there do not apply. As for the second link, it seems that the topic was left without a solution as well.

So, is the most likely cause the communication between the Qlik Sense server and the SQL Server database located in the cloud?

Re: ERROR [08S01] TDSConnectionFailed

p_verkooijen — Fri, 30 Aug 2024 14:21:32 GMT

Hi @Ruan_Sasse

Good afternoon 🙂

As I mentioned, it's mainly network or database server related.
So indeed a communication issue between QS and SQL server.

Re: ERROR [08S01] TDSConnectionFailed

Ruan_Sasse — Fri, 30 Aug 2024 16:03:39 GMT

Thank you very much!