During Email broadcast, mails are sent from system in the batch size of 200. For below broadcast we observed that emails have been sent out from system in different batches:
• Darlene Sanchez: Darlene.Sanchez@riverside.courts.ca.gov
• Pamela Rory: Pamela.Rory@riverside.courts.ca.gov
• Jayson Villaflor: JAYSON.VILLAFLOR@RIVERSIDE.COURTS.CA.GOV

From Email address: ‘kring@benxcel.com’

In attached list we have updated count of employee in different batches for which email was failed or sent successfully.

Sheetal Bodhale: . Can you please check reason for email failure, & share details.

Cc: Swapnil Pandhare Jyotibala Pardeshi

Cc: Ashwin Wankhede Saurabh Sablaka

Hi Hrishikesh Deshpande,

Any updates on this?

Thanks,
Sheetal Bodhale

Hi Satya / Sheetal Bodhale,

We have tried Email broadcast on RSC for HSPL Production company and observed that emails not going to all employees who has Incomplete Status.

Same we have tried on TIBCO for HSPL and observe that emails are going properly for all employees.

We will retest same on RSC for HSPL company and update.

Thanks,
Hrishikesh.

Hi Satya,

I have discussed this with Saurabh Sablaka,he told me to change failure routine to catch the mail failure reason.We didn't find any cause of mail failure.

I will discuss this with Swapnil Pandhare tomorrow and will update this accordingly.

CC:Swapnil Pandhare
Thanks,
Sheetal Bodhale

Hi Sheetal,

Please take this on priority & share details.

Hrishikesh Deshpande; Through email broadcast the mails are not sent to Terminated, Inactive or deceased employee. Please confirm this for difference on RSC & TIBCO.

Regards,
Satya Prakash

Cc: Swapnil Pandhare Saurabh Sablaka Ashwin Wankhede Samir Rakesh Roy

I need the root cause of this issue. Please provide asap

Hi Debbie Kulling,

We have made the code changes, need to enable the logging on production.

Will update you on the RCA and code fix by 10/30

Regards
Gaurav

SatyaSwapnil PandhareSamir

Hi Hrishikesh,

Email logging patch has been deployed on production. Can you please verify this & attach proof of testing.

Regards,
Satya Prakash

Cc: Swapnil Pandhare Sheetal Bodhale Gaurav Sodani

Hi Jyotibala Pardeshi / Sheetal Bodhale / Swapnil Pandhare,

Email broadcast is not working properly on RSC for HSPL company.

I have triggered email for Incomplete and Complete status employees, please find below result -

Login Status Complete - 296 Employees
Email sent to 88 employees only

Login Status InComplete - 1004 Employees
Email sent to 178 employees only

I have verified this in DB,
Query is - "select * from cdosyspara where companyid = 13066"

Please check this.

Thanks,
Hrishikesh

CC : Gaurav Sodani Satya @Rakes

CC : Satya Samir Bharti Satpute
Hi Hrishikesh Deshpande ,

Concern : Email broadcast not working properly.

Cause : We are sending emails in batches. We create a batch of 200 users and then send email to that batch. A comma seperated list is formed for these users and emails are sent to them. As per logs generated for your requests, it appears that length of BCC parameter exceeded and emails failed to sent. For sending email, CDO.Message object is created and as per below reference , its length is 4000 chars.
[Reference : https://www.sqlservercentral.com/Forums/Topic1141571-392-1.aspx]
In this case, BCC length is going above 4000 chars and string is truncated as per log. Due to this, emails are failed for that batch.

Correction : We will be reducing batch size to 80 users on production. This will reduce BCC length per batch and email will be sent properly.

You can test this once this change is done.

Thanks,
Swapnil P.

Email Broadcast Functionality is Tested On Production on "RSC for HSPL" company and all scenarios are working as expected.

All scenarios are working as expected except one.
If User select Incomplete Status and then select Complete Status (By pressing Control Key) then system not sending email to both status employees. it send email to only Incomplete Status employees.

Sheetal Bodhale, please check above Fail scenario. If it is valid then we need to fix. If it is as per design then we should show some message over there to guide user.

Thanks,
Hrishikesh.

Hi Hrishikesh Deshpande,,

We have verified mentioned failed scenario.If you select values of Login Status list box by pressing control key,it is fetching value of Incomplete Status only[As this is first value in drop down].

This is existing implementation.

CC:Swapnil PandhareSatya

Thanks,
Sheetal Bodhale

Hi Swapnil Pandhare/Sheetal Bodhale,

Above Shared result is not proper. Please ignore that.
I got that data at "select * from cdosyspara" table but as per discussion with Sheetal this will not Pass criteria. We should get email on mailbox.

We have verified that No emails getting sent from Email broadcast. also verified from backend log that Email sent with attachment getting failed.

After Email broadcast entry gets added at cdosyspara table. but email not received at mailbox.

Can you please check this?

Thanks,
Hrishikesh.

Adding comments for clarification:
Issue was resolved by decreasing batch size from 200 emails to 80 emails as this will reduce the risk of the email addresses exceeding the 4000 max char length.
However, there is still the change that email addresses (even with 80 emails per batch) may exceed the maximum. Dev will look into this scenario, therefore the ticket is still in development.
The issue for the client should no longer be occurring.

CC : Satya Samir Gaurav Sodani

Hi Jennifer Reed

With reduction of batch size, this issue is not occuring. Closing this issue as of now. If anything reported from client, we will reopen this .

Thanks,
Swapnil p.