WORKTERRAProject Type: software

WORKTERRA

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

El Dorado - Import failure

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Load
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      El Dorado
    • Module:
      BenAdmin - Import
    • Severity:
      Simple

      Description

      Template Name:_Workterra Employee Load Ongoing-Actives
      i am getting an import failure when i manually load the file.

      cc
      Amit Thorve

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          nwalker Nathaniel Cornejo-Walker (Inactive) created issue -
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Field Original Value New Value
          Link This issue clones WT-12449 [ WT-12449 ]
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Account Executive lisa davison [ lisadavison ] Deborah Mascot [ deborah.mascot@ebsbenefits.com ]
          Hide
          Permalink
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Hi Nathaniel Cornejo-Walker,

          This is exactly same as WT-12449 which in turn will get fixed in WT-12252.
          You may face similar issues on other companies as well. Please do not open new ticket, instead add error log in information in this or WT-12449.

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Nathaniel Cornejo-Walker , This is exactly same as WT-12449 which in turn will get fixed in WT-12252 . You may face similar issues on other companies as well. Please do not open new ticket, instead add error log in information in this or WT-12449 .
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Status In Progress [ 3 ] On Hold [ 10507 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Import(10111)
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Description Template Name: _Employee_Data_On_Going
          Date Time: Nov 28 2017 5:17PM
          Feed Status: Import Process Failure
          Error Log:
          "Import FailureExecuteImportDTS.AutomatedImportFile->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.GetNewlyCreatedEmployeeIDForUsernameCreation Conversion from string ""20171119"" to type 'Date' is not valid.##1. Import Failure.
          "

          [~jaideep.vinchurkar] This is the second week in a row that we have received an import failure and the client is concerned.
          please review the error log to see what has changed and how to fix this.
          thanks
          cc
          [~amitthorve]           		Template Name:_Workterra Employee Load Ongoing-Actives
          i am getting an import failure when i manually load the file.


          cc
          [~amitthorve]
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Link This issue clones WT-12449 [ WT-12449 ]
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Company CVHP [ 10412 ] El Dorado [ 10457 ]
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Attachment Ebs_Actives.zip [ 68914 ]
          Hide
          Permalink
          nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

          thanks Jairdeep, I am sure it is similar, but i need his file loaded for the client. i will email the the password.

          Show
          nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - thanks Jairdeep, I am sure it is similar, but i need his file loaded for the client. i will email the the password.
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Status On Hold [ 10507 ] In Progress [ 3 ]
          Hide
          Permalink
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited

          Hi Nathaniel Cornejo-Walker,

          I have checked the error from back end, it is the same as WT-12449. I have loaded the file you have sent.
          PS: There are 9 bad records which are records of terminated employees

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited Hi Nathaniel Cornejo-Walker , I have checked the error from back end, it is the same as WT-12449 . I have loaded the file you have sent. PS: There are 9 bad records which are records of terminated employees
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Developer Jaideep Vinchurkar [ jaideep.vinchurkar ]
          Remaining Estimate 4h [ 14400 ]
          Original Estimate 4h [ 14400 ]
          Permalink
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 30/Nov/17 06:34 PM
          • Time Spent:
            2h
             
            <No comment>
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Nathaniel Cornejo-Walker [ nwalker ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 2h [ 7200 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 94129 [ 94129 ]
          Transition Time In Source Status Execution Times
          Jaideep Vinchurkar (Inactive) made transition -
          Open In Progress
          		18m 52s 1
          Jaideep Vinchurkar (Inactive) made transition -
          In Progress On Hold
          		3s 1
          Jaideep Vinchurkar (Inactive) made transition -
          On Hold In Progress
          		21m 40s 1
          Jaideep Vinchurkar (Inactive) made transition -
          In Progress Resolved
          		54m 37s 1

            People

            Assignee:
            nwalker Nathaniel Cornejo-Walker (Inactive)
            Reporter:
            nwalker Nathaniel Cornejo-Walker (Inactive)
            Account Executive:
            Deborah Mascot (Inactive)
            Developer:
            Jaideep Vinchurkar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4h
                4h
                Remaining:
                Time Spent - 2h Remaining Estimate - 2h
                2h
                Logged:
                Time Spent - 2h Remaining Estimate - 2h
                2h