Application Delivery Update 6/6/2024

Jane Linder

• June 06, 2024 18:28

The alternate delivery process continues to send application data to colleges, with one period of downtime last night. The small batch of resulting backlogged applications was processed and delivered early this morning. 

A planned SuperGlue update today addresses these occasional periods of downtime and will restore application delivery to normal performance levels.

0

• Official comment

  

  Jane Linder

  • June 06, 2024 21:52

  Hi Robin,

  There were approximately 5000 applications that timed out and were not automatically delivered by SuperGlue today. These have been restarted by our network team and should be delivered within the next hour. Please let me know if you still do not see them later today.
• 

  Robin Torres

  • June 06, 2024 20:03

  We (State Center) still have applications outstanding (approximately 200).  I sent an another help ticket with the confirmation numbers.  Anyone else still having issues?

  0
• 

  Jason Gill

  • June 06, 2024 23:16

  Robin, if you don't mind me asking, how are you able to identify that applications are outstanding? I'm somewhat new to Superglue and mostly work on the PeopleSoft side, consuming the data. But with the recent outage it would be helpful if there was a way for us to know that an app was delayed rather than just waiting for an irate student to call and wonder why they can't enroll. Is there some documentation or other material you could point me towards?
  
  Thanks, 

  Jason Gill
  MiraCosta College

  0
• 

  Robin Torres

  • June 06, 2024 23:54

  Hi Jason.   Our IS department is tracking and this is what they are doing:

  "There are probably better ways to do this.  Counted how many applications were submitted on a particular day 6/3 (for instance) in our SG (SuperGlue) table and also in the CCCApply Report Center (used the Application by Date report).  If there was a difference, downloaded CCCApply report results to Excel and copied the SG confirmation numbers to Excel and then compared the confirmation numbers to see which ones weren’t in SCCCD SG table." 

  0
• 

  Michael Severa

  • June 07, 2024 00:52

  You can also just create a report that lists just the appids/confirmation numbers and download that as a csv. You can use any kind of scripting tool to create a query that would allow you to specifically query which apps are not in your superglue tables. 

  if you want to get fancy, you can also create a scheduled report and have the data automatically emailed to you (or if you use data warehouse, it can write directly to your sftp server, which means you could programmatically process it (we do this for spam filter stuff)).

  Warning however, not all of the timestamps are in the same timezone, so you'll have to fix that if you rely on one of those (I think that impacts data warehouse more than report center).  

  0
• 

  Jason Gill

  • June 07, 2024 01:03
  • Edited

  Thanks Robin, will look into that.  I haven't worked much on the CCCApply site side, I've been just on the SIS (PeopleSoft for us) side, consuming the data once it lands in the _stg tables. 

  And yes Michael, I recently (like yesterday!) discovered that the timestamps are not all in the same timezone, while researching the recent outage that we didn't know was systemwide, before I knew about this forum at all. 

  That's when I noticed that Submit timestamp (CCTC_APPL_SBMT_TS in Psoft) is GMT, Last Update (LASTUPDDTTM) is Pacific TZ, which is currently GMT + 7. Caused quite a bit of confusion for a while, since we were looking for "apps that were transmitted on a day different than the submit day" to try to investigate why we were getting large tranches of older apps, before we knew about the outage and catchup happening. 

  1

Please sign in to leave a comment.