...

SSP v2.3.0 General Release Announcement

For implementers with an existing installation of 2.0.X, 2.1.X or 2.2 the changes described below should be executed after the release is built during the upgrade process. 

...

• There is no way to turn the fixup off via configuration. In general, it makes no sense to do so because the UI will make similarly arbitrary decisions (as it did prior to the bug fix), those decisions will just be delayed until the next time a given template is saved.In the event the fixup must absolutely be disabled, comment out this line in masterChangeLog.xml:
  • <include file="org/jasig/ssp/database/changesets/000116.xml" />

A change to the MAP Plan Full Printout was made to fix the Financial Aid Information option when printing or emailing the plan.  If you are upgrading from but not through SSP 2.2.x, you will need to manually update the databasechangelog table, else SSP will fail to start up. The error message will resemble the following:

...

Release Highlights

• Configurable Student Intake fields
• Caseload Assignment Redesign
• Send Email when Student Coach Change
• Add Permissions to Accommodation Report
• Map Plan Status Calculation
• Add Outcome to Student Placement Scores
• Additional Financial Aid data
• Edit Past MAP Plan Terms
• 81 bug fixes

Upgrade Instructions

For implementers with an existing installation of 2.0.X, 2.1.X or 2.2 the changes described below should be executed after the release is built during the upgrade process. 

• To upgrade from 2.0.X follow the upgrade instructions for BOTH the 2.1 and 2.2 Release Notes after deploying the 2.3 code
• To upgrade from 2.1.X follow the upgrade instructions for the 2.2 Release Notes after deploying the 2.3 code
• SSP-2303 addresses a bug identified in SSP where by a MAP plan/template term notes were duplicated in the system for each edit.  The application has been patched in v2.3.0, and a cleanup script was included to remove the duplicate rows.  In some cases, logic was required to determine the desired, unique row.  SSP will eliminate semantically duplicate rows in map_term_note in an attempt to winnow that dataset down to at most one row per plan_id\template_id+term_code. In general, because of the way the original bug worked, it's possible to figure out which note to keep by selecting the least frequently occurring note state per plan_id\template_id+term_code. But in the case of ties, the app will first attempt to find a unique result by only preserving records with the most recent created_date and, as a last resort, by making a truly arbitrary choice based on sorting by record id. Because this can potentially result in selection of a note state end users do not expect, and because the fixup is destructive in general, the first step in the fixup is to take a backup of the map_term_note table. That backup table is named map_term_note_SSP_2303_bak. The expectation is that administrators can query that table for historical map_term_note records in the event users report unexpected template state following an upgrade.
• • There is no way to turn the fixup off via configuration. In general, it makes no sense to do so because the UI will make similarly arbitrary decisions (as it did prior to the bug fix), those decisions will just be delayed until the next time a given template is saved.In the event the fixup must absolutely be disabled, comment out this line in masterChangeLog.xml:
    • <include file="org/jasig/ssp/database/changesets/
000087
• • • 000116.xml
::Update Full Map Printout for SSP-1894::tony.arland is now: 3:2ea129e39b757f33ecf3d107c8111ac9

 SSP-2218 contains all of the details for working around this problem (again, this should only be required if your currently deployed version is in the 2.2.x series): 

Run the following SQL against the SSP database:delete from databasechangelog where filename = '
• • • " />

• A change to the MAP Plan Full Printout was made to fix the Financial Aid Information option when printing or emailing the plan.  If you are upgrading from but not through SSP 2.2.x, you will need to manually update the databasechangelog table, else SSP will fail to start up. The error message will resemble the following:

  No Format
  Caused by: liquibase.exception.ValidationFailedException: Validation Failed: 1 change sets check sum org/jasig/ssp/database/changesets/000087.xml

  ' and id = 'Update Full Map Printout for SSP-1894'
• Check to make sure the message template change was applied:
  • In the SSP UI, navigate to Admin -> System Configuration -> Message Templates -> Select 'MAP Plan Full Printout' -> Click 'Edit'
  • Find the following section and replace the first line with #if($includeFinancialAidInformation)

