topic Re: Qlik Sense data connection sometimes fails in Connectivity & Data Prep

Qlik Sense data connection sometimes fails

Jeffrey_Li — Tue, 10 Sep 2019 14:00:18 GMT

Some of our Qlik Sense tasks sometimes failed for the same type of error: Error: Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

And data connection to a folder (on Qlik sense server) sometimes failed too with error: Cannot open file: 'lib://<folder_name>/qvdname.qvd'

Each time when it happens, we need to restart Qlik Sense Scheduler service. The task worked well after restarting. However, it happens again next run and we have to do another server restart. What might cause this and how to solve it?

Thanks

Re: Qlik Sense data connection sometimes fails

Jeffrey_Li — Tue, 10 Sep 2019 15:30:08 GMT

Here is one example of data connection code which threw error: LIB CONNECT TO '<ODBC DSN name>'

Re: Qlik Sense data connection sometimes fails

Jeffrey_Li — Tue, 10 Sep 2019 16:00:12 GMT

ODBC DSN which threw errors are for SQL Server and Netezza. So far DSNs for other database types (Oracle, My SQL etc) works well.

Re: Qlik Sense data connection sometimes fails

Jeffrey_Li — Mon, 16 Sep 2019 19:32:40 GMT

We have two nodes in Qlik Sense cluster. I re-installed the ODBC driver on node #2 and the issue was solved.