WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-9441

Multiple Reports

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Low
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      FDU
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 31-Bugs

      Description

      Good day Dev.

      Can you please advise why the client received multiple billing reports this morning? Please ref CT-1655 for additional information and screenshot.

      Thanks,

      Raymond

        Attachments

          Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. WT-9446 Linium : RE: Daily Enrollment Changes_WT

          • Critical - This problem will block progress.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. WT-10049 Report - Server error on Report

          • Critical - This problem will block progress.
          • Closed
          relates to

          Support Activity - Support Activity WT-6748 Metso Benefits - Daily NewHire Report Dynamic report

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Raywill Raymond Williams (Inactive) created issue -
            Raywill Raymond Williams (Inactive) made changes -
            Field Original Value New Value
            Description Good day Dev.

            Can you please advised why the client received multiple reports this morning? Please ref CT-1655 for additional information and screenshot.

            Thanks,

            Raymond             		Good day Dev.

            Can you please advised why the client received multiple billing reports this morning? Please ref CT-1655 for additional information and screenshot.

            Thanks,

            Raymond
            Raywill Raymond Williams (Inactive) made changes -
            Attachment screenshot-1.png [ 47478 ]
            Raywill Raymond Williams (Inactive) made changes -
            Description Good day Dev.

            Can you please advised why the client received multiple billing reports this morning? Please ref CT-1655 for additional information and screenshot.

            Thanks,

            Raymond             		Good day Dev.

            Can you please advise why the client received multiple billing reports this morning? Please ref CT-1655 for additional information and screenshot.

            Thanks,

            Raymond
            rakeshr Rakesh Roy (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Aditya Vishwakarma [ aditya.vishwakarma ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Link This issue relates to WT-6748 [ WT-6748 ]
            Hide
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            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

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - 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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Issue Type Task [ 3 ] Bug [ 1 ]
            Status New Request [ 10029 ] Open [ 1 ]
            Workflow WT_Features [ 41042 ] WT_Defects [ 41132 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Link This issue duplicates WT-9446 [ WT-9446 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Link This issue is duplicated by WT-9446 [ WT-9446 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 17/May/17 01:30 AM - edited
            • Time Spent:
              1h
               

              Discussion and code go through on scheduler issue

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 46304 [ 46304 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 46304 [ 46304 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 1h [ 3600 ] 2h [ 7200 ]
            Worklog Id 51134 [ 51134 ]
            Permalink
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 31/May/17 12:06 PM
            • Time Spent:
              1h
               

              Report Scheduler changes.

            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 31/May/17 02:26 PM
            • Time Spent:
              1h
               


              Discussion on approach to fix the scheduler issue

            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 2h [ 7200 ] 3h [ 10800 ]
            Worklog Id 51321 [ 51321 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 31/May/17 09:30 PM
            • Time Spent:
              1h
               

              Discussion on approach to fix the scheduler issue

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 01/Jun/17 04:48 AM
            • Time Spent:
              1h
               

              Discussion on approach to fix the scheduler issue

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 3h [ 10800 ] 4h [ 14400 ]
            Worklog Id 51475 [ 51475 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 01/Jun/17 12:47 PM
            • Time Spent:
              1h
               

              Code go through

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 4h [ 14400 ] 5h [ 18000 ]
            Worklog Id 51709 [ 51709 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Time Spent 5h [ 18000 ] 6h [ 21600 ]
            Worklog Id 51786 [ 51786 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 03/Jun/17 04:12 AM
            • Time Spent:
              5h
               

              Code go through to understand implementation

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 6h [ 21600 ] 11h [ 39600 ]
            Worklog Id 52089 [ 52089 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Aditya Vishwakarma [ aditya.vishwakarma ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            Dev Due Date 09/Jun/2017
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 05/Jun/17 12:35 PM
            • Time Spent:
              1.5h
               

              Discussion with Prasanna Ma'am related to code go through
              Created documents for Development and testing Scenarios

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 11h [ 39600 ] 12.5h [ 45000 ]
            Worklog Id 52290 [ 52290 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 05/Jun/17 09:30 PM
            • Time Spent:
              0.5h
               

              Discussion on scheduler understanding and fix that will be done

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 06/Jun/17 02:01 PM
            • Time Spent:
              4h
               

              Service setup on local development machine
              Code changes

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 16.5h [ 59400 ]
            Worklog Id 52669 [ 52669 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 07/Jun/17 12:19 PM
            • Time Spent:
              6.75h
               

              Code changes & Debug service
              Unit testing

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 23.25h [ 83700 ]
            Worklog Id 52931 [ 52931 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 07/Jun/17 09:30 PM
            • Time Spent:
              1h
               

              Discussion on export scheduler service issue

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 09/Jun/17 12:00 AM
            • Time Spent:
              2h
               

              Test scenario go through and discussion

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 09/Jun/17 04:38 AM
            • Time Spent:
              6.5h
               

              Discussion on Implementation
              Review Testcases
              Add new Testcases
              Code changes in Impacted Area on Web application

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 23.25h [ 83700 ] 29.75h [ 107100 ]
            Worklog Id 53489 [ 53489 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 09/Jun/17 12:44 PM
            • Time Spent:
              6.25h
               

              Changes for Download delivered report popup
              Changes for View Calendar
              Unit testing
              Understand script generation utility to check in DB scripts (DDL, Data Queries)
              Discussion With @prasanna ma'am related to exception in Export schedule utility

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 29.75h [ 107100 ] 36h [ 129600 ]
            Worklog Id 53787 [ 53787 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Permalink
            aditya.vishwakarma Aditya Vishwakarma (Inactive) logged work - 09/Jun/17 12:56 PM
            • Time Spent:
              1h
               

              KT-Seesion for ReportTeam

            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 36h [ 129600 ] 37h [ 133200 ]
            Worklog Id 53815 [ 53815 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 09/Jun/2017 12/Jun/2017
            Original Estimate 0h [ 0 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 12/Jun/17 12:42 PM - edited
            • Time Spent:
              0.5h
               

              Code check in in trunk branch
              Discussion and Setup export scheduler utility on Prasanna Ma'am Machine

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 37h [ 133200 ] 37.5h [ 135000 ]
            Worklog Id 54125 [ 54125 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Worklog Id 54125 [ 54125 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 12/Jun/17 06:30 PM
            • Time Spent:
              2h
               

              Scheduler Setup on local for functionality review

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 13/Jun/17 12:39 PM
            • Time Spent:
              1.5h
               

              Code review comments discussion
              Code changes based on review comments

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 37.5h [ 135000 ] 39h [ 140400 ]
            Worklog Id 54614 [ 54614 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 12/Jun/2017 15/Jun/2017
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 13/Jun/17 06:00 PM - edited
            • Time Spent:
              2.5h
               

              Code review of Scheduler implementation - Changes suggested

            Hide
            Permalink
            jjsassy99 Jennifer Johnson (Inactive) added a comment -

            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

            Show
            jjsassy99 Jennifer Johnson (Inactive) added a comment - 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
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 14/Jun/17 12:45 PM
            • Time Spent:
              5h
               

              Code review changes
              Unit testing
              Check problem to SVN update/Commit/Cleanup, etc
              Code check in into trunck branch

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 39h [ 140400 ] 44h [ 158400 ]
            Worklog Id 55026 [ 55026 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 44h [ 158400 ] 44.5h [ 160200 ]
            Worklog Id 55314 [ 55314 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 44.5h [ 160200 ] 47h [ 169200 ]
            Worklog Id 55332 [ 55332 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 55332 [ 55332 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 47h [ 169200 ] 49h [ 176400 ]
            Worklog Id 55339 [ 55339 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 15/Jun/17 12:38 PM
            • Time Spent:
              2h
               

              Discussion an about Add new column to maintain status updated date-time.
              Code changes to maintain status updated date-time.
              unit testing
              Check-in trunk branch

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 49h [ 176400 ] 51h [ 183600 ]
            Worklog Id 55508 [ 55508 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 15/Jun/17 08:30 PM
            • Time Spent:
              1.5h
               

              Code review - Changes suggested related Datetimestamp update
              DDL changes for ScheduleStatusID column

            prasanna Prasanna Karlekar (Inactive) made changes -
            Developer Parmeshwar Jumbad [ parmeshwar.jumbade ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 15/Jun/2017 16/Jun/2017
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            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.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited 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.
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 16/Jun/2017
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment Affected File Names.txt [ 52354 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 16/Jun/17 12:23 PM
            • Time Spent:
              2h
               

              Code merge into LB branch and check-in in SVN.

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 51h [ 183600 ] 53h [ 190800 ]
            Worklog Id 55834 [ 55834 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 16/Jun/17 06:00 PM
            • Time Spent:
              2.5h
               

              Code Review and functionality Review

            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Meghana Joshi [ meghana.kulkarni ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 22/Jun/2017
            QA Meghana Joshi [ meghana.kulkarni ]
            Stage Due Date 21/Jun/17 [ 2017-06-21 ]
            Permalink
            meghana.joshi Meghana Joshi (Inactive) logged work - 19/Jun/17 12:15 PM
            • Time Spent:
              4h
               

              LB Testing

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Attachment LB_Report Schedule Status.jpg [ 52536 ]
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            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]

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - 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]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Meghana Joshi [ meghana.kulkarni ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Jun/17 01:26 PM
            • Time Spent:
              3.5h
               

              Discussion with QA related to testing scenarios and debug code for reported scenarios
              Restore latest soft-choice DB and Verified multiple scenarios on it.

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 53h [ 190800 ] 56.5h [ 203400 ]
            Worklog Id 56362 [ 56362 ]
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ] WT Sprint 31-Bugs [ 71 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Jun/17 10:30 PM
            • Time Spent:
              0.75h
               

              Report Scheduler -
              Scheduler not working
              Multiple entries getting set for previous report scheduler issue
              One report getting delivered twice

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 56.5h [ 203400 ] 60.5h [ 217800 ]
            Worklog Id 56522 [ 56522 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 60.5h [ 217800 ] 61.5h [ 221400 ]
            Worklog Id 56608 [ 56608 ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            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

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited 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
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 16/Jun/2017 20/Jun/2017
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 22/Jun/2017 27/Jun/2017
            Stage Due Date 21/Jun/17 [ 2017-06-21 ] 26/Jun/17 [ 2017-06-26 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Meghana Joshi [ meghana.kulkarni ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Permalink
            meghana.joshi Meghana Joshi (Inactive) logged work - 20/Jun/17 12:13 PM
            • Time Spent:
              1h
               

              Started Testing on LB for all scheduler type.

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 61.5h [ 221400 ] 62.5h [ 225000 ]
            Worklog Id 56746 [ 56746 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 20/Jun/17 12:43 PM
            • Time Spent:
              1h
               

              Discussion & changes related to handle schedule pickup functionality
              Commit change in Trunk and LB branch

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 62.5h [ 225000 ] 63.5h [ 228600 ]
            Worklog Id 56768 [ 56768 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 63.5h [ 228600 ] 65h [ 234000 ]
            Worklog Id 56817 [ 56817 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 65h [ 234000 ] 67.5h [ 243000 ]
            Worklog Id 56842 [ 56842 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 20/Jun/17 07:00 PM
            • Time Spent:
              1.5h
               

              Analysis and discussion on Report getting scheduled again in case of only once schedule
              Code review

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 67.5h [ 243000 ] 69.5h [ 250200 ]
            Worklog Id 57018 [ 57018 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 69.5h [ 250200 ] 70.25h [ 252900 ]
            Worklog Id 57024 [ 57024 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 70.25h [ 252900 ] 71.75h [ 258300 ]
            Worklog Id 57031 [ 57031 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Link This issue is duplicated by WT-9446 [ WT-9446 ]
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            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

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited 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
            Permalink
            meghana.joshi Meghana Joshi (Inactive) logged work - 21/Jun/17 11:54 AM
            • Time Spent:
              4h
               

              LB Testing

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 71.75h [ 258300 ] 75.75h [ 272700 ]
            Worklog Id 57106 [ 57106 ]
            Permalink
            meghana.joshi Meghana Joshi (Inactive) logged work - 21/Jun/17 12:04 PM
            • Time Spent:
              1h
               
              <No comment>
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 75.75h [ 272700 ] 76.75h [ 276300 ]
            Worklog Id 57462 [ 57462 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 27/Jun/2017 28/Jun/2017
            Stage Due Date 26/Jun/17 [ 2017-06-26 ] 27/Jun/17 [ 2017-06-27 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 28/Jun/2017
            Stage Due Date 27/Jun/17 [ 2017-06-27 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

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

            CC - Rakesh Roy Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Will update testing status ones WT-9223 jira testing is completed on LB. CC - Rakesh Roy Sachin Hingole
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 06/Jul/2017
            Stage Due Date 5/Jul/17 [ 2017-07-05 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 05/Jul/17 12:47 PM
            • Time Spent:
              3h
               

              Merge changes into Ui-Refresh branch
              Discussion related to log File size increase on Azure environment
              Check code and schedules for companies scheduler is running

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 76.75h [ 276300 ] 79.75h [ 287100 ]
            Worklog Id 60893 [ 60893 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 05/Jul/17 04:50 PM
            • Time Spent:
              0.75h
               

              Discussion on Report Logs getting logged on Azure Scheduler - Issue will get resolved with new code checkin

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 06/Jul/2017 11/Jul/2017
            Stage Due Date 5/Jul/17 [ 2017-07-05 ] 6/Jul/17 [ 2017-07-06 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            [~parmeshwar.jumbade] Prasanna Karlekar

            Testing of Jira blocked due to WT-10049

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited [~parmeshwar.jumbade] Prasanna Karlekar Testing of Jira blocked due to WT-10049 CC - Sachin Hingole
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Link This issue is blocked by WT-10049 [ WT-10049 ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

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

            CC- Prasanna Karlekar Sachin Hingole

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Please test this now. WT-10049 issue been resolved. CC- Prasanna Karlekar Sachin Hingole
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 06/Jul/17 12:46 PM
            • Time Spent:
              1.5h
               

              Code changes merge into stage branch along with parallel report changes

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 79.75h [ 287100 ] 81.25h [ 292500 ]
            Worklog Id 61187 [ 61187 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 11/Jul/2017
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            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

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited 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
            Permalink
            meghana.joshi Meghana Joshi (Inactive) logged work - 07/Jul/17 12:31 PM
            • Time Spent:
              4.5h
               

              Discussion about scheduler status with dev team
              Stage Testing

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 81.25h [ 292500 ] 85.75h [ 308700 ]
            Worklog Id 61625 [ 61625 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 07/Jul/17 12:39 PM
            • Time Spent:
              0.75h
               

              Discussion about scheduler run/status not updated problem with QA & Deployment team

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 85.75h [ 308700 ] 86.5h [ 311400 ]
            Worklog Id 61644 [ 61644 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 86.5h [ 311400 ] 87.25h [ 314100 ]
            Worklog Id 65417 [ 65417 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ] Low [ 16703 ]
            Bug Type Functional [ 15402 ]
            Code Review Date 20/Jun/2017 20/Jun/2017
            Dev Due Date 16/Jun/2017 16/Jun/2017
            Environment Production [ 10005 ]
            Stage Due Date 6/Jul/17 [ 2017-07-06 ] 6/Jul/17 [ 2017-07-06 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Stage Due Date 6/Jul/17 [ 2017-07-06 ] 12/Sep/17 [ 2017-09-12 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 19/Sep/2017
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            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

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - 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
            Permalink
            meghana.joshi Meghana Joshi (Inactive) logged work - 13/Sep/17 11:01 AM
            • Time Spent:
              1h
               

              Stage Testing

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 87.25h [ 314100 ] 88.25h [ 317700 ]
            Worklog Id 78450 [ 78450 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Meghana Joshi [ meghana.kulkarni ] Raymond Williams [ raywill ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Sep/17 12:43 PM
            • Time Spent:
              1h
               

              Internal discussion about script execution on production (on companies moved from stage to production)
              File merge into production branch

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 88.25h [ 317700 ] 89.25h [ 321300 ]
            Worklog Id 79761 [ 79761 ]
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Raymond Williams Please verify this issue and confirm.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Raymond Williams Please verify this issue and confirm.
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Aditya Vishwakarma (Inactive) made transition -
            New Request Open
            		15h 46m 1
            Parmeshwar Jumbad (Inactive) made transition -
            Open In Development
            		30d 3m 1
            Meghana Joshi (Inactive) made transition -
            In LB Testing Reopen in Local
            		3d 2h 20m 1
            Meghana Joshi (Inactive) made transition -
            Reopen in Local In Development
            		22h 29m 1
            Meghana Joshi (Inactive) made transition -
            In Development In LB Testing
            		6d 21h 47m 2
            Meghana Joshi (Inactive) made transition -
            In LB Testing Stage Testing
            		15d 21h 12m 1
            Meghana Joshi (Inactive) made transition -
            Stage Testing In Production Testing
            		74d 23h 32m 1
            Meghana Joshi (Inactive) made transition -
            In Production Testing Production Complete
            		4h 28m 1

              People

              Assignee:
              Raywill Raymond Williams (Inactive)
              Reporter:
              Raywill Raymond Williams (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 89.25h
                  89.25h