topic Re: OLEDB-SQL Server connection issue in QlikView

OLEDB-SQL Server connection issue

chaitanyajami — Fri, 03 Mar 2017 10:43:50 GMT

Hi all,

Iam connecting to SQL Server data source(one of the multiple data sources) to extract the data into Qlikview and saving the data into QVD's, when i reload the Qvw it is getting connected to SQL server with credentials and i could see the statement "Connected" in the popup but application is getting stuck for hours over the same step without going forward, can some one please suggest me how/what could i check more about this particular issue to comeout of it.Thanks in advance.

Re: OLEDB-SQL Server connection issue

Miguel_Angel_Baeyens — Fri, 03 Mar 2017 11:03:11 GMT

In the script, what is the next instruction right after CONNECT ? A JOIN LOAD, a CONCATENATE LOAD, no LOAD but SQL SELECT ?

If you run that query with the SQL Management Studio using the same user that QlikView is using, what do you see?

Re: OLEDB-SQL Server connection issue

stabben23 — Fri, 03 Mar 2017 11:36:56 GMT

Hi,

If you try to Connect to a viewtable in a datawarehouse, be sure that Your index is correct.

Re: OLEDB-SQL Server connection issue

chaitanyajami — Mon, 06 Mar 2017 04:12:16 GMT

Hi,

it have sql select statement with keywords like CASE,THEN,GROUP BY, ORDER BY, and conditions like INNERJOIN and LEFT JOIN ,WHERE . Ok will run the query in SQL and let you know

Re: OLEDB-SQL Server connection issue

Anil_Babu_Samineni — Mon, 06 Mar 2017 04:38:42 GMT

Can you create Logfile for Document and check whether what was the time during reload tooks the reload. Which part is that?

Meantime, Try to share the Logfile and let us know which version you are been

Re: OLEDB-SQL Server connection issue

chaitanyajami — Mon, 06 Mar 2017 05:17:16 GMT

Hi,

I am able to reload now, and it is extracting data with the Query. Thank you

Re: OLEDB-SQL Server connection issue

chaitanyajami — Mon, 06 Mar 2017 05:17:49 GMT

Hi ,

It is working fine now, Thanks for the help.