-
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
-
| Field | Original Value | New Value |
|---|---|---|
| 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 :- !Flag.png|thumbnail! Actual results : - Current year flag showing status - no Expected Results : -Current year flag should show status yes after OE started till due date. CC-[~rakeshr][~gaurav.sodani][~hrishikesh.deshpande][~aniruddha.dev] |
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 :- !Flag.png|thumbnail! Actual results : - Current year flag showing status - no Expected Results : -Current year flag should show status yes after OE started till due date. CC-[~rakeshr][~gaurav.sodani][~hrishikesh.deshpande][~aniruddha.dev] |
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 2.5h [ 9000 ] | |
| Worklog Id | 77892 [ 77892 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Attachment | screenshot-1.png [ 61119 ] |
Hi Indra,
As discussed, We need to set email to get fired whenever SQL Jobs fails.
Let us know you need more details.
Thanks.
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Indraprakash Tiwari [ indraprakash ] |
| Bug Severity | Blocker [ 16700 ] | Medium [ 16702 ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Export(10110) |
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.
-
- Time Spent:
- 5h
-
Failure email notification setup
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
| Time Spent | 2.5h [ 9000 ] | 3h [ 10800 ] |
| Worklog Id | 82354 [ 82354 ] |
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.
| Assignee | Indraprakash Tiwari [ indraprakash ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
| Time Spent | 3h [ 10800 ] | 8h [ 28800 ] |
| Worklog Id | 83109 [ 83109 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Original Estimate | 0h [ 0 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Resolution | Unresolved [ 10200 ] | |
| Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) |
| Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
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.
| Time Spent | 8h [ 28800 ] | 11h [ 39600 ] |
| Worklog Id | 83857 [ 83857 ] |
| Attachment | M1.png [ 63812 ] |
| Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
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.
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
| Time Spent | 11h [ 39600 ] | 12h [ 43200 ] |
| Worklog Id | 84210 [ 84210 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Swapnil EksambekarVinayak Kulkarni Is this re-open on stage?
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
Verified this issue on Stage,
Working as expected.
Ready for Production deployment.
| Time Spent | 12h [ 43200 ] | 14h [ 50400 ] |
| Worklog Id | 85227 [ 85227 ] |
As discussed with Ganesh and Swapnil. Closing this.
Ganesh SadawarteSwapnil EksambekarAniruddha DevHrishikesh DeshpandeVinayak Kulkarni
| Issue Type | Bug [ 1 ] | Support Activity [ 10301 ] |
| Status | Stage Testing [ 10201 ] | Open [ 1 ] |
| Support Task Type | Customization [ 11204 ] | |
| Workflow | WT_Defects [ 51706 ] | WT_Support [ 55280 ] |
| Resolution | Unresolved [ 10200 ] | Done [ 10000 ] |
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Time Spent | 14h [ 50400 ] | 15.5h [ 55800 ] |
| Worklog Id | 88589 [ 88589 ] |
| Environment_New | Stage [ 18443 ] |
Gaurav Sodani (Inactive)
made changes -
| Company | All Clients/Multiple Clients [ 18434 ] | |
| Environment_Old | Stage [ 10004 ] | |
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Status | Resolved [ 5 ] | Open [ 1 ] |
| Support Task Type | Customization [ 11204 ] | |
| Workflow | WT_Support [ 55280 ] | WT_Defects [ 59018 ] |
Gaurav Sodani (Inactive)
made changes -
| Approval status | Need approval for production [ 18456 ] | |
| Production Due Date | 09/Dec/2017 |
Gaurav Sodani (Inactive)
made changes -
| Labels | OE_dashboard |
| Status | Open [ 1 ] | In Development [ 10007 ] |
Keeping the status and item state in sync
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Gaurav Sodani (Inactive)
made changes -
| Production Due Date | 09/Dec/2017 |
| Transition | Time In Source Status | Execution Times |
|---|
|
3d 3h 32m | 1 |
|
12h 11m | 1 |
|
1d 2m | 1 |
|
16s | 1 |
Gaurav Sodani (Inactive)
made transition
-
|
44d 3h 21m | 1 |
|
4d 2h | 2 |
|
28d 4h 40m | 3 |
|
3d 3h 32m | 3 |
|
11s | 1 |
|
15s | 1 |
|
37s | 1 |
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.