We have corrected the records. There is not code fix is Identified hence marking this as completed

Hi Debbie Kulling,

Here is log for import failure 1027201761350AM_5182_13122.txt . This error was related to inconsistent data and that was because a yet to finish back end routine. Developer mistakenly loaded another file before finishing processing of last file.
Data was corrected and the file was loaded again. But since, enrollment was already terminated, import did not touched the rates related to that enrollment.
To overcome such issues, we have started adding our email address in templates. We do receive emails of import completion and then only we start to load new files.

Ankur Deshpande Do we have any more information for Debbie? Are we able to see why the import failed?

Is there some kind of error that happens when the import fails? How do we prevent this from happening in the future?

Hi Debbie Kulling,

During the data load, while uploading the life file, the import failed due to some reason. The issue occurred due to the import failure which did not update/terminated the previous rate. Hence the calculation was showing value in negative.

Regards,
Ankur