[WT-9333] Waived Import - Import Failed if employee ID is exist in template - Workterra Jira

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

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

IncorrectEmpID.jpg
204 kB
16/Aug/17 01:32 PM
IncorrectEmpID.txt
0.6 kB
16/Aug/17 01:32 PM

Issue Links

relates to

WT-8262 Importing Waived Benefit Type data

Production Complete

Activity

Ascending order - Click to sort in descending order

Meghana Joshi (Inactive) created issue - 26/Apr/17 09:52 AM

Meghana Joshi (Inactive) made changes - 26/Apr/17 09:52 AM

Field	Original Value	New Value
Link		This issue relates to ~~WT-8262~~ [ ~~WT-8262~~ ]

Meghana Joshi (Inactive) made changes - 26/Apr/17 09:52 AM

Assignee

Vijay Siddha [ vijays ]

Suraj Sokasane [ suraj.sokasane ]

Jaideep Vinchurkar (Inactive) made changes - 07/Jun/17 01:25 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Hide

Permalink

Jaideep Vinchurkar (Inactive) added a comment - 07/Jun/17 01:25 PM

will be taken while working on ~~WT-9291~~

Show

Jaideep Vinchurkar (Inactive) added a comment - 07/Jun/17 01:25 PM will be taken while working on WT-9291

Jaideep Vinchurkar (Inactive) made changes - 07/Jun/17 01:25 PM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Gaurav Sodani (Inactive) made changes - 14/Jul/17 11:41 AM

Sprint

WT Sprint 33-Bugs [ 77 ]

Jaideep Vinchurkar (Inactive) made changes - 19/Jul/17 07:39 AM

Assignee

Suraj Sokasane [ suraj.sokasane ]

snehal katkar [ snehal.katkar ]

Jaideep Vinchurkar (Inactive) made changes - 19/Jul/17 07:44 AM

Dev Due Date		26/Jul/2017
Developer		snehal katkar [ snehal.katkar ]

Gaurav Sodani (Inactive) made changes - 26/Jul/17 09:35 AM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Gaurav Sodani (Inactive) made changes - 26/Jul/17 09:35 AM

Dev Due Date

26/Jul/2017

27/Jul/2017

Snehal Katkar (Inactive) made changes - 27/Jul/17 01:16 PM

Remaining Estimate		0h [ 0 ]
Time Spent		6h [ 21600 ]
Worklog Id		67357 [ 67357 ]

Permalink

Suraj Sokasane (Inactive) logged work - 27/Jul/17 01:59 PM

Time Spent:

1h

Discussion with Snehal

Suraj Sokasane (Inactive) made changes - 27/Jul/17 02:00 PM

Time Spent	6h [ 21600 ]	7h [ 25200 ]
Worklog Id		67401 [ 67401 ]

Permalink

Snehal Katkar (Inactive) logged work - 28/Jul/17 01:15 AM

Time Spent:

6h

Analysis

Snehal Katkar (Inactive) made changes - 28/Jul/17 01:50 PM

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 (Inactive) made changes - 28/Jul/17 01:51 PM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Hide

Permalink

Snehal Katkar (Inactive) added a comment - 28/Jul/17 01:52 PM

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

Show

Snehal Katkar (Inactive) added a comment - 28/Jul/17 01:52 PM Issue was occurring because database did not contained entered value. Hence, marking it as non-reproducible

Snehal Katkar (Inactive) made changes - 31/Jul/17 09:30 AM

Assignee

snehal katkar [ snehal.katkar ]

Meghana Joshi [ meghana.kulkarni ]

Meghana Joshi (Inactive) made changes - 31/Jul/17 09:35 AM

Assignee

Meghana Joshi [ meghana.kulkarni ]

Jayshree Nagpure [ jayshree.nagpure ]

Suraj Sokasane (Inactive) made changes - 31/Jul/17 09:52 AM

Sprint

WT Sprint 33-Bugs [ 77 ]

WT Sprint 34-Bugs [ 79 ]

Suraj Sokasane (Inactive) made changes - 31/Jul/17 09:56 AM

Resolution		Cannot Reproduce [ 5 ]
Status	In Development [ 10007 ]	Rejected [ 10004 ]

Ankur Deshpande (Inactive) made changes - 11/Aug/17 04:47 AM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Ankur Deshpande [ ankur.deshpande ]

Jaideep Vinchurkar (Inactive) made changes - 11/Aug/17 05:16 AM

Resolution	Cannot Reproduce [ 5 ]	Unresolved [ 10200 ]
Status	Rejected [ 10004 ]	Reopened [ 4 ]

Jaideep Vinchurkar (Inactive) made changes - 11/Aug/17 09:47 AM

Dev Due Date

27/Jul/2017

11/Aug/2017