Code Block
#if($includeHeaderFooter) <div style="width: 980px"> <div style="left:10px;margin-top:30px"> <p style="text-::Update Full Map Printout for SSP-1894::tony.arland is now: 3:2ea129e39b757f33ecf3d107c8111ac9

 SSP-2218 contains all of the details for working around this problem (again, this should only be required if your currently deployed version is in the 2.2.x series): 

• Run the following SQL against the SSP database:
  • delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000087.xml' and id = 'Update Full Map Printout for SSP-1894'
• Check to make sure the message template change was applied:
  • In the SSP UI, navigate to Admin -> System Configuration -> Message Templates -> Select 'MAP Plan Full Printout' -> Click 'Edit'
  • Find the following section and replace the first line with #if($includeFinancialAidInformation)

Code Block

#if($includeHeaderFooter) <div style="width: 980px"> <div style="left:10px;margin-top:30px"> <p style="text-align:left; color:#000000;"> <strong>Attempted Hours - </strong> $!attemptedHours </p> <p style="text-align:left; color:#000000;"> <strong>Completed Hours - </strong> $!completedHours </p> <p style="text-align:left; color:#000000;"> <strong>Current Completion Rate - </strong> $!completionRage </p> <p style="text-align:left; color:#000000;text-indent:15px;"> <strong>Number of hours needed to earn 67% completion rate - </strong> $!neededFor67PercentCompletion </p> <p style="text-align:left; color:#000000;"> <strong>Financial Aid Cum GPA - </strong> $!financialAidGpa - </strong> $!financialAidGpa </p> <p style="text-align:left; color:#000000;text-indent:15px;"> <strong>Number of needed to earn a 2.0 Cum GPA with all B - </strong> $!hoursNeededB </p> </div>

...

• </p> <p style="text-align:left; color:#000000;text-indent:15px;"> <strong>Number of needed to earn a 2.0 Cum GPA with all B - </strong> $!hoursNeededB </p> </div>

v2.3.0 JIRA Issues

Bugs

