-
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
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.
- is caused by
-
WT-10491 Automated service/job to flip current year flag.
-
- Closed
-
Hi Indra,
As discussed, We need to set email to get fired whenever SQL Jobs fails.
Let us know you need more details.
Thanks.
Could you please let us know what is the update on this
Regards
Gaurav
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 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.
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 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.
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
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.
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.
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.
Swapnil EksambekarVinayak Kulkarni Is this re-open on stage?
Verified this issue on Stage,
Working as expected.
Ready for Production deployment.
As discussed with Ganesh and Swapnil. Closing this.
Ganesh SadawarteSwapnil EksambekarAniruddha DevHrishikesh DeshpandeVinayak Kulkarni
Keeping the status and item state in sync
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.