OLEDB-SQL Server connection issue

[chaitanyajami]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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?

[stabben23]

Hi,

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

[chaitanyajami]

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

[Anil_Babu_Samineni]

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

[chaitanyajami]

Hi,

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

[chaitanyajami]

Hi ,

It is working fine now, Thanks for the help.