-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Type:UI
-
Bug Severity:Medium
-
Module:BenAdmin - Import
-
Reported by:EDI
-
Company:El Camino Hospital
-
Item State:Production Complete - Closed
-
Sprint:WT- Sprint 43
- relates to
-
-
- Rejected
-
| Field | Original Value | New Value |
|---|---|---|
| Attachment | screenshot-1.png [ 66687 ] |
| Summary | El Camino Import Files 11/1/2017 did not load Calendar doesnt show an import is scheduled but all oter days prior and after do Screenshot provided | El Camino Import Files 11/1/2017 did not load Calendar doesnt show an import is scheduled but all other days prior and after do Screenshot provided |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Import(10111) |
| Environment | Production [ 10005 ] | |
| Environment_New | Production [ 18442 ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Suraj Sokasane [ suraj.sokasane ] |
The Import feed was skipped and not executed on 01/11/2017. So it's not showing in the calendar. We are looking into possible cause. We'll update you soon on same.
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Component/s | BenAdmin [ 10000 ] | |
| Developer | Suraj Sokasane [ suraj.sokasane ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | |
| Remaining Estimate | 10h [ 36000 ] | |
| Original Estimate | 10h [ 36000 ] |
| Attachment | ElCamino_Clander.png [ 67323 ] |
We found that scheduler service was stopped on 11/01/2017 at 10.30 AM PST to 11/2/2017 12 AM PST. This is system failure. Since the failure we have 8 days and we do not have any system logs about exception.
Today, schedule picked all files. Please refer 
| Root Cause | Third Party [ 18431 ] |
Concern: Import files are not seen in calendar.
Cause: Scheduler service was stopped (by system exception) for a day.
Correction: As of now, we do not have logs for this. We are checking with our technical team if we can increase log size of windows to find out the root cause
| Resolution | Cannot Reproduce [ 5 ] | |
| Status | In Development [ 10007 ] | Rejected [ 10004 ] |
As of now, we are resolving this by marking can not reproduce, because scheduler has picked the file for this week.
| Assignee | Suraj Sokasane [ suraj.sokasane ] | Damion Velasquez [ damion.velasquez ] |
| Resolution | Cannot Reproduce [ 5 ] | Unresolved [ 10200 ] |
| Status | Rejected [ 10004 ] | Reopened [ 4 ] |
| Assignee | Damion Velasquez [ damion.velasquez ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
| Status | Reopened [ 4 ] | In Development [ 10007 ] |
Reopening this to find exact root cause.
| Remaining Estimate | 10h [ 36000 ] | 5h [ 18000 ] |
| Time Spent | 5h [ 18000 ] | |
| Worklog Id | 90215 [ 90215 ] |
-
- Time Spent:
- 7h
-
Import skip script creation.
discussion meeting
discussion with Ganesh
Testing script
| Remaining Estimate | 5h [ 18000 ] | 0h [ 0 ] |
| Time Spent | 5h [ 18000 ] | 12h [ 43200 ] |
| Worklog Id | 90243 [ 90243 ] |
| Time Spent | 12h [ 43200 ] | 15h [ 54000 ] |
| Worklog Id | 90271 [ 90271 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: Development Backlog(10205) |
Gaurav Sodani (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Development Backlog(10205) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
| Time Spent | 15h [ 54000 ] | 20h [ 72000 ] |
| Worklog Id | 93913 [ 93913 ] |
| Time Spent | 20h [ 72000 ] | 26.5h [ 95400 ] |
| Worklog Id | 93947 [ 93947 ] |
| Time Spent | 26.5h [ 95400 ] | 30.5h [ 109800 ] |
| Worklog Id | 93948 [ 93948 ] |
| QA | Cindy Wibbing [ cindy.wibbing ] | Jayshree Nagpure [ jayshree.nagpure ] |
| QA Estimates | 4 |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT- Sprint 43 [ 98 ] |
| Dev Due Date | 24/Jan/2018 | |
| Dev Estimates | 16 |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
| Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| QA | Jayshree Nagpure [ jayshree.nagpure ] | Sanjana Jadhav [ sanjana.jadhav ] |
| QA Estimates | 4 | 8 |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
-
- Time Spent:
- 2.7h
-
Analysis
Test case writing
Internal discussion
| Time Spent | 30.5h [ 109800 ] | 33.2h [ 119520 ] |
| Worklog Id | 101827 [ 101827 ] |
Jayshree Nagpure (Inactive)
logged work - 24/Jan/18 01:08 PM -
- Time Spent:
- 0.5h
-
Scenarios explanation to sanjana
Jayshree Nagpure (Inactive)
made changes -
| Time Spent | 33.2h [ 119520 ] | 33.7h [ 121320 ] |
| Worklog Id | 101847 [ 101847 ] |
| Time Spent | 33.7h [ 121320 ] | 37.2h [ 133920 ] |
| Worklog Id | 101888 [ 101888 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Attachment | Import Export Scheduler Status.png [ 72295 ] |
HI Satya,
As per jaideep comment scheduler was stopped by system exception not due to any code issue and previously we don't get any notification when scheduler was unexpectedly stopped.
Now We have added schedule task Import Export Scheduler Status on 75 server. This will run in every 15 minutes and checked import export scheduler service status, if service is stopped or pause it will send email notification to users which are added for this job notification. Please find below snap.
This utility is place into N:\Harbinger\ExportScheduledTasks on 75 server.
CC-Vinayak Kulkarni,Suraj Sokasane
Thanks,
Ganesh
| Code Review Date | 19/Jan/2018 | |
| Code Reviewed By | Vinalyak Kulkarni [ 12100 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Sanjana Jadhav [ sanjana.jadhav ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
-
- Time Spent:
- 1h
-
Analysis
Internal discussion
Filezilla learning
| Time Spent | 37.2h [ 133920 ] | 38.2h [ 137520 ] |
| Worklog Id | 102642 [ 102642 ] |
Jayshree Nagpure (Inactive)
logged work - 31/Jan/18 05:16 AM -
- Time Spent:
- 1h
-
Help to sanjana to understand task and execute
Jayshree Nagpure (Inactive)
made changes -
| Time Spent | 38.2h [ 137520 ] | 39.2h [ 141120 ] |
| Worklog Id | 102734 [ 102734 ] |
| Attachment | 11955_Test cases.xls [ 72588 ] |
| Attachment | Mail_LB.png [ 72592 ] |
Verified on LB.
Getting notification when scheduler was unexpectedly stopped.
PFA,
Ready for stage.
Thanks,
Sanjana Jadhav
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
-
- Time Spent:
- 0.5h
-
Internal discussion
Testing
| Time Spent | 39.2h [ 141120 ] | 39.7h [ 142920 ] |
| Worklog Id | 102774 [ 102774 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Stage Due Date | 2/Feb/18 [ 2018-02-02 ] |
-
- Time Spent:
- 2h
-
Testing
Internal discussion
| Time Spent | 39.7h [ 142920 ] | 41.7h [ 150120 ] |
| Worklog Id | 103343 [ 103343 ] |
-
- Time Spent:
- 1h
-
Testing
Internal discussion
| Time Spent | 41.7h [ 150120 ] | 42.7h [ 153720 ] |
| Worklog Id | 103486 [ 103486 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Labels | Manual_import |
| Attachment | mail_stgae.png [ 72918 ] |
Verified on stage.
Getting notification when scheduler was unexpectedly stopped.
Please refer attachment for same:
Error occurred while import.
Filezilla credentials:
Username: WT17
Password: @CCe$$_1007
Refer below error log:
============================================================
Company Level Import : Austin For HSPL
Template Name : test_imp
DateTime : 2/5/2018 10:23:54 PM
Status : Error occured while import.
Error Source : ExecuteImportDTS.AutomatedImportFile->ExecuteImportDTS.UploadFileOnFTPServer
Error Message : 530 User WT17 cannot log in.
============================================================
As discussed with Ganesh Sadawarte marked this jira as ready for production. If same issue will occur on production, we will take action accordingly.
Thanks,
Sanjana Jadhav
CC: Hrishikesh Deshpande Prasad Pise Rakesh Roy Jayshree Nagpure Suraj Sokasane Ganesh Sadawarte Jaideep Vinchurkar
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
-
- Time Spent:
- 1.7h
-
Testing
Internal discussion
| Time Spent | 42.7h [ 153720 ] | 44.4h [ 159840 ] |
| Worklog Id | 103530 [ 103530 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Time Spent | 44.4h [ 159840 ] | 45.4h [ 163440 ] |
| Worklog Id | 104595 [ 104595 ] |
Verified on production.
Company: CVHP For HSPL
Verified all attached test cases.Import done successfully.
Working as expected.
Thanks,
Sanjana Jadhav
CC: Prasad Pise Hrishikesh Deshpande Rakesh Roy Ganesh Sadawarte Jayshree Nagpure Suraj Sokasane
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Assignee | Sanjana Jadhav [ sanjana.jadhav ] | Damion Velasquez [ damion.velasquez ] |
| Time Spent | 45.4h [ 163440 ] | 47.4h [ 170640 ] |
| Worklog Id | 104760 [ 104760 ] |
| Resolution | Unresolved [ 10200 ] | Done [ 10000 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Resolution | Done [ 10000 ] | |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
6d 12h 2m | 1 |
|
9h 18m | 1 |
|
9m 27s | 1 |
|
47m | 1 |
|
81d 12h 11m | 1 |
|
3d 2h 44m | 1 |
|
11d 6h 32m | 1 |
|
1d 23h 11m | 1 |
|
3s | 1 |
Hi Jaideep, Please check this, Let me know if you have any questions. Thanks.