[NF-182] Import getting fail for Emergency contact and spouse import and issue with Plan design identifier for beneficiary import. - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
None

Module:
BenAdmin - Import
Reported by:
Harbinger
Item State:
LB QA

Description

1)Login with Partner on Lb
2)Select and Search for company
3)Go to import/Export
4)Create spouse template->Browse the file for spouse template->Import getting fail
5)create emergency template->Browse the file for emergency contact->Import getting fail
6)create beneficiary template->Browse the file for beneficiary import->File went to bad with "plan design does not exists"

Expected Result:Import should be done successfully and beneficiary import should be done successfully

Actual Result:Import getting fail for salary and spouse import and issue with Plan design identifier for beneficiary import.

Emergency contact:
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ExecuteAllQueries
ErrorMessage: Violation of UNIQUE KEY constraint 'IX_Employee_Emergency_EmployeeID'. Cannot insert duplicate key in object 'dbo.Employee_Emergency'. The duplicate key value is (979).
The statement has been terminated. INSERT INTO Employee_Emergency(EmployeeID,SecondaryPostalCode,SecondaryStateID,SecondaryCountryID,SecondaryWorkPhone,SecondaryHomePhone,EffectiveDate,UserID) Values( 979,'98562', 5 , 1 ,'9874561232','7894561235','2/14/2017',1); IF NOT EXISTS( SELECT * FROM ImportEmployeeInfoForBackendRoutine WHERE ImportExportBadFileID = 1560 AND EmployeeID = 979 AND DATEDIFF(DAY, EffectiveDate, '2/14/2017') = 0 AND InsertORUpdate = 1 AND MemberTypeID = 1 ) BEGIN INSERT INTO ImportEmployeeInfoForBackendRoutine (ImportExportBadFileID, EmployeeID, EffectiveDate, InsertORUpdate, MemberTypeID, MemberID, CorePlanStatus, EligibilityStatus) VALUES( 1560, 979, '2/14/2017' , 1, 1, 979 , 0, 0 ) END

Spouse: ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ProcessLineForBadRecord->ImportValidation.ValidateData->ImportValidation.ValidatePhoneNumber
ErrorMessage: Object reference not set to an instance of an object.

Attachments

Issue Links

blocks

NF-53 UK Benefits:Implement Phone Number like Zip/Postal code based on Country selection on Import

Reopen in Production

Activity

Ascending order - Click to sort in descending order

Jayshree Nagpure (Inactive) created issue - 14/Feb/17 12:52 PM

Jayshree Nagpure (Inactive) made changes - 14/Feb/17 12:56 PM

Field	Original Value	New Value
Summary	Import getting fail for salary and spouse import and issue with Plan design identifier for beneficiary import.	Import getting fail for Emergency contact and spouse import and issue with Plan design identifier for beneficiary import.

Jayshree Nagpure (Inactive) made changes - 14/Feb/17 12:56 PM

Link

This issue blocks ~~NF-53~~ [ ~~NF-53~~ ]

Prasad Pise (Inactive) made changes - 15/Feb/17 09:13 AM

Environment	LB [ 10800 ]
Key	~~WT-8447~~	~~NF-182~~
Project	WORKTERRA [ 10000 ]	New Features 2017 [ 11000 ]

Suraj Sokasane (Inactive) made changes - 15/Feb/17 03:10 PM

Remaining Estimate		6h [ 21600 ]
Original Estimate		6h [ 21600 ]

Permalink

Suraj Sokasane (Inactive) logged work - 15/Feb/17 03:11 PM

Time Spent:

0.5h

Analysis and check in verification.

Suraj Sokasane (Inactive) made changes - 15/Feb/17 03:11 PM

Remaining Estimate	6h [ 21600 ]	5.5h [ 19800 ]
Time Spent		0.5h [ 1800 ]
Worklog Id	25309 [ 25309 ]

Hide

Permalink

Suraj Sokasane (Inactive) added a comment - 16/Feb/17 07:02 AM

Jayshree Nagpure

As Discussed, please mention Template and Company Name.

Show

