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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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
MVP
MVP

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
MVP
MVP

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