Hello Raymond Williams

I have linked this ticket to WT-6748.

Yesterday we have deployed this ticket fix on production and reverted due to heavy log generation.
We have reverted the code, so this issue should be gone. Please let me know if still some body is receiving duplicate reports.

Today I am busy with WT-8924 and WT-9223

I will be looking soon into it.

Thanks

Hi Dev - We were advised that as of 6/6/17, the client has still been receiving emails. This is with FDU - Olivea Carter - Adding to keep watch on this item.

Jenni

3Cs
Concern: Multiple Reports were sent
Cause: It was picking up same reports multiple time
Correction: Now we have added new flag and doing update after picked-up. So it will not repick same schedule.

Affetcted Areas:
1. Schedule reports
2. View calender
3. Download delivered report popup
4. Export Schedule Utility

Affetcted Files:
Please check attached Affected File Names.txt file

Tested Scenarios:
1. Verified changes in status fields are working as per our expectation. (Step- by-step for every state).
2. Verification of failure status and exception details are updating properly.
3. Verification of one schedule report is picking only once (Even it failed while execution/execute sucessfully).
4. Verification of another reports in loop when exception occur at middle.
5. Verification on View Calender and it's status (Failed, Scheduled and Completed).
6. Verification of action and statuses (Failed, Success, Scheduled Yet) on Schedule Screen- Download delivered report popup.
7. Verified Add, Update and Delete functionality of Schedule

Note: Actual Email not verified on developement environment. Need to test email with report attachement on another environments.

HI [~parmeshwar.jumbade],

Tried following Report Scheduler type on LB - FDU

1) Scheduled one Billing Report by using Only Ones Scheduled Type
2) Scheduled one Billing Report by using Monthly Scheduled Type
3) Scheduled one Billing Report by using Only Ones and Monthly Scheduled Type with 10 min differences in scheduled time
4) Scheduled Employee Census and Billing Report on Same Time by using Only Ones Scheduled Type
5) Scheduled Employee Census, Confirmation Statement , Billing Report at same time by using Monthly Scheduled Type
6) Scheduled Employee Census, Enrollment Report , Confirmation Statement and Billing Report at same time by using Daily Scheduled Type

In all above scenarios , Email and Report are received only ones time except in first scenarios.

In First Scenarios , Received Two Email with 5 min differences.

CC - Prasanna Karlekar

Thanks,
[~meghana joshi]

Hello [~meghana joshi]

Issue not reproduced at our end but we have handled code were have chances to occur such case. Please check one more time at your end if you could able to reproduce it. It should not.

*Impacted Files: *

Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetReportForExportNew.StoredProcedure.sql
Database Objects/MasterCompanyDB/07_Data/442_WT-9441_WTB_Report_ModData_ReportScheduleCalenderDates.sql

Please verify all schedule type reports and it's status are working or not.

--CC Prasanna Karlekar

Verified below scenarios on LB

1) Scheduled one Billing Report by using Only Ones Scheduled Type
2) Scheduled one Billing Report by using Calender Date Scheduled Type
3) Scheduled one Billing Report by using Daily Scheduled Type
4) Scheduled one Billing Report by using Monthly Scheduled Type
5) Scheduled one Billing Report by using Weekly Scheduled Type
6) Scheduled Employee Census, Confirmation Statement , Billing Report at same time by using Monthly Scheduled Type
7) Scheduled Employee Census, Confirmation Statement , Billing Report with different time by using Monthly Scheduled Type

In all above scenarios , Email and Report are received properly ( i.e. Only one time )

CC - Sachin Hingole Prasanna Karlekar

Ready For Stage

Will update testing status ones WT-9223 jira testing is completed on LB.

CC - Rakesh Roy Sachin Hingole

[~parmeshwar.jumbade] Prasanna Karlekar

Testing of Jira blocked due to WT-10049

CC - Sachin Hingole

Please test this now. WT-10049 issue been resolved.

CC- Prasanna Karlekar Sachin Hingole

Tested all mentioned scenarios on Stage - FDU For HSPL.

It's Working Fine.

But, That Jira is dependent upon on WT-9223. So, Will update testing status ones WT-9223 is completed on Stage.

CC - Sachin Hingole

Verified on Stage for different server companies and it is working Fine.

As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129, WT-9377 move at same time on Production. So, We will move all enhancement on 09/19/2017

CC - Sachin Hingole

Raymond Williams Please verify this issue and confirm.