 checked the source of the issue failed email notification and found out because of the previously incomplete extracted files, to solve the issue re-extract and re-process the sposhistory data only because we currently have an issue extracting customer data. 