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

              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