There is no open data connection.

[pjpkumar26]

Hi All,

I am getting the following error message when refreshing the task from Qlik QMC

There is no open data connection.

Log file :

20250408T123245.180+0100 0017 ANALYSIS_TYPE:
20250408T123245.180+0100 0018 LOAD
20250408T123245.180+0100 0019 ANALYSISTYPEID,
20250408T123245.180+0100 0020 ANALYSISNAME,
20250408T123245.180+0100 0021 SENSGROUP
20250408T123245.180+0100 0022 SQL
20250408T123245.180+0100 0023 SELECT
20250408T123245.181+0100 0024 ANALYSISTYPEID,
20250408T123245.181+0100 0025 ANALYSISNAME,
20250408T123245.181+0100 0026 SENSGROUP
20250408T123245.181+0100 0027 FROM REFERENCE."ANALYSIS_TYPE"
20250408T123245.181+0100 Error: There is no open data connection.
20250408T123245.181+0100 Execution Failed
20250408T123245.183+0100 Execution finished.

can any one suggest please where can I check this as I am new to Qlik Sense

Regards,

Kumar

[Chanty4u]

Please test your connection in your development environment 

Or check the connection details 

And retry 

[lachlanwcast]

In the load script for the app that is reloading, do you see a line above the SQL statement that contains 'LIB CONNECT' - if not, you'll need to add it in above the SQL SELECT statement you have in the provided log.

The LIB CONNECT is added from the Data Connections sidebar in the Data Load Editor of the app - this should be a data connection that is configured to connect and authenticate to the database you mention here: " FROM REFERENCE."ANALYSIS_TYPE"