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

Online Enrollment System - Import Error Notification - Import failed - JEDUNN

    Details

    • Type: Bug
    • Status: In Development
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Company:
      JE Dunn
    • Item State:
      Development - On Hold

      Description

      Dear User,

      Following Are Error Logged While Importing Data.

      Company: JE Dunn

      Template: Employee_Ongoing_Terms

      ErrorMessage: 1. Import Failure.

      5/30/2017 - Import failure after successful import
      5/22/2017 - Import failure after successful import (JE Dunn)
      5/10/2017 - Import failure after successful import

        Attachments

          Issue Links

            Activity

            vishal.bajad Vishal Bajad (Inactive) created issue -
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi Jaideep Vinchurkar ,

            We have scanned error log with reported error, with initial analysis we found error log as

            "Import FailureExecuteImportDTS.AutomatedImportFile -> ExecuteImportDTS.ImportNotificationThroughEmail ->ExecuteImportDTS.GetSenderMailAddress Object reference not set to an instance of an object.##1. Import Failure."

            Its shows, Error raised on while sending Import success notification after successful import, this error was not reproduced locally or on production.

            CC : Satya Vijay Siddha Rakesh Roy Suraj Sokasane

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Jaideep Vinchurkar , We have scanned error log with reported error, with initial analysis we found error log as "Import FailureExecuteImportDTS.AutomatedImportFile -> ExecuteImportDTS.ImportNotificationThroughEmail ->ExecuteImportDTS.GetSenderMailAddress Object reference not set to an instance of an object.##1. Import Failure." Its shows, Error raised on while sending Import success notification after successful import, this error was not reproduced locally or on production. CC : Satya Vijay Siddha Rakesh Roy Suraj Sokasane
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            vishal.bajad Vishal Bajad (Inactive) logged work - 18/May/17 01:30 PM
            • Time Spent:
              2h
               
              <No comment>
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 46789 [ 46789 ]
            vishal.bajad Vishal Bajad (Inactive) logged work - 19/May/17 01:42 PM
            • Time Spent:
              1.5h
               
              <No comment>
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 2h [ 7200 ] 3.5h [ 12600 ]
            Worklog Id 47267 [ 47267 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Issue Type Support Activity [ 10301 ] Bug [ 1 ]
            Support Task Type Customization [ 11204 ]
            Workflow WT_Support [ 41875 ] WT_Defects [ 42309 ]
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Another Import was failed on JE Dunn on 05/22/2017 with same error. We are planning to deploy logs on production for this issue.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Another Import was failed on JE Dunn on 05/22/2017 with same error. We are planning to deploy logs on production for this issue.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Dev Due Date 02/Jun/2017
            Original Estimate 0h [ 0 ]
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 31/May/17 04:32 AM
            • Time Spent:
              1.5h
               

              Failure analysis and reply to client.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 3.5h [ 12600 ] 5h [ 18000 ]
            Worklog Id 50726 [ 50726 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 01/Jun/17 05:58 PM
            • Time Spent:
              2h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Developer Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 5h [ 18000 ] 7h [ 25200 ]
            Worklog Id 52447 [ 52447 ]
            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)
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Description Dear User,

            Following Are Error Logged While Importing Data.

            Company: JE Dunn

            Template: Employee_Ongoing_Terms

            ErrorMessage: 1. Import Failure.
            Dear User,

            Following Are Error Logged While Importing Data.

            Company: JE Dunn

            Template: Employee_Ongoing_Terms

            ErrorMessage: 1. Import Failure.


            5/30/2017 - Import failure after successful import
            5/22/2017 - Import failure after successful import (JE Dunn)
            5/10/2017 - Import failure after successful import
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Link This issue relates to WT-9782 [ WT-9782 ]
            Hide
            Van.Nguyen Van Nguyen (Inactive) added a comment -

            Hello Suraj Sokasane and Jaideep Vinchurkar,

            Groendyke would like to know once this import failure issue has been resolved and have asked for it to be expedited. I don't know if you need to get our third party vendor Clare Computers or even Verizon involved to see what is going on.

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - Hello Suraj Sokasane and Jaideep Vinchurkar , Groendyke would like to know once this import failure issue has been resolved and have asked for it to be expedited. I don't know if you need to get our third party vendor Clare Computers or even Verizon involved to see what is going on.
            Hide
            Van.Nguyen Van Nguyen (Inactive) added a comment -

            Hello Vinayak Kulkarni, I am escalating this issue to you since the client, Groendyke, is upset and wants an explanation right away.

            Show
            Van.Nguyen Van Nguyen (Inactive) added a comment - Hello Vinayak Kulkarni , I am escalating this issue to you since the client, Groendyke, is upset and wants an explanation right away.
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Vinayak Kulkarni [ vinayak.kulkarni ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Link This issue relates to CT-1891 [ CT-1891 ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Satya Vijay Siddha Please check this on priority.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Satya Vijay Siddha Please check this on priority.
            Hide
            satyap Satya added a comment -

            Hi Suraj,

            Can you please share details on this Import failure & our mitigation plan?

            Regards,
            Satya Prakash

            Cc: Jaideep Vinchurkar Vijay Siddha

            Show
            satyap Satya added a comment - Hi Suraj, Can you please share details on this Import failure & our mitigation plan? Regards, Satya Prakash Cc: Jaideep Vinchurkar Vijay Siddha
            satyap Satya made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Suraj Sokasane [ suraj.sokasane ]
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Van Nguyen,

            We were aware of all the failures above. We receive emails as well as we weekly monitor the failures to see if there's any error.
            We are bit struggling with our error logging and not able to judge the cause of failure. Also, from the incomplete error message we received, we tried to reproduce the issue but could not. We are also working on improving the logs under WT-4723. There are few more options like database logging we will try out.

            Thanks for your patience. We'll keep updating about our progress.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Van Nguyen , We were aware of all the failures above. We receive emails as well as we weekly monitor the failures to see if there's any error. We are bit struggling with our error logging and not able to judge the cause of failure. Also, from the incomplete error message we received, we tried to reproduce the issue but could not. We are also working on improving the logs under WT-4723 . There are few more options like database logging we will try out. Thanks for your patience. We'll keep updating about our progress.
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 02/Jun/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ]
            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: On Hold(10207)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ]
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 31/Jul/17 11:59 AM
            • Time Spent:
              4h
               

              Three failures found on JE Dunn. Reason still not found.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 7h [ 25200 ] 11h [ 39600 ]
            Worklog Id 68287 [ 68287 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Labels Manual_import
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Vishal Bajad (Inactive) made transition -
            Open In Progress
            1m 19s 1
            Vishal Bajad (Inactive) made transition -
            In Progress Open
            1m 4s 1
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Development
            14d 23h 19m 1

              People

              Assignee:
              suraj.sokasane Suraj Sokasane (Inactive)
              Reporter:
              vishal.bajad Vishal Bajad (Inactive)
              Developer:
              Suraj Sokasane (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 11h
                  11h