Meeting: | SPARC OS Technical Committee |
|---|---|
Date: | 01/18/2023 |
Time: | 3:01 pm - 3:57 pm |
MUSC | Greg, Evan, Brigette |
Iowa | |
LA CaTS | Ying |
Children’s National | |
Case Western | Jeremy |
OHSU | Erik, Imogen |
Stony Brook Medicine |
Agenda:
Standup Round for institutional updates
Louisiana Clinical & Translational Science Center:
1/4/23
Not in attendance
1/18/23
Ying reported also seeing the PDF access error, seemingly related to the Paperclip story.
MUSC:
1/18/23
Evan was introduced as a new team member assisting with technical tasks related to reporting and database. Members will be hearing from him as we gather their institutional SPARC reports.
Working on SPARC Release 3.10.1 mini release - see current stories.
New story additions & development ended 1/12/23
Release date 1/26/23
3.4.0 SPARC Fulfillment stories as the next major release.
New story additions & development ends 3/2/23
Release Date 3/16/23
Brainstorming SPARC speed/performance issue solutions. Asked attendees if they have experienced similar issues with SPARC or another product and suggested areas to look into.
Erik recommended focusing on high areas of impact first, reducing the data and number of rows queried (threw out active record), look at number of columns queried (change index for null data), figuring out a small unit of info to display to reduce the load at once, reviewing logs for underlying issues, looking at places with multiple loops and seeing activities happening for necessity for completing all actions. This takes time to do, and there are commercial services that can monitor and generate data if necessary to go that route.
Jeremy agreed with looking at active query time records and database scaling.
Audit trail - inquired if anyone has pulled out an audit trail from their SPARC instance to share a script. Noone has had to do this yet
Oregon Health & Science University:
1/4/23
Will hold their upgrade until 3.10.1 is released.
Followed up on SPARCCatalog And SPARC Admin - service appears in program in UI after being moved to Core in Catalog. MUSC will update story with previous MUSC-OHSU meeting info and ping Andrew for guidance on OHSU removing the services incorrectly appearing in program.
Still exploring a Jira and SPARC API to track fulfillment.
Interested in OS reports sharing and enhancements, including OHSU story of interest (SPARCReport) Add Optional Services Column On Service Requests Report
1/18/23
Awaiting 3.10.1 release for up-to-date SPARC version. They have already included their Fee Agreement change in their instance.
Noted end of life support dates for MySQL and MariaDB. They are looking to upgrade versions - has anyone else done this or plan to? LACaTS updated their server to ubuntu LTS 22.04. Case has not.
Iowa
1/4/23
not in attendance
1/18/23
not in attendance
Case Western
1/4/23
SPARC is still running well for them.
Working on SSL cert and dev server updates
1/18/23
Completed SSL cert installation
Sent out monthly reports that track who’s accessing services via a high level summary; tracking which service providers are downloading reports
Children’s National
1/4/23
not in attendance
1/18/23
not in attendance
Stony Brook:
1/4/23
not on this week
1/18/23
not in attendance
Discussion
SPARCRequest 3.10.1 Release overview. See notes HERE.
Reviewed release notes. Bugs with current tickets (e.g., PDF docs) will be resolved prior to release.