WORKTERRAProject Type: software

WORKTERRA

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

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-8262 Importing Waived Benefit Type data

          • Low - Minor problem or easily worked around.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            will be taken while working on WT-9291

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - will be taken while working on WT-9291
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Issue was occurring because database did not contained entered value. Hence, marking it as non-reproducible

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Issue was occurring because database did not contained entered value. Hence, marking it as non-reproducible
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Reopening this, we need to fix this issue. If we not found employee from given data in file. The record should go to bad.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Reopening this, we need to fix this issue. If we not found employee from given data in file. The record should go to bad.
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            hi Ankur Deshpande,

            Could you please share 3C's

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - hi Ankur Deshpande , Could you please share 3C's Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

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

            Cause : Check for employee existence was not checked before actual waive operation.

            Correction : Before waive import, EMPID is checked for existence in the system. If employee is not present the record is sent to bad.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Concern : Waived Import - Import Failed if employee ID is exist in template Cause : Check for employee existence was not checked before actual waive operation. Correction : Before waive import, EMPID is checked for existence in the system. If employee is not present the record is sent to bad. Regards, Ankur
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Ankur Deshpande,

            Verified on LB
            Company - QA FDU

            For correct emp its working fine
            For incorrect emp id import is failing

            PFA error log and screen shot IncorrectEmpID.txt

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Ankur Deshpande , Verified on LB Company - QA FDU For correct emp its working fine For incorrect emp id import is failing PFA error log and screen shot IncorrectEmpID.txt Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Verified on LB
            Company - QA FDU

            For Correct emp ID - Import successful
            For Incorrect emp id - File wents to bad "Employee does not exists" (Expected)
            Also verified for employee SSN - Working fine

            Marking item state as LB QA on hold, as main ticket WT-8262 is on hold because some issue related to enhancement as Re-opened .

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Verified on LB Company - QA FDU For Correct emp ID - Import successful For Incorrect emp id - File wents to bad "Employee does not exists" (Expected) Also verified for employee SSN - Working fine Marking item state as LB QA on hold, as main ticket WT-8262 is on hold because some issue related to enhancement as Re-opened . Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Marked item state as Ready for stage, as changes are been reverted.
            As main enhancement changes are still not deployed on stage

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Marked item state as Ready for stage, as changes are been reverted. As main enhancement changes are still not deployed on stage cc : Rakesh Roy Prasad Pise
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on stage
            Company - City of bellevue for hspl

            For Correct emp ID - Import successful
            For Incorrect emp id - File wents to bad "Employee does not exists" (Expected)
            Also verified for employee SSN - Working fine

            Marking item state as Ready for Production

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on stage Company - City of bellevue for hspl For Correct emp ID - Import successful For Incorrect emp id - File wents to bad "Employee does not exists" (Expected) Also verified for employee SSN - Working fine Marking item state as Ready for Production
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Working fine

            Marking item state as Production complete

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Working fine Marking item state as Production complete

              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