WORKTERRAProject Type: software

WORKTERRA

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

Import Backend routiune failures are not getting logged on Schedular

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Good To Have
    • Sprint:
      WT Sprint 31 - Enhancement

      Description

      When any exception is getting thrown from app server, it is getting caught and logged at controller app tier.
      For import export scheduled service, we give directly call to business logic and hence error is not getting logged.
      We have to log the error explicitly from import export scheduler service.

      ImportServiceLog needs to be formatted properly.
      IO Exception cannot be converted.

        Attachments

          Issue Links

          causes

          Support Activity - Support Activity WT-4508 Terminated Employees with Current Elections

          • Critical - This problem will block progress.
          • Resolved

            Activity

            Ascending order - Click to sort in descending order
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) created issue -
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Field Original Value New Value
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Developer Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Priority Medium [ 3 ] Highest [ 1 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Summary Import export schedule should have error logging Import Backend routiune failures are not getting logged
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Issue Importance Good To Have [ 11802 ] Must Have [ 11800 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Deployed test patch for additional logs

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Deployed test patch for additional logs
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue causes WT-4508 [ WT-4508 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Summary Import Backend routiune failures are not getting logged Import Backend routiune failures are not getting logged on Schedular
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Priority Highest [ 1 ] Low [ 4 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            A temporary solution is given for logging. But we need something Concrete solution for this

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - A temporary solution is given for logging. But we need something Concrete solution for this
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Development Backlog(10205)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Environment Production [ 10005 ]
            Issue Type Bug [ 1 ] Enhancement [ 4 ]
            Status Open [ 1 ] In Development [ 10007 ]
            Workflow WT_Defects [ 23310 ] WT_Features [ 24984 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Issue Importance Must Have [ 11800 ] Good To Have [ 11802 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Description When any exception is getting thrown from app server, it is getting caught and logged at controller app tier.
            For import export scheduled service, we give directly call to business logic and hence error is not getting logged.
            We have to log the error explicitly from import export scheduler service.             		When any exception is getting thrown from app server, it is getting caught and logged at controller app tier.
            For import export scheduled service, we give directly call to business logic and hence error is not getting logged.
            We have to log the error explicitly from import export scheduler service.

            ImportServiceLog needs to be formatted properly.
            IO Exception cannot be converted.
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Vishal,

            As discussed, please log every possible and important information about exception into the Log file.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Vishal, As discussed, please log every possible and important information about exception into the Log file.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Vishal Bajad [ vishal.bajad ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Suraj Sokasane [ suraj.sokasane ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 12/Jun/17 02:02 PM
            • Time Spent:
              2h
               

              Exception handling analysis and service setup.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 54191 [ 54191 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 27/Jun/2017
            Sprint WT Sprint 31 - Enhancement [ 64 ]
            Original Estimate 14h [ 50400 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 23/Jun/17 04:53 PM
            • Time Spent:
              6h
               

              Service setup
              debug
              discussion with Vijayendra

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Dev Due Date 27/Jun/2017 30/Jun/2017
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 29/Jun/17 03:25 PM
            • Time Spent:
              4h
               

              Analysis, coding and unit testing

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 2h [ 7200 ] 6h [ 21600 ]
            Worklog Id 59553 [ 59553 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 6h [ 21600 ] 12h [ 43200 ]
            Worklog Id 59610 [ 59610 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Jayshree Nagpure [ jayshree.nagpure ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Suraj Sokasane,

            Verified on LB
            Company - FDU

            For scheduler import log is not generating.

            Hence re-opening this jira.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Suraj Sokasane , Verified on LB Company - FDU For scheduler import log is not generating. Hence re-opening this jira. Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Suraj Sokasane [ suraj.sokasane ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 05/Jul/17 01:03 PM
            • Time Spent:
              2h
               

              Discussion and LB testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 12h [ 43200 ] 14h [ 50400 ]
            Worklog Id 60913 [ 60913 ]
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            This is configuration issue. Service is picking up global template and not any from FDU. I'll look into this whenever time permits.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - This is configuration issue. Service is picking up global template and not any from FDU. I'll look into this whenever time permits.
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 05/Jul/17 04:55 PM
            • Time Spent:
              0.5h
               
              <No comment>
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 14h [ 50400 ] 14.5h [ 52200 ]
            Worklog Id 61007 [ 61007 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 06/Jul/17 08:49 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            There were global templates scheduled for Import. Which was causing error and not letting pickup next template. I've removed those templates. Please check now.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - There were global templates scheduled for Import. Which was causing error and not letting pickup next template. I've removed those templates. Please check now.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 14.5h [ 52200 ] 15h [ 54000 ]
            Worklog Id 61066 [ 61066 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Jayshree Nagpure [ jayshree.nagpure ]
            vijays Vijay Siddha (Inactive) made changes -
            Priority Low [ 4 ] High [ 2 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on LB
            Company - FDU

            Verified scenario for back-end routine failure and import successfully

            Following is the error message for backend routine failure :
            Company Level Import : FDU
            Template Name : EMPIMPORT
            DateTime : 7/10/2017 10:56:42 AM
            Status : Error occured while import.
            Error Source : ExecuteImportDTS.AutomatedImportFile>ExecuteImportDTS.DownloadFromSFTPServer
            Error Message : No connection could be made because the target machine actively refused it

            Following is the message for import successful :
            Company Level Import : FDU
            Template Name : EMPIMPORT
            DateTime : 7/10/2017 12:29:00 PM
            Status : Imported successfully.
            Total no of record(s) : 1
            Records imported Successfully : 1
            Bad record(s) : 0

            Working fine

            Marking item state as Ready for stage

            Thanks,
            Jayshree

            CC : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on LB Company - FDU Verified scenario for back-end routine failure and import successfully Following is the error message for backend routine failure : Company Level Import : FDU Template Name : EMPIMPORT DateTime : 7/10/2017 10:56:42 AM Status : Error occured while import. Error Source : ExecuteImportDTS.AutomatedImportFile>ExecuteImportDTS.DownloadFromSFTPServer Error Message : No connection could be made because the target machine actively refused it Following is the message for import successful : Company Level Import : FDU Template Name : EMPIMPORT DateTime : 7/10/2017 12:29:00 PM Status : Imported successfully. Total no of record(s) : 1 Records imported Successfully : 1 Bad record(s) : 0 Working fine Marking item state as Ready for stage Thanks, Jayshree CC : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            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)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 10/Jul/17 01:19 PM
            • Time Spent:
              2.5h
               

              LB testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 15h [ 54000 ] 17.5h [ 63000 ]
            Worklog Id 62094 [ 62094 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Suraj Sokasane,

            Verified on Stage
            Company - Austin for hspl

            Working fine

            Import Fail notification :

            Company Level Import : Austin For HSPL
            Template Name : Emmpppschedule
            DateTime : 7/13/2017 5:21:31 AM
            Status : Error occured while import.
            Error Source : ExecuteImportDTS.AutomatedImportFile->ExecuteImportDTS.UploadFileOnFTPServer
            Error Message : 530 User wt17 cannot log in.

            Import Done notification :

            Company Level Import : Austin For HSPL
            Template Name : Emmpppschedule
            DateTime : 7/13/2017 5:31:31 AM
            Status : Imported successfully.
            Total no of record(s) : 1
            Records imported Successfully : 0
            Bad record(s) : 1

            Marking as ready for production

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Suraj Sokasane , Verified on Stage Company - Austin for hspl Working fine Import Fail notification : Company Level Import : Austin For HSPL Template Name : Emmpppschedule DateTime : 7/13/2017 5:21:31 AM Status : Error occured while import. Error Source : ExecuteImportDTS.AutomatedImportFile->ExecuteImportDTS.UploadFileOnFTPServer Error Message : 530 User wt17 cannot log in. Import Done notification : Company Level Import : Austin For HSPL Template Name : Emmpppschedule DateTime : 7/13/2017 5:31:31 AM Status : Imported successfully. Total no of record(s) : 1 Records imported Successfully : 0 Bad record(s) : 1 Marking as ready for production
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            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)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 13/Jul/17 12:56 PM
            • Time Spent:
              1.5h
               

              Stage testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 17.5h [ 63000 ] 19h [ 68400 ]
            Worklog Id 63123 [ 63123 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on production on city of denton for hspl
            working fine

            Thanks,
            Jayshree

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on production on city of denton for hspl working fine Thanks, Jayshree
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 19/Jul/17 12:57 PM
            • Time Spent:
              1h
               

              Production testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 19h [ 68400 ] 20h [ 72000 ]
            Worklog Id 64725 [ 64725 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 19/Jul/17 01:55 PM
            • Time Spent:
              1h
               

              discussions, import log findings

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 20h [ 72000 ] 21h [ 75600 ]
            Worklog Id 64761 [ 64761 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment ImportSchedulertestcases.xls [ 57572 ]
            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Development
            		26d 18h 22m 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            		272d 5h 52m 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		7d 23h 51m 1
            Jayshree Nagpure (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		10s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for Stage Stage Testing
            		9s 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		5d 23h 54m 1
            Jayshree Nagpure (Inactive) made transition -
            Pending for Production Approval Approved for production
            		3s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for production In Production Testing
            		4s 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            		26s 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Developer:
              Suraj Sokasane (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 14h Original Estimate - 14h
                  14h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 21h
                  21h