-
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
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
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