Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pareshra
New Contributor

QlikView desktop unresponsive while fetching even 1 row

I am connecting Postgres 9.1.22 using 64 bit ODBC driver. In PostgresSQL we have huge table which has 80 GB size and 100 million rows. If I tried to fetch even 1 rows using QlikView my desktop application hangs forever. We tried it for 2 hours then killed task.

Any idea if there are issues with QlikView ODBC driver? Please suggest if any better driver can help in resolving this issue. OLEDB / JDBC preferred opensource driver.

4 Replies

Re: QlikView desktop unresponsive while fetching even 1 row

Can you look Direct Discovery ‒ QlikView

Life is so rich, and we need to respect to the life !!!

Re: QlikView desktop unresponsive while fetching even 1 row

"Any idea if there are issues with QlikView ODBC driver?"


Which version of the Qlik ODBC Connector package are you using? The current package doesn't seem to support PostgreSQL 9.1, only versions 8.4, 9.2 and 9.4.


See PostgreSQL ‒ Qlik Connectors

ramasaisaksoft
Valued Contributor III

Re: QlikView desktop unresponsive while fetching even 1 row

richcook
New Contributor III

Re: QlikView desktop unresponsive while fetching even 1 row

Hi Paresh, if all else fails you could try introducing an export process into your ETL layer, maybe a CSV chopped into sensible sizes. Does your data change or is most of it static?

Community Browser