Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😉
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)