...
TUSMGP requested a change to the CNAME/sub-domain for their database (from phpd.admissions.tufts.edu to tusmgp.admissions.tufts.edu) When this change went into effect on 8/25/2023, the CAS/Liaison service account username was also changed in their instance of Slate (from liaison_service@phpd.admissions.tufts.edu to liaison_service@tusmgp.admissions.tufts.edu). This caused the existing API subscriptions to fail and data to stop importing between the CAS and Slate.
After running the solution below, we also discovered that we had four applicants for the DPT-Boston program who did not have applications in Slate. All 4 had started their application 6/20-21, which meant it was likely they had been a problem before this specific issue. Most likely when the subscription was setup at the beginning of the cycle, those in progress files were missed by the process to replay the in progress subscription.
Solution:
Existing API subscriptions were deleted, the subscription configurations updated with the correct email address for the sftpUser, the subscriptions re-created, and then replays made for each subscription to cover time between when the files stopped sending (roughly 8/25/2023 at 4:45 PM EST) to when each subscription was restarted.
...