SQL Server query fails

shayraber — Tue, 07 Feb 2017 20:11:46 GMT

hi all,

i have an SQL Server DB with two table i want to extract from.

both are with the same structure.

created an ODBC connection and i'm able to extract data using sql select statements.

thw issue raised when i switched the query to be incremental based on an update filed at the table (datetime type).

the first table works as expected. the second one, which has the exact same structure DON'T...

the error i'm getting is (in blue and bold there is the variable holding the last update date):

.....

07/02/2017 21:55:23: 0025  service_req_DELTA:
07/02/2017 21:55:23: 0026  LOAD *
07/02/2017 21:55:24: 0027  SQL
07/02/2017 21:55:24: 0028  SELECT update_time
07/02/2017 21:55:24: 0029  FROM SysAid.dbo."service_req"
07/02/2017 21:55:24: 0030  where update_time >= '01/02/2017 00:00:00'
07/02/2017 21:55:25:       1 fields found: update_time, 4,351 lines fetched
07/02/2017 21:55:27: 0031  STORE * from service_req_DELTA into service_req_DELTA.qvd (qvd)
07/02/2017 21:55:28: 0034  UPDATE_TIMES2:
07/02/2017 21:55:28: 0035  LOAD 'service_req' as TABLE_NAME,
07/02/2017 21:55:28: 0036   Floor(Max(update_time)) as LAST_UPDATE
07/02/2017 21:55:28: 0037  Resident service_req_DELTA
07/02/2017 21:55:29:       2 fields found: TABLE_NAME, LAST_UPDATE, 1 lines fetched
07/02/2017 21:55:31: 0038  DROP Table service_req_DELTA
07/02/2017 21:55:34: 0040  service_req_history_DELTA:
07/02/2017 21:55:34: 0041  LOAD *
07/02/2017 21:55:35: 0042  SQL
07/02/2017 21:55:35: 0043  SELECT *
07/02/2017 21:55:35: 0044  FROM SysAid.dbo."service_req_history"
07/02/2017 21:55:35: 0045  where update_time >= '01/02/2017 00:00:00'
07/02/2017 21:55:37:       Error: SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
07/02/2017 21:55:55: 0045  EXIT Script

why does a where clause works at one table and doesn't work at the other one? please assist

Re: SQL Server query fails

m_s — Wed, 08 Feb 2017 10:09:58 GMT

Hello!

I dont know whats causing this but according to this thread, you should try updating your ODBC-Driver or use OLEDB:Protocol Error in TDS Stream

best regards

Re: SQL Server query fails

marcus_sommer — Wed, 08 Feb 2017 11:22:52 GMT

Maybe this is helpful:

https://community.qlik.com/search.jspa?q=Protocol+Error+in+TDS+Stream

- Marcus

topic Re: SQL Server query fails in QlikView

SQL Server query fails

Re: SQL Server query fails

Re: SQL Server query fails