...
- Process RMC files.
- Investigate making the TCS version reference in the ESR ETL dynamic (look for the 'latest' version of TCS rather than a specific version).
Lessons Learned
- The current implementation of the esr-ftp-sync is horrible, a better solution needs to be found. Further talks with IT regarding the underlying networking will be needed. a whole re-design of a proper interface using modern technology (not CSV file transfers that are highly interdependent on each other in those 5 processes) is required. Business case for with all associated risks re data quality issues here - https://hee-tis.atlassian.net/wiki/spaces/NTCS/pages/943357953/ESR+Streamlining, but achieving a proper interface re-design is impossible without ESR also doing major re-engineering on their side.
What went well
- Ashley's knowledge of the whole ESR system was invaluable to work out what was happening and when. Added to Jay's knowledge of ESR root cause analysis and John's increasing knowledge from an ops perspective enabled the problem to be isolated and corrected.
...