Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

zahidrahim_ocp
Contributor

QMC Task Failed with TNS:NO Listener

Dear Experts,

I have an APP connected with Oracle and scheduled in a task. But daily it is Failed with Error: TNS No Listener But Just on manually pressing the start button it executed successfully.

I have also added the Connection Service Name in TNSNAMES.ORA file.

Regards,

Zahid Rahim

Tags (1)
3 Replies

Re: QMC Task Failed with TNS:NO Listener

A wild guess but is the task scheduled to run overnight at a time when the database has been closed to do a cold backup ?

zahidrahim_ocp
Contributor

Re: QMC Task Failed with  TNS:NO Listener

Dear Bill,

Thank you for the reply, infact issue with the Qlik Server Time. The task time set is not matched with the server time and that time server was down.

Regards,

Zahid Rahim

srishsum2017
Contributor

Re: QMC Task Failed with TNS:NO Listener

Hi Zahid,

Please check these points-

1-if you applied section access in your application so also gives the username and password of admin in QMC.

2- Also check the memory consumption while you run that task.