WORKTERRAProject Type: software

WORKTERRA

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

OE dashboard->Automated service for current year flag is not working for Group template-mix company

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed

      Description

      Browser Name : Chrome, IE.11
      Test Environment Name: STAGE
      User details : Verified with qaexport

      When Group template is created by different company templates , Current year flag is not changing its status.

      Test Data Scenario as below:-

      Company selected:-

      *ASML FOR HSPL *
      City of Plano For HSPL

      Group level template :-

      Test_oedb_mix

      OE start date - 09/09/2017
      OE end date - 09/10/2017

      Attached screenshot :-

      Actual results : - Current year flag showing status - no
      Expected Results : -Current year flag should show status yes after OE started till due date.

      CC-Rakesh RoyGaurav SodaniHrishikesh DeshpandeAniruddha Dev

        Attachments

        1. Flag.png
          Flag.png
          79 kB
        2. M1.png
          M1.png
          178 kB
        3. screenshot-1.png
          screenshot-1.png
          126 kB

          Issue Links

          is caused by

          Enhancement - An improvement or enhancement to an existing feature or task. WT-10491 Automated service/job to flip current year flag.

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Swapnil Eksambekar

            SQL job which set current year flag was failed on 09/09, see below snap,

            We have executed job manually for 09/09, please verify data. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Swapnil Eksambekar SQL job which set current year flag was failed on 09/09, see below snap, We have executed job manually for 09/09, please verify data. Thanks.
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Indra,

            As discussed, We need to set email to get fired whenever SQL Jobs fails.
            Let us know you need more details.

            Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Indra, As discussed, We need to set email to get fired whenever SQL Jobs fails. Let us know you need more details. Thanks.
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Indraprakash Tiwari

            Any updates on this?

            Gaurav Sodani Satya

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Indraprakash Tiwari Any updates on this? Gaurav Sodani Satya
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi Indraprakash Tiwari

            Could you please let us know what is the update on this

            Regards
            Gaurav

            CC:SatyaBharti SatputeVinayak Kulkarni

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi Indraprakash Tiwari Could you please let us know what is the update on this Regards Gaurav CC: Satya Bharti Satpute Vinayak Kulkarni
            Hide
            Permalink
            indraprakash Indraprakash Tiwari (Inactive) added a comment -

            Hi Vinayak Kulkarni,

            Can you please provide job list which you want to include for email flag? we require two working days to finish this task after getting list.

            CC:Bharti Satpute Satya Gaurav Sodani

            Show
            indraprakash Indraprakash Tiwari (Inactive) added a comment - Hi Vinayak Kulkarni , Can you please provide job list which you want to include for email flag? we require two working days to finish this task after getting list. CC: Bharti Satpute Satya Gaurav Sodani
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Indraprakash Tiwari and Rushikesh Dattatray Bane

            Below are list of job related to Export, on which we need email to be sent on failure.

            Export_SetCurrentYearFlagToNoFromOpenEnrollmentDashboard
            Export_SetCurrentYearFlagToYesFromOpenEnrollmentDashboard
            Export_ShiftScheduleStartDateFromOpenEnrollmentDashboard
            Job_SetExportFlag_Cursor

            From email: sa@ebsbenefits.com
            To email: vinayak.kulkarni@harbingergroup.com,ganesh.sadawarte@harbingergroup.com,rajendra.pawar@harbingergroup.com,rakesh.shahane@harbingergroup.com

            Subject: Production JOB failure for <JOB_NAME>

            Body: <JOB_NAME> failed on production on <today's date>

            Let us know if you need more information on this. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Indraprakash Tiwari and Rushikesh Dattatray Bane Below are list of job related to Export, on which we need email to be sent on failure. Export_SetCurrentYearFlagToNoFromOpenEnrollmentDashboard Export_SetCurrentYearFlagToYesFromOpenEnrollmentDashboard Export_ShiftScheduleStartDateFromOpenEnrollmentDashboard Job_SetExportFlag_Cursor From email: sa@ebsbenefits.com To email: vinayak.kulkarni@harbingergroup.com,ganesh.sadawarte@harbingergroup.com,rajendra.pawar@harbingergroup.com,rakesh.shahane@harbingergroup.com Subject: Production JOB failure for <JOB_NAME> Body: <JOB_NAME> failed on production on <today's date> Let us know if you need more information on this. Thanks.
            Hide
            Permalink
            rushikesh.bane Rushikesh Dattatray Bane (Inactive) added a comment -

            Hi Vinayak Kulkarni,

            I have done setup for receiving failure email on specified jobs(listed below) in your previous comment :
            Export_SetCurrentYearFlagToNoFromOpenEnrollmentDashboard
            Export_SetCurrentYearFlagToYesFromOpenEnrollmentDashboard
            Export_ShiftScheduleStartDateFromOpenEnrollmentDashboard
            Job_SetExportFlag_Cursor

            Let me know if any queries.

            Regards,
            Rushikesh

            CC - Indraprakash Tiwari

            Show
            rushikesh.bane Rushikesh Dattatray Bane (Inactive) added a comment - Hi Vinayak Kulkarni , I have done setup for receiving failure email on specified jobs(listed below) in your previous comment : Export_SetCurrentYearFlagToNoFromOpenEnrollmentDashboard Export_SetCurrentYearFlagToYesFromOpenEnrollmentDashboard Export_ShiftScheduleStartDateFromOpenEnrollmentDashboard Job_SetExportFlag_Cursor Let me know if any queries. Regards, Rushikesh CC - Indraprakash Tiwari
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            This issue occurred due to OE dashbaord's SQL job was failed.

            Now we have added email notification for such job failures so that we can re-execute job in such instances, this should not occur again. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - This issue occurred due to OE dashbaord's SQL job was failed. Now we have added email notification for such job failures so that we can re-execute job in such instances, this should not occur again. Thanks.
            Hide
            Permalink
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited

            Hello Vinayak Kulkarni,
            Verified this issue on Stage for Mix company group template,It is reproducing same issue on STAGE.
            Created group template named as newm as 2 templates on Test_swap(Company) as m1 and m2 (Company templates)
            and 2 templates on TIBCO for hspl.
            on 10/09/2017 it should suppose to change its current year flag to YES,But it is showing wrong results.

            Attached screenshot :-
            Please reassign to me this,when it gets fixed.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyGaurav Sodani

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited Hello Vinayak Kulkarni , Verified this issue on Stage for Mix company group template,It is reproducing same issue on STAGE. Created group template named as newm as 2 templates on Test_swap(Company) as m1 and m2 (Company templates) and 2 templates on TIBCO for hspl. on 10/09/2017 it should suppose to change its current year flag to YES,But it is showing wrong results. Attached screenshot :- Please reassign to me this,when it gets fixed. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy Gaurav Sodani
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Swapnil,

            SQL Jobs were disabled and did not run since 09/29/2017, this is why flags were not flipped automatically. We have enabled it and executed for today, It should run going forward without issues.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Swapnil, SQL Jobs were disabled and did not run since 09/29/2017, this is why flags were not flipped automatically. We have enabled it and executed for today, It should run going forward without issues.
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Swapnil EksambekarVinayak Kulkarni Is this re-open on stage?

            Hrishikesh Deshpande

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Swapnil Eksambekar Vinayak Kulkarni Is this re-open on stage? Hrishikesh Deshpande
            Hide
            Permalink
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on Stage,
            Working as expected.

            Ready for Production deployment.

            CC-Aniruddha DevRakesh RoyHrishikesh DeshpandeGaurav Sodani

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on Stage, Working as expected. Ready for Production deployment. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande Gaurav Sodani
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            As discussed with Ganesh and Swapnil. Closing this.

            Ganesh SadawarteSwapnil EksambekarAniruddha DevHrishikesh DeshpandeVinayak Kulkarni

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - As discussed with Ganesh and Swapnil. Closing this. Ganesh Sadawarte Swapnil Eksambekar Aniruddha Dev Hrishikesh Deshpande Vinayak Kulkarni
            Hide
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Keeping the status and item state in sync

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Keeping the status and item state in sync

              People

              Assignee:
              swapnil.eksambekar Swapnil Eksambekar (Inactive)
              Reporter:
              swapnil.eksambekar Swapnil Eksambekar (Inactive)
              Developer:
              Vinayak Kulkarni (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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