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

            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

              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