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

Waived Import - Import Failed if employee ID is exist in template

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 34-Bugs

      Description

      Precondition :
      1) Create one benefit level template which having following fields

      Employee ID
      Benefit Name
      Effective Date
      Termination Date

      Replication steps :
      1) Navigate to manual import export Page
      2) Import Data

      Issue : Import Failed

      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ExecuteAllQueries
      ErrorMessage: Incorrect syntax near ','. INSERT INTO Employee_Enrollment_WaivedBenefitTypes(EmployeeID,BenefitTypeID,EnrollmentModeID, IsCompanyUser,EffectiveDate,UserID) Values( , 2 ,13,0, '05/01/2017',1);

      CC - Sachin Hingole

        Attachments

          Issue Links

            Activity

            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Development
            42d 3h 32m 1
            Suraj Sokasane (Inactive) made transition -
            In Development Rejected
            53d 20h 31m 1
            Jaideep Vinchurkar (Inactive) made transition -
            Rejected Reopen
            10d 19h 19m 1
            Jaideep Vinchurkar (Inactive) made transition -
            Reopen In Development
            4h 31m 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Reopen in Local
            16h 11m 1
            Jaideep Vinchurkar (Inactive) made transition -
            Reopen in Local In Development
            9h 6m 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            5d 18h 34m 2
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Stage Testing
            26d 6h 21m 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing In Production Testing
            1d 45m 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            8s 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              meghana.joshi Meghana Joshi (Inactive)
              Developer:
              Ankur Deshpande (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 19.5h
                  19.5h