Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL time out message during LOAD process (sense 3.1 SR1)

Hi there !

We are trying the Qlik sense server.

We have a Microsoft SQL server DB, where they are many rows (about 3 Millions / year).

I did the best to remove all not necessary data, unfortunately, it seems that Qlik sense refusing to Load data.

i have reduced to 1 year (VS 5 years) => same pb

3 months (about 800000 rows) => same pb

1 month (about 300000 rows) => OK

I have tried to load (display) data of a year on SQL management studio ... of course it took a while but it works.

could you help me please.

i do not see anywhere if there is any data size limitation with Qlik sense.

Also, in our project we expected to see "Live" data on Qlik , i mean we expected to make a scheduled task in order to reload data every 15 min.

(by the way, does Qlik reloads All data evrytime, or just "new" data ?)

MANY MANY thanks for all help you could provide.

i guess you understood that English is not ma native language, sorry for that 😉

10 Replies
Not applicable
Author

Hi,

    I fixed this error on my application adding parameter: "QueryTimeout = -1" on connection string of my PG Database

    The parameter must be inserted on connection string ...

     I´m using QlikView Desktop

     Tks

Emerson (Blumenau/SC/Brazil)