Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
OmarBenSalem
Partner - Champion II
Partner - Champion II

Problem with Qlik SMTP connector

I'm using the Qlik SMTP connectorto send email in case of something happening:

the code is basic

Capture.PNG

 

Now the problem is :

Each time I reload the app MANUALLY from the SCRIPT :

Capture.PNG

 

The app reloads just fine and I receive the EMAIL.

 

BUT, when the app is reloaded through the QMC (task); it sometimes reload with no error and usually FAILS ..

Am I the only one with such a weird behaviour?

Thank u for ur help !

3 Replies
Anil_Babu_Samineni

How you are using SMTP? Is that thru web-connector? If so, Web connector will generate one Select statement. Simply use them with variables?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
OmarBenSalem
Partner - Champion II
Partner - Champion II
Author

Yes; I'm using the Qlik web connector package which includes an SMTP connector.

And as I already shared my script, I'm using the select statement that the connector generates:

 

LOAD
status,
result,
filesattached
FROM [lib://Notification_DemandesBloquées(RECETTE)]
(qvx);

 

Problem:

when I reload through the script : It ALWAYS works

When I reload with the QMC (Task): It usually FAILS and somteimes works and receive the email

Anil_Babu_Samineni

We noticed same behavior. But, we got the solution If task got failed we looked the services of web-service which is shut down hence re-start the service got resolved the issue. Can you check the connection timeout response of Rest API and see, Default it was 30 seconds and we transfer that to 5 minutes which permanently resolved the issue.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful