ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.GetDataForInsertCheck
ErrorMessage: Item has already been added. Key in dictionary: '256115946 110 ' Key being added: '256115946 110 '
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

I have checked the template, it has worng date mapped please refer attached Effective date should be mapped to employee formdata effective date.

Hi Nathaniel Cornejo-Walker,

There were duplicate Additional form entries in system. This was causing the failure of Import. We have corrected the data and Import will be successful now.
We are looking into why those duplicate entries were inserted and will update you accordingly.
Thanks!

Hi Swapnil Pandhare,

There were duplicate entries in Employee_Formdata for 4 employees. When checked, we found those were inserted by employee login. We have corrected the data. The duplicate entries are present on HSPL copy or we have also taken a backup before correction.

Can you please take this ahead.

Suraj Sokasane Swapnil Pandhare please load file into production once issue is resolved.
thanks
cc Abhay Patil

I need this done today. This client goes live on Monday

Hi Debbie Kulling,

This is in progress. We are loading the file on Production.

Just to Confirm, we are loading the above attached file named : Clarkesickupdate fail.txt
is is ok?
Debbie Kulling, Nathaniel Cornejo-Walker

Hi Nathaniel Cornejo-Walker, Debbie Kulling,

We have loaded the file on Clarke on Production. here's the bad file : Bad_Clarkesickupdate fail10_12_2017 07_19_08 AM.zip .

Please let us know if you have any queries.

Adding comments for clarification from Satya - a dev fix is still needed to prevent duplicate entries from entering the system.

Hi Hrishikesh Deshpande,

We have tried to reproduce the issue.But not able to reproduce the issue.
Please refer below scenarios that We have tried,

1)Tried with Both OE and New hire mode.Added new additional form.Verified through employee login.
Data saved properly.No multiple entries found in history table against newly added forms.
2)Verified with requires verification set on modes.
3)Tried to click on multiple times on Save and Continue button but on first click only,button gets disabled.
4)Tried to skip the additional form

Please check this issue at your end.

CC:Swapnil Pandhare

Thanks,
Sheetal Bodhale

HI Jayshree Nagpure

Could you please do analysis and reproduce the issue for import?

CC Hrishikesh DeshpandeSachin HingoleRakesh Roy

Hi Prasad Pise,

Verified below scenarios on Clarke for hspl production but its not reproduced at our end through import.

1) Imported additional form data through import. - import done successfully
2) Updated additional form data through import- import done successfully
3) Traverse the OE and new-hire mode
4) Tried to save and continue additional form multiple time, no duplicate entries found on UI.
5) Added entries of Health Care for two Married Employees, Sick Leave Balance, State Health Website, Tobacco Usage through import at same time and updated.
6) In workflow saved all the forms by updating through UI, no duplicate entries found.
7) For adding additional data and updating through import, import done successfully.
8) Verified for single and multiple employees.

Thanks,
Jayshree

Hi Venkatesh Pujari,

Please try to repro this issue on EDS. Jayshree tried this on Import but it is not getting reproduced.

Thanks,
Hrishikesh.

Hi Hrishikesh Deshpande,

Verified to reproduce the duplicate entries issue on Production on Hspl copy but could not do so. I tried this through the New Hire Mode,OE Mode and also through QE mode. Also tried it through approval but could not reproduce it.

Thanks,
Venkatesh

Hi @Debbie,

Issue of Import failed was due to duplicate entris in Employee Form.
It was corrected and import worked fine but this issue not getting reproduced at our end.

We will keep track of such issues in case it occurs again.

Thanks,
Hrishikesh.