Import getting fail for Emergency contact and spouse import and issue with Plan design identifier for beneficiary import.

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.