Permalink

Jaideep Vinchurkar (Inactive) logged work - 11/Aug/17 09:48 AM

Time Spent:

0.5h

discussion and code review

Jaideep Vinchurkar (Inactive) made changes - 11/Aug/17 09:48 AM

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 (Inactive) made changes - 11/Aug/17 09:48 AM

Status

Reopened [ 4 ]

In Development [ 10007 ]

Jaideep Vinchurkar (Inactive) made changes - 11/Aug/17 09:48 AM

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 (Inactive) made changes - 11/Aug/17 09:48 AM

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 (Inactive) made changes - 11/Aug/17 09:49 AM

Time Spent	7h [ 25200 ]	7.5h [ 27000 ]
Worklog Id		71150 [ 71150 ]

Hide

Permalink

Jaideep Vinchurkar (Inactive) added a comment - 11/Aug/17 09:50 AM

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 (Inactive) added a comment - 11/Aug/17 09:50 AM Reopening this, we need to fix this issue. If we not found employee from given data in file. The record should go to bad.

Permalink

Ankur Deshpande (Inactive) logged work - 12/Aug/17 04:05 AM

Time Spent:

4.5h

<No comment>

Khandu Kshirsagar (Inactive) made changes - 14/Aug/17 05:55 AM

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 (Inactive) made changes - 14/Aug/17 06:15 AM

Assignee

Ankur Deshpande [ ankur.deshpande ]