Suraj Sokasane (Inactive) added a comment - 16/Feb/17 07:02 AM Jayshree Nagpure As Discussed, please mention Template and Company Name.

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 16/Feb/17 07:14 AM

Hi Suraj Sokasane,

Company : Caiso
For spouse: NF_53 Spouse
For beneficiary : ~~NF-53~~ Beneficiary
For Emergency contact: Emergency contact NF_53

Show

Jayshree Nagpure (Inactive) added a comment - 16/Feb/17 07:14 AM Hi Suraj Sokasane , Company : Caiso For spouse: NF_53 Spouse For beneficiary : NF-53 Beneficiary For Emergency contact: Emergency contact NF_53

Permalink

Suraj Sokasane (Inactive) logged work - 16/Feb/17 01:06 PM - edited

Time Spent:

6h

<No comment>

Hide

Permalink

Suraj Sokasane (Inactive) added a comment - 17/Feb/17 10:05 AM

Hi Jayshree Nagpure,

Spouse Import issue needs a code fix and will be deployed on LB today.
In Emergency Contact issue, Phone numbers are marked as unique, which is causing the failure. Remove the uniqueness and it will be successful.
For Beneficiary, we have two other issues. It can not be mentioned in this Ticket.

CC- Jaideep Vinchurkar

Show

Suraj Sokasane (Inactive) added a comment - 17/Feb/17 10:05 AM Hi Jayshree Nagpure , Spouse Import issue needs a code fix and will be deployed on LB today. In Emergency Contact issue, Phone numbers are marked as unique, which is causing the failure. Remove the uniqueness and it will be successful. For Beneficiary, we have two other issues. It can not be mentioned in this Ticket. CC- Jaideep Vinchurkar

Suraj Sokasane (Inactive) made changes - 17/Feb/17 10:55 AM

Code Reviewed By

Jaideep Vinchurkar [ 11908 ]

Khandu Kshirsagar (Inactive) made changes - 17/Feb/17 10:55 AM

Item State

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

Suraj Sokasane (Inactive) made changes - 17/Feb/17 11:00 AM

Assignee

Suraj Sokasane [ suraj.sokasane ]

Jayshree Nagpure [ jayshree.nagpure ]

Permalink

Suraj Sokasane (Inactive) logged work - 17/Feb/17 11:16 AM

Time Spent:

4h

Analysis and code fix.

Suraj Sokasane (Inactive) made changes - 17/Feb/17 11:20 AM

Remaining Estimate	5.5h [ 19800 ]	1.5h [ 5400 ]
Time Spent	0.5h [ 1800 ]	4.5h [ 16200 ]
Worklog Id	25808 [ 25808 ]

Permalink

Jayshree Nagpure (Inactive) logged work - 17/Feb/17 01:44 PM

Time Spent:

1.5h

Discussion with suraj and lb testing

Jayshree Nagpure (Inactive) made changes - 17/Feb/17 01:46 PM

Remaining Estimate	1.5h [ 5400 ]	0h [ 0 ]
Time Spent	4.5h [ 16200 ]	6h [ 21600 ]
Worklog Id	25923 [ 25923 ]

Jayshree Nagpure (Inactive) made changes - 20/Feb/17 12:46 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)

Jayshree Nagpure (Inactive) made changes - 20/Feb/17 12:46 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Jayshree Nagpure (Inactive) made changes - 20/Feb/17 12:46 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 20/Feb/17 01:02 PM - edited

Hi Suraj Sokasane,

Environment:Lb
Company: Caiso
Tested spouse import its working as expected
Verified emergency contact import: Imported file goes go bad with validation message as "Invalid state"
For this issue Please refer ~~NF-196~~
For beneficiary import:working fine
import is done successfully but on UI could not check the phone number is updated or not for spouse and child.we have created new jira for this issue ~~WT-8542~~.
As discussed with Prasad Pise,for emergency contact import, when state is mapped its impacting and file goes to bad.
Hence re-opening this jira.

Thanks,
Jayshree

CC: Prasad Pise Rakesh Roy Jaideep Vinchurkar

Show

