• Final

    • CAS API Connection Error

    Owned by Helen Williams
    Last updated: Feb 22, 2024
    2 min read

     

    Slate Instance

    TUP

    Requestor/Reporter

    Helen Williams

    TTS Staff

    Helen Williams

    Date

    9/13/2023

    Status

    Complete

    Bug Description

    A firewall issue caused files sent from CAS to Slate through the API to not be delivered.

    Issue Description:

    From approximately 6:45 PM 9/12/2023 until 8:30 AM 9/13/2023, files sent from the CAS API to Slate via SFTP were not delivered due to a firewall issue.

    Notes

    Using Postman to Set Up the CAS API Slate Integration - details about using Replay endpoint in Postman.

    9/13 8:22 AM:

    Good morning everyone, after some initial investigation we can confirm that the SFTP has not failed and is in fact "up" as it were. It seems like that this is related to a firewall issue, which we still in the process of investigating. Once again, thank you for reporting, for your patience and we will provide an update when one is available!

    9/13 8:29 AM:

    Hi all! It's me again! We are now seeing connections being accepted. Outbound file transfers would have been unaffected and all jobs within Slate would similarly be unaffected. If you attempt to pick up your files once more, they are ready and waiting. Thank you!

    https://knowledge.technolutions.com/hc/en-us/community/posts/18734120161307-Slate-SFTP-appears-to-be-down

    TUP/PTCAS

    Resolution steps:

    1. Identified skipped/missed files via the error reports sent to tts-slate-team@tufts.edu. Three subscriptions were affected, all In Progress subscriptions for PTCAS.

    2. Executed replay for each subscription:

    Subscription ID

    Replay ID

    FromDate

    ToDate

    Total Apps

    Subscription ID

    Replay ID

    FromDate

    ToDate

    Total Apps

    8014

    8292

    2023-09-12 19:40:00

    2023-09-13 03:10:00

    2

    8015

    8293

    2023-09-12 18:40:00

    2023-09-12 18:59:00

    1

    8016

    8294

    2023-09-12 19:00:00

    2023-09-13 03:20:00

    6 (1 file excluded, no longer qualified as “selected)

    1. Confirmed application files sent to server in /incoming/liaison/PTCAS/data via FileZilla.

     

    TUV/VMCAS

    1. Identified skipped/missed files via the error reports sent to tts-slate-team@tufts.edu. Document, data, and coursework files were affected.

    Files

    total skipped

    Notes

    Files

    total skipped

    Notes

    Transcripts

    54

     

    WES Evaluations

    2

     

    Evaluations

    84

     

    Coursework

    31

    will not be using data from this feed; no need to followup

    Verified

    31

    28 of these files eventually came through. 2 did not have a verified feed, but did have one or more updates, which are set up to come only after verification. One is in ‘returned' status as of 9/13, so might have become unavailable during the outage.

    In Progress

    22

    these will only matter if they convert to applications

    Received

    40

    the expectation is that most of these will have other events which will make up for the missed

    Completed

    16