Jayshree Nagpure [ jayshree.nagpure ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 16/Aug/17 06:30 AM

hi Ankur Deshpande,

Could you please share 3C's

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Show

Jayshree Nagpure (Inactive) added a comment - 16/Aug/17 06:30 AM hi Ankur Deshpande , Could you please share 3C's Thanks, Jayshree cc : Rakesh Roy Prasad Pise

Jayshree Nagpure (Inactive) made changes - 16/Aug/17 06:33 AM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Ankur Deshpande [ ankur.deshpande ]

Hide

Permalink

Ankur Deshpande (Inactive) added a comment - 16/Aug/17 08:44 AM

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 (Inactive) added a comment - 16/Aug/17 08:44 AM 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

Ankur Deshpande (Inactive) made changes - 16/Aug/17 08:44 AM

Assignee

Ankur Deshpande [ ankur.deshpande ]

Jayshree Nagpure [ jayshree.nagpure ]

Jayshree Nagpure (Inactive) made changes - 16/Aug/17 12:10 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jayshree Nagpure (Inactive) made changes - 16/Aug/17 01:32 PM

Attachment		IncorrectEmpID.jpg [ 58762 ]
Attachment		IncorrectEmpID.txt [ 58763 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 16/Aug/17 01:32 PM

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 (Inactive) added a comment - 16/Aug/17 01:32 PM 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

Jayshree Nagpure (Inactive) made changes - 16/Aug/17 01:32 PM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Permalink

Jayshree Nagpure (Inactive) logged work - 16/Aug/17 02:03 PM

Time Spent:

1h

Testing on LB

Jayshree Nagpure (Inactive) made changes - 16/Aug/17 02:03 PM

Time Spent	7.5h [ 27000 ]	8.5h [ 30600 ]
Worklog Id		71821 [ 71821 ]

Permalink

Ankur Deshpande (Inactive) logged work - 17/Aug/17 03:53 AM

Time Spent:

3.5h

<No comment>

Jayshree Nagpure (Inactive) made changes - 17/Aug/17 04:22 AM

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 (Inactive) made changes - 17/Aug/17 04:22 AM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Ankur Deshpande [ ankur.deshpande ]

Jayshree Nagpure (Inactive) made changes - 17/Aug/17 04:22 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Khandu Kshirsagar (Inactive) made changes - 17/Aug/17 10:52 AM

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 (Inactive) made changes - 17/Aug/17 10:56 AM

Assignee

Ankur Deshpande [ ankur.deshpande ]

Jayshree Nagpure [ jayshree.nagpure ]

Jaideep Vinchurkar (Inactive) made changes - 17/Aug/17 01:28 PM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Permalink

Jaideep Vinchurkar (Inactive) logged work - 17/Aug/17 01:29 PM

Time Spent:

1h

Import issues dicussions

Jaideep Vinchurkar (Inactive) made changes - 17/Aug/17 01:30 PM

Time Spent	8.5h [ 30600 ]	9.5h [ 34200 ]
Worklog Id		72225 [ 72225 ]

Ankur Deshpande (Inactive) made changes - 18/Aug/17 03:53 AM

Time Spent	9.5h [ 34200 ]	13h [ 46800 ]
Worklog Id		72314 [ 72314 ]

Ankur Deshpande (Inactive) made changes - 18/Aug/17 04:06 AM

Time Spent	13h [ 46800 ]	17.5h [ 63000 ]
Worklog Id		72320 [ 72320 ]

Jayshree Nagpure (Inactive) made changes - 18/Aug/17 05:40 AM

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 (Inactive) made changes - 18/Aug/17 05:40 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 18/Aug/17 05:44 AM - 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 (Inactive) added a comment - 18/Aug/17 05:44 AM - 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

Jayshree Nagpure (Inactive) made changes - 18/Aug/17 05:45 AM

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 (Inactive) made changes - 18/Aug/17 06:45 AM

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 (Inactive) made changes - 18/Aug/17 06:48 AM

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 (Inactive) made changes - 18/Aug/17 06:48 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Permalink

Jayshree Nagpure (Inactive) logged work - 18/Aug/17 07:27 AM

Time Spent:

2h

Testing on Local

Jayshree Nagpure (Inactive) made changes - 18/Aug/17 07:27 AM

Time Spent	17.5h [ 63000 ]	19.5h [ 70200 ]
Worklog Id		72388 [ 72388 ]

Rakesh Roy (Inactive) made changes - 30/Aug/17 05:08 AM

Bug Severity

Medium [ 16702 ]

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 01:54 PM

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 (Inactive) made changes - 07/Sep/17 12:48 PM

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 (Inactive) made changes - 11/Sep/17 07:09 AM

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 (Inactive) made changes - 11/Sep/17 12:11 PM

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)

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 11/Sep/17 12:14 PM

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 (Inactive) added a comment - 11/Sep/17 12:14 PM 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

Snehal Katkar (Inactive) made changes - 12/Sep/17 11:50 AM

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 (Inactive) made changes - 12/Sep/17 12:14 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 13/Sep/17 12:02 PM

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 (Inactive) added a comment - 13/Sep/17 12:02 PM 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

Jayshree Nagpure (Inactive) made changes - 13/Sep/17 12:02 PM

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 (Inactive) made changes - 13/Sep/17 12:02 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Jayshree Nagpure (Inactive) made changes - 14/Sep/17 12:47 PM

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 (Inactive) made changes - 14/Sep/17 12:47 PM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 14/Sep/17 12:48 PM

Verified on Production
Working fine

Marking item state as Production complete

Show

Jayshree Nagpure (Inactive) added a comment - 14/Sep/17 12:48 PM Verified on Production Working fine Marking item state as Production complete

Jayshree Nagpure (Inactive) made changes - 14/Sep/17 12:48 PM

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 (Inactive) made changes - 14/Sep/17 12:48 PM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Jayshree Nagpure (Inactive) made changes - 14/Sep/17 12:48 PM

Resolution	Unresolved [ 10200 ]	Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Satya made changes - 04/Nov/17 06:19 AM

Environment_New

LB [ 18444 ]

Transition	Time In Source Status	Execution Times

Jaideep Vinchurkar (Inactive) made transition - 07/Jun/17 01:25 PM

Open

In Development

42d 3h 32m

Suraj Sokasane (Inactive) made transition - 31/Jul/17 09:56 AM

In Development

Rejected

53d 20h 31m

Jaideep Vinchurkar (Inactive) made transition - 11/Aug/17 05:16 AM

Rejected

Reopen

10d 19h 19m

Jaideep Vinchurkar (Inactive) made transition - 11/Aug/17 09:48 AM

Reopen

In Development

4h 31m

Jayshree Nagpure (Inactive) made transition - 17/Aug/17 04:22 AM

In LB Testing

Reopen in Local

16h 11m

Jaideep Vinchurkar (Inactive) made transition - 17/Aug/17 01:28 PM

Reopen in Local

In Development

9h 6m

Jayshree Nagpure (Inactive) made transition - 18/Aug/17 05:40 AM

In Development

In LB Testing

5d 18h 34m

Jayshree Nagpure (Inactive) made transition - 13/Sep/17 12:02 PM

In LB Testing

Stage Testing

26d 6h 21m

Jayshree Nagpure (Inactive) made transition - 14/Sep/17 12:48 PM

Stage Testing

In Production Testing

1d 45m

Jayshree Nagpure (Inactive) made transition - 14/Sep/17 12:48 PM

In Production Testing

Production Complete

People

Assignee:: Jayshree Nagpure (Inactive)

Reporter:: 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:: 26/Apr/17 09:52 AM

Updated:: 04/Nov/17 06:19 AM

Resolved:: 14/Sep/17 12:48 PM

Dev Due Date:: 11/Aug/2017

Pre-Prod Due Date:: 11/Sep/2017

Production Due Date:: 14/Sep/2017

Code Review Date:: 11/Aug/2017

Time Tracking

Estimated:

Remaining:

Logged:

19.5h