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
            meghana.joshi Meghana Joshi (Inactive) created issue -
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-8262 [ WT-8262 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Suraj Sokasane [ suraj.sokasane ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] snehal katkar [ snehal.katkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 26/Jul/2017
            Developer snehal katkar [ snehal.katkar ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Dev Due Date 26/Jul/2017 27/Jul/2017
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 6h [ 21600 ]
            Worklog Id 67357 [ 67357 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 6h [ 21600 ] 7h [ 25200 ]
            Worklog Id 67401 [ 67401 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Meghana Joshi [ meghana.kulkarni ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Meghana Joshi [ meghana.kulkarni ] Jayshree Nagpure [ jayshree.nagpure ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ] WT Sprint 34-Bugs [ 79 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Ankur Deshpande [ ankur.deshpande ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ] Unresolved [ 10200 ]
            Status Rejected [ 10004 ] Reopened [ 4 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 27/Jul/2017 11/Aug/2017
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Review Date 11/Aug/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Developer snehal katkar [ snehal.katkar ] Ankur Deshpande [ ankur.deshpande ]
            QA Jayshree Nagpure [ jayshree.nagpure ]
            Original Estimate 8h [ 28800 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Reopened [ 4 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 7h [ 25200 ] 7.5h [ 27000 ]
            Worklog Id 71150 [ 71150 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Jayshree Nagpure [ jayshree.nagpure ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Ankur Deshpande [ ankur.deshpande ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Jayshree Nagpure [ jayshree.nagpure ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment IncorrectEmpID.jpg [ 58762 ]
            Attachment IncorrectEmpID.txt [ 58763 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 8.5h [ 30600 ]
            Worklog Id 71821 [ 71821 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Ankur Deshpande [ ankur.deshpande ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Jayshree Nagpure [ jayshree.nagpure ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 9.5h [ 34200 ]
            Worklog Id 72225 [ 72225 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 9.5h [ 34200 ] 13h [ 46800 ]
            Worklog Id 72314 [ 72314 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 13h [ 46800 ] 17.5h [ 63000 ]
            Worklog Id 72320 [ 72320 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 17.5h [ 63000 ] 19.5h [ 70200 ]
            Worklog Id 72388 [ 72388 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Code Review Date 11/Aug/2017 11/Aug/2017
            Dev Due Date 11/Aug/2017 11/Aug/2017
            Production Due Date 14/Sep/2017
            Stage Due Date 11/Sep/17 [ 2017-09-11 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]

              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