I am trying to connect Oracle Client using ODBC connection and is working fine. But I am facing issue in loading complete data from database/table. I am getting timeout or system will stop resoponding after getting around 30K records. The particular table is having approx 9L records. My query to database is very straight forward, it doesnot have any conditions or aggregations.
What could be the issue ? Do we need make any changes in connection string or at oracle configuration ?
Check with Oracle DBAs that the user running the extraction (which may not be your user, but the one used by QlikView) has permissions to read all available lines.
Also, make sure the timeout is coming from the driver, not from QlikView itself, it could be that for some reason the server runs out of resources or there are issues with the network and then the query fails.
Thanks for quick response, Meanwhile I will check with DBA's on your suggestion.
For smaller dataset we don't face any issue, but when trying to fetch more than 100K records we encounter this problem. Another thing is we get all the records whatever has been fetched till error will be available in qvw.
Do we have any document on Qlikview & Oracle connectivity configurations