Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

MalcolmCICWF
Contributor II

11.2 Upgrade: Protocol Error TDS Stream

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?

Capture.JPG.jpg

12 Replies
Not applicable

Re: 11.2 Upgrade: Protocol Error TDS Stream

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

MalcolmCICWF
Contributor II

Re: 11.2 Upgrade: Protocol Error TDS Stream

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.

Not applicable

Re: 11.2 Upgrade: Protocol Error TDS Stream

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.

MVP
MVP

Re: 11.2 Upgrade: Protocol Error TDS Stream

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)?

Employee
Employee

Re: 11.2 Upgrade: Protocol Error TDS Stream

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

qlikpahadi07
Valued Contributor

Re: 11.2 Upgrade: Protocol Error TDS Stream

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

Not applicable

Re: 11.2 Upgrade: Protocol Error TDS Stream

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?

Employee
Employee

Re: 11.2 Upgrade: Protocol Error TDS Stream

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

Not applicable

Re: 11.2 Upgrade: Protocol Error TDS Stream

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.