Qlik Sense data connection sometimes fails

[Jeffrey_Li]

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

Bo

[Jeffrey_Li]

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

[Jeffrey_Li]

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

[Jeffrey_Li · Accepted solution]

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