SFTP Error Status and Notifications Improvements
We've made the following improvements to the automated SFTP connections:
1. If an SFTP connection is successful, the error status is reset regardless if a new file is uploaded or not. Previously, the error status was not updated until a new file was processed. This led to occasional false positive emails "SFTP Connection Failed".
2. If an SFTP connection is successful when manually testing in the Console, the error status is reset.
3. An automated validation test is run on every upload to verify the number of processed rows. If the number is less than expected, any emails chosen in the SFTP On-Failure Notification Contacts setting will receive an "Upload Processed Less Rows Than Expected" message.