Hi All,
We have a functionality of sending email. Where we are generating 5 csv files in parallel and sending them via email as attachments.
When we are doing load testing around 100 transactions, in the beginning emails are sent immediately for few sets.
But after sometime, the emails are going to "Pending" state and server is in warning state.
The server is in warning state due to STUCK THREADS on the server.
Then we have set timeout parameters (in ms) -Dmail.smtp.connectiontimeout=50000 -Dmail.smtp.timeout=50000 in SOA manager servers.
With setting the timeout parameters, we are getting mails but after receiving all the mails. For every 10 mins we are getting duplicate mails for large files (1 MB). It can be due to the re-delivery limit to -1 in ORASDPMDRIVERDEFSNDQ1 . So we set it to 1 as of now.
This time out is not bringing the server down but we get duplicate mail of 1.
If we will keep the redelivery limit 0 then we might not get duplicate,but for actual error on SMTP it will not retry which we can not afford as well.
Can anyone please suggest what settings are to be made in order to stop getting the duplicates and this issue to server and also to get all the emails.
Thank you.