Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-11955

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

    Details

    • 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

      Attachments

      1. 11955_Test cases.xls
        13 kB
      2. ElCamino_Clander.png
        ElCamino_Clander.png
        21 kB
      3. Import Export Scheduler Status.png
        Import Export Scheduler Status.png
        29 kB
      4. Mail_LB.png
        Mail_LB.png
        97 kB
      5. mail_stgae.png
        mail_stgae.png
        146 kB
      6. screenshot-1.png
        screenshot-1.png
        239 kB

        Issue Links

          Activity

          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jaideep, Please check this, Let me know if you have any questions. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jaideep, Please check this, Let me know if you have any questions. Thanks.
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Damion M Velasquez,

          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.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Damion M Velasquez , 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.
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Hi Damion M Velasquez,

          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

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Damion M Velasquez , 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
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          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

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - 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
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          As of now, we are resolving this by marking can not reproduce, because scheduler has picked the file for this week.

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - As of now, we are resolving this by marking can not reproduce, because scheduler has picked the file for this week.
          Hide
          satyap Satya added a comment -

          Reopening this to find exact root cause.

          Show
          satyap Satya added a comment - Reopening this to find exact root cause.
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          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

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - 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
          Hide
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

          Verified on LB.
          Getting notification when scheduler was unexpectedly stopped.
          PFA,

          Ready for stage.

          Thanks,
          Sanjana Jadhav

          CC: Prasad Pise Jayshree Nagpure Rakesh Roy

          Show
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on LB. Getting notification when scheduler was unexpectedly stopped. PFA, Ready for stage. Thanks, Sanjana Jadhav CC: Prasad Pise Jayshree Nagpure Rakesh Roy
          Hide
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

          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

          Show
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - 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
          Hide
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

          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

          Show
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - 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

            People

            Assignee:
            Damion.Velasquez Damion M Velasquez
            Reporter:
            Damion.Velasquez Damion M Velasquez
            Account Executive:
            lisa davison
            EDI Analyst 1:
            Damion M Velasquez
            Developer:
            Suraj Sokasane (Inactive)
            QA:
            Sanjana Jadhav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Dev Due Date:
              Pre-Prod Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 10h Original Estimate - 10h
                10h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 47.4h
                47.4h