• [SSP-1881] - username size is not sufficient and inconsistent between person and external_person
• [SSP-1983] - Action Plan task link html not rendering in PDF report
• [SSP-1992] - Template Notes dialog says Plan Notes instead of Template
• [SSP-1994] - View All fails after Template Save
• [SSP-1996] - Unexpected MAP save dialog
• [SSP-1997] - 500 error when trying to print a new default plan
• [SSP-1999] - Event listener registered on MAP component destruction
• [SSP-2001] - Existing SemesterPanels not destroyed when rendering a different Plan or Template
• [SSP-2003] - No students in Caseload after selecting Caseload Reassignment Tool
• [SSP-2004] - Caseload View doesn't collapse after using MAP and expanding the Caseload View
• [SSP-2005] - MAP courses cannot be edited
• [SSP-2007] - Planned course elective colors render inconsistently on first plan load
• [SSP-2008] - Inconsistent invalid planned course highlighting for duplicate courses
• [SSP-2009] - MAP plan status display corrupted by template display
• [SSP-2015] - MAP- unexpected unsaved dialog without changing a plan
• [SSP-2017] - External person sync job errors out with empty person lookup result set
• [SSP-2022] - MAP Load Template Continuous Loading
• [SSP-2025] - Plan edit dirty status inconsistent for courses
• [SSP-2029] - Object not found error saving dirty MAP Template
• [SSP-2041] - Financial aid fields duplicated on second page of coaching history report
• [SSP-2042] - Missing SAP code rendered as literal 'null' in coaching history report
• [SSP-2043] - Inconsistent 'FA Awarded' field styling and show/hide behavior
• [SSP-2044] - Typo in student history report PDF file name
• [SSP-2045] - Financial Aid scripts loaded outside aggr/min javascript files
• [SSP-2046] - Financial aid uniqueness constraints need explicit names
• [SSP-2047] - External financial aid award and file tables will only be created if natural keys are enabled
• [SSP-2048] - Natural key config not respected on financial aid view recreation
• [SSP-2051] - sspAPIIntegrationTestData Deletes Message Templates
• [SSP-2053] - Fin Aid file status cleanup
• [SSP-2054] - Fin Aid SAP Status Code cleanup
• [SSP-2055] - Message queue errors on Linux CI again
• [SSP-2056] - MAP Opening an Authenticated Template fails security check
• [SSP-2058] - MAP Template Type filter not working
• [SSP-2061] - Blurb/Text database row and implementation corrections
• [SSP-2062] - Retrieving My Caseload for Program Status selection not working
• [SSP-2071] - Journal Entry entry date always set to current date
• [SSP-2075] - External financial aid, award, and file creation/expansion Liquibase will fail if natural keys turned on after having already run with natural keys turned off
• [SSP-2078] - Can't add student against fresh database
• [SSP-2080] - Caseload API error for appointment.modified_date
• [SSP-2081] - At most one current appointment time returned in search results
• [SSP-2089] - HQL syntax error when loading appointments for current user's caseload
• [SSP-2091] - Cannot change student program status
• [SSP-2102] - Journal Detail ordering causes 500 error
• [SSP-2103] - Main Tool sticky Service Groups
• [SSP-2105] - Caseload Assignment Edit Locks
• [SSP-2117] - Add Student.js and StudentIntakeRequest.js to app-all.js
• [SSP-2123] - MAP plan status load failed for SSP calc'd status on MAP display
• [SSP-2126] - SSP Admin and Caseload Assignment not visible
• [SSP-2142] - config.value missing for coachSetFromExternalData
• [SSP-2163] - Broken pagination in Financial Aid Files and SAP Statuses admin UIs
• [SSP-2165] - Broken pagination in Race admin UI
• [SSP-2168] - External integration spec incorrectly lists column name as external_term.reporting_year
• [SSP-2169] - Requisite validation message shows course code
• [SSP-2172] - External integration spec incorrectly lists column name as external_person_note.date
• [SSP-2174] - Plan 'email template' owner variables resolve wrong user
• [SSP-2176] - School email cutoff in Main Tool display
• [SSP-2214] - MAP 404 error when person_id set to null
• [SSP-2215] - Journal details not saved when using Track-Step entry
• [SSP-2218] - MAP print options not working correctly for MAP Full Plan Printout
• [SSP-2219] - MAP email with Financial Aid information missing
• [SSP-2220] - MAP grid is showing more than current plus 5 years
• [SSP-2231] - Typo in external_student_financial_aid.original_loan_amount spec
• [SSP-2241] - Linux CI environment experiencing out of memory errors
• [SSP-2242] - Main Tool- Details tab FA GPA disappears after page loads
• [SSP-2244] - Subset of externally sourced fields lost when saving caseload assignment form
• [SSP-2251] - Imprecise (of course) floating point arithmetic when totaling transfer credit hours
• [SSP-2252] - Possibly imprecise MAP plan/template hour totals
• [SSP-2258] - Possibly imprecise MAP plan/template hour totals in reports and email
• [SSP-2259] - Inactive student types appearing as available Caseload Assignment options
• [SSP-2269] - Grammatical and consistency errors in MAP tool tips
• [SSP-2288] - Mis-named external_student_transcript column in external data spec
• [SSP-2303] - Data fixup script for excessive MAP template term notes
• [SSP-2305] - Intermittent missing Hibernate session when flushing new person record created by coach sync
• [SSP-2319] - All planned courses in term considered valid if all planned courses in term are invalid
• [SSP-2321] - EA reasons and suggestions are not appearing in the Email Confirmation to Advisor
• [SSP-2324] - 404 from Main and Intake if external_term empty
• [SSP-2327] - Deactivated Student Types not rendered in Admin UI after interacting with Caseload Assignment UI

...