WORKTERRAProject Type: software

WORKTERRA

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

CVHP - Import failure

    Details

    • Type: Support Activity
    • Status: Closed
    • 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:
      CVHP
    • Module:
      BenAdmin
    • Severity:
      Simple

      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
      Amit Thorve

        Attachments

          Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. WT-12252 Effective Date format issue for Employee Import

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            nwalker Nathaniel Cornejo-Walker (Inactive) created issue -
            amitthorve Amit Thorve (Inactive) made changes -
            Field Original Value New Value
            Priority Medium [ 3 ] High [ 2 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited

            Hi Nathaniel Cornejo-Walker,

            we have observed this issues on verious companies. It mainly comes for the templates that uses YYYYMMDD date format.
            We have separate ticket WT-12252 opened for this. We are working on this and will provide fix ASAP.

            Keeping this on hold till we fix WT-12252

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited Hi Nathaniel Cornejo-Walker , we have observed this issues on verious companies. It mainly comes for the templates that uses YYYYMMDD date format. We have separate ticket WT-12252 opened for this. We are working on this and will provide fix ASAP. Keeping this on hold till we fix WT-12252
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue duplicates WT-12252 [ WT-12252 ]
            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 ]
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Link This issue is cloned by WT-12465 [ WT-12465 ]
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Link This issue is cloned by WT-12465 [ WT-12465 ]
            Hide
            Permalink
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

            cc Abhay Patil

            Show
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - cc Abhay Patil
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Snehal Katkar [ snehal.katkar ]
            Hide
            Permalink
            abhay.patil Abhay Patil (Inactive) added a comment -

            Cindy Wibbing - we don't have EDI assignment for this company. CC Amit Thorve Van Nguyen

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - Cindy Wibbing - we don't have EDI assignment for this company. CC Amit Thorve Van Nguyen
            abhay.patil Abhay Patil (Inactive) made changes -
            EDI Analyst 1 Cindy Wibbing [ cindy.wibbing ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status On Hold [ 10507 ] In Progress [ 3 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Closing this as the bug WT-12252 is fixed and deployed on production

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Closing this as the bug WT-12252 is fixed and deployed on production
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Progress
            		56m 11s 1
            Jaideep Vinchurkar (Inactive) made transition -
            In Progress On Hold
            		13s 1
            Jaideep Vinchurkar (Inactive) made transition -
            On Hold In Progress
            		21d 15h 5m 1
            Jaideep Vinchurkar (Inactive) made transition -
            In Progress Resolved
            		1m 28s 1
            Jaideep Vinchurkar (Inactive) made transition -
            Resolved Closed
            		5s 1

              People

              Assignee:
              snehal.katkar Snehal Katkar (Inactive)
              Reporter:
              nwalker Nathaniel Cornejo-Walker (Inactive)
              Account Executive:
              lisa davison
              EDI Analyst 1:
              Cindy Wibbing (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: