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

            Activity

            Hide
            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
            Hide
            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
            Hide
            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.
            Hide
            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
            Hide
            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.
            Hide
            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.
            Hide
            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
            Hide
            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
            Hide
            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

              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