Jayshree Nagpure (Inactive) added a comment - 20/Feb/17 01:02 PM - edited Hi Suraj Sokasane , Environment:Lb Company: Caiso Tested spouse import its working as expected Verified emergency contact import: Imported file goes go bad with validation message as "Invalid state" For this issue Please refer NF-196 For beneficiary import:working fine import is done successfully but on UI could not check the phone number is updated or not for spouse and child.we have created new jira for this issue WT-8542 . As discussed with Prasad Pise ,for emergency contact import, when state is mapped its impacting and file goes to bad. Hence re-opening this jira. Thanks, Jayshree CC: Prasad Pise Rakesh Roy Jaideep Vinchurkar

Jayshree Nagpure (Inactive) made changes - 20/Feb/17 01:03 PM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Suraj Sokasane [ suraj.sokasane ]

Permalink

Jayshree Nagpure (Inactive) logged work - 20/Feb/17 01:22 PM

Time Spent:

4h

lb testing and internal discussion

Jayshree Nagpure (Inactive) made changes - 20/Feb/17 01:22 PM

Time Spent	6h [ 21600 ]	10h [ 36000 ]
Worklog Id	26162 [ 26162 ]

Jayshree Nagpure (Inactive) made changes - 21/Feb/17 05:41 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 - 21/Feb/17 05:41 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Prasad Pise (Inactive) made changes - 22/Feb/17 05:37 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Prasad Pise (Inactive) made changes - 22/Feb/17 05:38 AM

Item State

Parent values: LB QA(10201)

Prasad Pise (Inactive) made changes - 22/Feb/17 05:38 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Prasad Pise (Inactive) made changes - 22/Feb/17 05:38 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Prasad Pise (Inactive) made changes - 22/Feb/17 05:38 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Prasad Pise (Inactive) made changes - 22/Feb/17 05:38 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 22/Feb/17 05:39 AM

Verified on LB

CC: Prasad Pise Suraj Sokasane Rakesh Roy

Show

Jayshree Nagpure (Inactive) added a comment - 22/Feb/17 05:39 AM Verified on LB CC: Prasad Pise Suraj Sokasane Rakesh Roy

Jayshree Nagpure (Inactive) made changes - 22/Feb/17 05:39 AM

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

Jayshree Nagpure (Inactive) made changes - 22/Feb/17 06:00 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Suraj Sokasane (Inactive) made changes - 28/Feb/17 01:06 PM

Time Spent	10h [ 36000 ]	16h [ 57600 ]
Worklog Id	28127 [ 28127 ]

Suraj Sokasane (Inactive) made changes - 28/Feb/17 01:06 PM

Worklog Id

28127 [ 28127 ]

Transition	Time In Source Status	Execution Times

Jayshree Nagpure (Inactive) made transition - 20/Feb/17 12:46 PM

Open

In Development

5d 23h 54m

Jayshree Nagpure (Inactive) made transition - 21/Feb/17 05:41 AM

In LB Testing

Reopen in Local

16h 55m

Prasad Pise (Inactive) made transition - 22/Feb/17 05:38 AM

Reopen in Local

In Development

23h 56m

Prasad Pise (Inactive) made transition - 22/Feb/17 05:38 AM

In Development

In LB Testing

Prasad Pise (Inactive) made transition - 22/Feb/17 05:38 AM

In LB Testing

Stage Testing

Prasad Pise (Inactive) made transition - 22/Feb/17 05:38 AM

Stage Testing

In Production Testing

Jayshree Nagpure (Inactive) made transition - 22/Feb/17 05:39 AM

In Production Testing

Production Complete

1m 21s

Jayshree Nagpure (Inactive) made transition - 22/Feb/17 06:00 AM

Production Complete

Closed

20m 33s

People

Assignee:: Suraj Sokasane (Inactive)

Reporter:: Jayshree Nagpure (Inactive)

Developer:: Suraj Sokasane (Inactive)

QA:: Jayshree Nagpure (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 14/Feb/17 12:52 PM

Updated:: 28/Feb/17 01:06 PM

Resolved:: 22/Feb/17 05:39 AM

Time Tracking

Estimated:

Remaining:

Logged:

16h