...

select school_id, COUNT(*) 
from external_person 
group by school_id 
having (COUNT(*) > 1) 
order by COUNT(*) 


select school_id, COUNT(*) 
from external_student_transcript 
group by school_id 
having (COUNT(*) > 1) 
order by COUNT(*) 


select school_id, COUNT(*) 
from external_student_financial_aid 
group by school_id 
having (COUNT(*) > 1) 
order by COUNT(*) 


select school_id, COUNT(*) 
from external_person_planning_status 
group by school_id 
having (COUNT(*) > 1) 
order by COUNT(*) 

3) For any implementer who deployed 2.5.0, there may be a error on startup while attempting the update to v2.5.1.  In the ssp.log the process to create the index on mv_directory person may fail with an error similar to the error described below.  If you encounter this error, execute the sql statements described below.

...

SQL to Retart the Object Creation

Both Databases
- drop table mv_directory_person

SQL Server
- delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000130.xml' and id = 'update for new installs directory_person view'
- delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000130.xml' and id = 'create mv directory_person view and pop msql'
PostgreSQL
- delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000130.xml' and id = 'create mv directory_person view and pop postgresql'

4) A change noted in the external data definitions for v2.5.X may affect the initial deployment.  A change was made to external_student_transcript_course.grade to make the column non-nullable.  As the database changes are made during deployment, the application will fail if any of the rows contains a null grade.  To correct the problem update the rows to ensure grade is not null and restart the application.  Some implementers do not generally record grades for current and future terms.  Those implementers that don't commonly use 'IP' for the current term and 'RG' for future terms.  Any grade can be used as long as it's not null.

v2.5.0 JIRA Issues

Bugs

• [SSP-1522] - Provide default sort order for Coaching History report
• [SSP-2018] - PersonDao.getAll()'s unpaginated result set count does not take any SortingAndPaging-encoded filtering intro account
• [SSP-2193] - Journal Details Sorting
• [SSP-2312] - Filtering coach list in Caseload Assignment affects coach combo boxes in other views
• [SSP-2318] - Potential Issue with parameterized in clauses
• [SSP-2380] - Suppress bad Maven repo dependencies
• [SSP-2405] - Edit a task in the temp list in Action Plan clears the due date
• [SSP-2407] - Financial Aid and Term GPA displayed without trailing zeros
• [SSP-2409] - Student History Report Inconsistent Formatting
• [SSP-2412] - Action Plan spelling corrections
• [SSP-2413] - Action Plan error handling for missing CL and Due Date
• [SSP-2416] - Early Alert Response Journal Entry template missing variables
• [SSP-2422] - Validate SSO-ing users identity prior to issuing SSO ticket
• [SSP-2425] - "Signed URL SSO" ticket requests always receive 403 regardless of actual problem
• [SSP-2431] - Directory Person API To Force Update
• [SSP-2439] - References Throw Server side Exceptions After Sort by Active selected
• [SSP-2440] - Self help guide Reference Edit does not return to List on Save
• [SSP-2442] - Increase SSP portlet timeout
• [SSP-2443] - Mismatched Plan/Template field widths
• [SSP-2448] - Plan Course Count Report Extremely Slow with Large Datasets
• [SSP-2449] - Total Student Count is cut off on Disability Report
• [SSP-2450] - Invalid earlyAlertResponse.earlyAlertReferralIds variable path for EAR message template
• [SSP-2451] - Incorrectly encoded search term in username-based cross-context RESTful Platform person lookups
• [SSP-2454] - DOB label value doesn't render in Student Search
• [SSP-2455] - Choosing Caseload Re-assignment in Admin throws exception
• [SSP-2456] - SHG Early Alert Summary shouldn't be required
• [SSP-2457] - Config description for task_directory_person_refresh_trigger
• [SSP-2466] - No coaches returning throughout the application
• [SSP-2469] - Coaching History report has MAP Projected Graduation instead of MAP Ends
• [SSP-2471] - Map does not respect 'map_edit_past_term' config
• [SSP-2472] - When entering the MAP tool, if the student has no active but at least 1 inactive plan. Closing the load plan dialog leads to blank map screen
• [SSP-2478] - Electives Do not sort properly
• [SSP-2479] - Reference Drop Downs not populating
• [SSP-2480] - Change Student Search combo box label to Select Coach
• [SSP-2482] - MAP available courses scroll bar missing
• [SSP-2483] - SSP doesn't load on FF in non-minified
• [SSP-2484] - MAP page doesn't load after leaving and returning
• [SSP-2486] - CRG items not saved correctly when made inactive
• [SSP-2487] - CRG Challenges only display 20 items
• [SSP-2489] - Modified plan not checked for save when valid course is added to a plan
• [SSP-2490] - All program status filter no longer working
• [SSP-2491] - DOB missing from student search
• [SSP-2493] - Message Template admin not rendering
• [SSP-2494] - Main Tool tabs fail to load
• [SSP-2495] - Only the Main Tool link is working
• [SSP-2499] - Can not save early Alert Response
• [SSP-2502] - Permission combo box broken trying to add/edit Confidentiality Level
• [SSP-2504] - Overly precise date of birth search param
• [SSP-2505] - Duplicate Journal Step Details in Student History Report
• [SSP-2507] - Admin Confidentiality Level Does not sort on Data Permission
• [SSP-2512] - Template owner not reset upon save as after loading a template from another owner
• [SSP-2514] - Deleted Tasks showing in Main and in Student History Reports
• [SSP-2515] - Editing a Student's Task Fails
• [SSP-2516] - Student Search using MAP Status renders different results
• [SSP-2518] - Campus routing without a reason fails
• [SSP-2519] - MAP status criteria in Student Search configuration problem
• [SSP-2520] - Grade not considered when evaluating substitutions for On/Off Plan MAP Status
• [SSP-2522] - Edit Task Dialog Is Not Destroyed
• [SSP-2523] - Caseload pagination broken and sort indeterminate or obscure
• [SSP-2530] - Failing ConfidentialityLevelIT tests
• [SSP-2531] - Failing ConfigIT tests
• [SSP-2532] - Random enrollment returned to Early Alert form if studentUserName specified but not schoolId
• [SSP-2534] - Main tool rendering with all empty fields for some students
• [SSP-2537] - Search form is blank
• [SSP-2538] - Caseload Assignment- changing program status not working
• [SSP-2539] - Caseload pagination should be 100 records
• [SSP-2540] - Inactive Service Groups showing in Search criteria list
• [SSP-2541] - Main Tool Reg value not appearing on Dashboard
• [SSP-2542] - Email Action Plan dialog doesn't close
• [SSP-2543] - Action Plan print button does nothing
• [SSP-2544] - Action Plan edit temp task list dialog obscured
• [SSP-2547] - Coaching History failed on Win CI
• [SSP-2548] - Accommodation Tool save fails upon saved on Win CI
• [SSP-2549] - MAP Filter by Term value sort
• [SSP-2550] - MAP Save as New Plan fails
• [SSP-2553] - Overly generic error message when requested Early Alert student can't be found

...