topic Re: 11.2 Upgrade: Protocol Error TDS Stream in QlikView

11.2 Upgrade: Protocol Error TDS Stream

MalcolmCICWF — Mon, 23 Dec 2013 16:43:02 GMT

I have been looknig around and unable to find someone with the answer to this error. After the 11.2 upgrade, I an getting this for only one of my reports that ran fine before the upgrade. Does anyone know how to solves this? What caused it in the 11.20 upgrade?

Re: 11.2 Upgrade: Protocol Error TDS Stream

Mon, 23 Dec 2013 19:43:21 GMT

I believe this error not in Qlikview and this is error with sql server network connection problem.

Please try to connect to sql server manually , after that try to reload in qlikview

Re: 11.2 Upgrade: Protocol Error TDS Stream

MalcolmCICWF — Mon, 23 Dec 2013 19:59:50 GMT

Well, if it is not a Qlikview error, why have myself and others received this immediately after an upgrade to 11.2 version? Logistically that would direct the issue to Qlikview's end, not ours.

Re: 11.2 Upgrade: Protocol Error TDS Stream

Mon, 23 Dec 2013 20:05:13 GMT

I believe, this is some network connection problem sql server and qlikview 11.2. Please check ODBC/OLEDB drivers were compatible with 11.2 version.

Re: 11.2 Upgrade: Protocol Error TDS Stream

maxgro — Mon, 23 Dec 2013 21:56:03 GMT

Does it happen only for this query to sql server or any query to sql (from qlikview)?

Did you try to execute the same query on the same host but using a different software (not Qlikview)?

Re: 11.2 Upgrade: Protocol Error TDS Stream

Clever_Anjos — Tue, 24 Dec 2013 00:28:08 GMT

Are you retrieving A.*, right?

Are you sure A.* does not return a column with same name of other columns?

This could lead to unexpected issues

Re: 11.2 Upgrade: Protocol Error TDS Stream

qlikpahadi07 — Tue, 24 Dec 2013 05:10:41 GMT

I believe the same its Network issue ... you can create a Simple connection String and check whether its working or not.

Re: 11.2 Upgrade: Protocol Error TDS Stream

Wed, 08 Jan 2014 21:11:57 GMT

I experienced the same error and it was very frustrating. I tested a lot and in one case I was repeating the ODBC connect function for the same connection. When I deleted that part of the script, it worked well. When I put that part of the script back in, the error occurred.

Can this help you? Or did you find another solution?

Re: 11.2 Upgrade: Protocol Error TDS Stream

Clever_Anjos — Thu, 09 Jan 2014 01:06:07 GMT

Did you check if there´s two columns with same name?

Re: 11.2 Upgrade: Protocol Error TDS Stream

Thu, 09 Jan 2014 07:48:17 GMT

Yep, that was not the case. As I mentioned above, I did make the same connection twice. When I deleted the redundant connection, it worked fine.

Re: 11.2 Upgrade: Protocol Error TDS Stream

cpiocpio — Thu, 16 Jan 2014 16:33:17 GMT

Also have issue with 11.20.12018.0

We have 3 reloads going on, 2 are perfect, but one fails MOST of the time, but not all the time.

The difference is that failing one is using a different data source and therefore of course a different ODBC connector.

It always errors when accessing 1 of a pair of tables, but other loads with the same ODBC in the same QVW, do not fail.

All this points to bad data, BUT it usually works if run reload manually but usually fails if run a scheduled task.

Re: 11.2 Upgrade: Protocol Error TDS Stream

Thu, 16 Jan 2014 16:36:48 GMT

I have received the exact same errors after upgrading to this version when before everything worked fine.

Clearly a bug in Qlikview.

Installing the latest ODBC drivers for the database and creating a new connection using this driver solves the problem.

Re: 11.2 Upgrade: Protocol Error TDS Stream

agigliotti — Wed, 17 Sep 2014 09:22:54 GMT

Where I can find ODBC/OLEDB drivers compatible list for 11.2 version?