topic Re: Error getting during data load from SQL Server into QlikSense App in App Development

Error getting during data load from SQL Server into QlikSense App

kakaderanjit53 — Wed, 21 Feb 2018 07:52:00 GMT

Hi Qlik Experts,

I am trying to load the data from the SQL Server into the QlikSense application.,

I can able to load the data from other tables and Views without any error but when I am trying to load the

data from one view i.e. "VIEW_CBS_Journal" ,I am getting following error message and unable to load the data in the qlik application.

kindly PFB screenshot and help me for resolving my issue.

Thanks & Best Regards,

Ranjit Kakade.

Re: Error getting during data load from SQL Server into QlikSense App

jonathandienst — Wed, 21 Feb 2018 07:55:29 GMT

This is a SQL/network error.

Quote:

...These errors sound like there may be a networking issue ..... Possibly a faulty network card in one of the computers or an issue with the networking hardware in between them. Have you checked the event logs on both computers for networking errors at the OS level...

Look here https://www.google.com/search?q=protocol+error+in+tds+stream

Re: Error getting during data load from SQL Server into QlikSense App

kakaderanjit53 — Thu, 22 Feb 2018 16:52:12 GMT

Hi Jonathan,

Thanks for your important reply,I got the solution of my above issue.

I have created new OLEDB connection with my MS SQL SERVER instead of using ODBC connection,