Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-4436

OE Dashboard > Current Year election flag changed to YES not reflecting on OE Dashboard

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Partner
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have
    • Browser:
      Google Chrome

      Description

      HI Vinayak Kulkarni,

      Found this issue after Azure build after 4:00 PM today . Ran service to change current year flag to YES.

      Flags successfully changed from NO to YES on all templates.

      Result : Flag changed at company level but not reflected at OE Dashboard. To repro this issue check the group template.

      New COD Group for OE Dashboard_1

      Also check New Mix Group for OE Dashboard_1 for inconsistent flag flipping

      PFA screenshot of also the OE dashboard as well as Company Level Template

        Attachments

          Issue Links

            Activity

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Link This issue is caused by WT-9806 [ WT-9806 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description HI [~Vinayak.Kulkarni],

            Found this issue after Azure build after 4:00 PM . Ran service to change current year flag to YES.


            Result : Flag changed at company level but not reflected at OE Dashboard. To repro this issue check the group template.

            *New COD Group for OE Dashboard_1*

            PFA screenshot of also the OE dashboard as well as Company Level Template
            HI [~Vinayak.Kulkarni],

            Found this issue after Azure build after 4:00 PM today . Ran service to change current year flag to YES.

            Flags successfully changed from NO to YES on all templates.


            Result : Flag changed at company level but not reflected at OE Dashboard. To repro this issue check the group template.

            *New COD Group for OE Dashboard_1*

            PFA screenshot of also the OE dashboard as well as Company Level Template
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description HI [~Vinayak.Kulkarni],

            Found this issue after Azure build after 4:00 PM today . Ran service to change current year flag to YES.

            Flags successfully changed from NO to YES on all templates.


            Result : Flag changed at company level but not reflected at OE Dashboard. To repro this issue check the group template.

            *New COD Group for OE Dashboard_1*

            PFA screenshot of also the OE dashboard as well as Company Level Template
            HI [~Vinayak.Kulkarni],

            Found this issue after Azure build after 4:00 PM today . Ran service to change current year flag to YES.

            Flags successfully changed from NO to YES on all templates.


            Result : Flag changed at company level but not reflected at OE Dashboard. To repro this issue check the group template.

            *New COD Group for OE Dashboard_1*

            Also check *New Mix Group for OE Dashboard_1* for inconsistent flag flipping

            PFA screenshot of also the OE dashboard as well as Company Level Template
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Cause: Trigger which updates data to dashboard was capturing change for only one template even if SQL JOBS updates current year flag to multiple template. This is why it was not reflecting at dashboard.

            Correction: We have updated trigger to capture changes for multiple templates. This trigger is executed on CAISO for HSPL and City of Durham for HSPL as of now and will go for all companies under next scheduled patch.

            Files affected: trgUpdImportExportSettings_TemplateInformationExportOEDashboardInsert.Trigger.sql

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Cause: Trigger which updates data to dashboard was capturing change for only one template even if SQL JOBS updates current year flag to multiple template. This is why it was not reflecting at dashboard. Correction: We have updated trigger to capture changes for multiple templates. This trigger is executed on CAISO for HSPL and City of Durham for HSPL as of now and will go for all companies under next scheduled patch. Files affected: trgUpdImportExportSettings_TemplateInformationExportOEDashboardInsert.Trigger.sql
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Aniruddha Dev [ aniruddha.dev ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 14/Jul/17 11:36 AM
            • Time Spent:
              2.5h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 14/Jul/17 01:54 PM
            • Time Spent:
              3h
               

              Verified this fix along with the enhancement scenarios on group and company level templates

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ]
            Original Estimate 4h [ 14400 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 1.5h [ 5400 ]
            Time Spent 2.5h [ 9000 ]
            Worklog Id 63675 [ 63675 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 2.5h [ 9000 ] 5.5h [ 19800 ]
            Worklog Id 67397 [ 67397 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Link This issue is caused by WT-10491 [ WT-10491 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Swapnil Eksambekar [ swapnil.eksambekar ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Key WT-10133 NF-4436
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 7.5h [ 27000 ]
            Worklog Id 110607 [ 110607 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 2h [ 7200 ]
            Time Spent 7.5h [ 27000 ] 5.5h [ 19800 ]
            Worklog Id 110607 [ 110607 ]
            Worklog Time Spent 2h [ 7200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In LB Testing [ 10200 ] Resolution Setting [ 11616 ]
            Transition Time In Source Status Execution Times
            Vinayak Kulkarni (Inactive) made transition -
            Open In Development
            22h 2m 1
            Swapnil Eksambekar (Inactive) made transition -
            In Development In LB Testing
            6d 3h 50m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Resolution Setting
            315d 8h 15m 1

              People

              Assignee:
              swapnil.eksambekar Swapnil Eksambekar (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Time Spent - 5.5h Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - 5.5h Remaining Estimate - 2h
                  5.5h