Scheduled Email Randomly not sent
when scheduled dashboard reports are sent via email. If you see several emails goes out correctly. And several mails did not sent or not recieved at all.
You may want to try the following:
1) Increase the memory limits on the exporting pod by running: kubectl -n sisense edit deployment exporting -> under spec: -> containers: -> resources: -> limits: -> change memory from memory: 1000Mi to memory: 2000Mi
2) Check the Max memory limits defined for the reporting pod by running the following command: kubectl -n sisesne describe pod <pod_name> In case the memory limit is below 2000Mi, please increase it to 2000Mi using the following procedure: kubectl -n sisense edit deployment reporting -> under spec: -> containers: -> resources: -> limits: -> change memory from memory: 1000Mi to memory: 2000Mi
3) Please note that a pod restart is not required, it should be done automatically. After the pod was restarted please confirm that the containers of reporting and exporting pods were updated to memory: 2000Mi by running the command: kubectl -n sisense describe pod <pod_name>
4) Try to reproduce the issue to see if the memory increase affected the results If you still encounter any issues:
5) Check if there is a firewall configured between the SMTP server to Sisense server
6) Is there a local firewall configured (windows firewall or iptables) on the SMTP server
7) What is the timeout configuration on Sisense for the SMTP server - can be found at Admin tab -> Email server -> Connection timeout, Greeting timeout, and Socket timeout
It is recommended to Please change the followng configurations of in the Admin Tab --> Email server --> SocketTimeout configuration:
a) socketTimeout to 600,000 milliseconds
b) the ConnectionTimeout to 120,000 milliseconds
c) GreetingTimeout to 30,000 milliseconds.
Try to reproduce the issue again to see if these setting increases affected the results or not.
If you still encounter issues, please create a support portal and Attach the following logs to the ticket:
Jobs.log - in /var/log/sisense/sisense/jobs.log
Reporting.log - in /var/log/sisense/sisense/reporting.log
Exporting.log - in /var/log/sisense/sisense/exporting.log
Galaxy.log- in /var/log/sisense/sisense/galaxy.log
Api-gateway.log - in /var/log/sisense/sisense/api-gateway.log
Identity.log - in /var/log/sisense/sisense/identity.log
