Versions Compared

Old Version 16

changes.mady.by.user Jason Elwood

Saved on

compared with

New Version Current

changes.mady.by.user Daniel McCallum

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

4) To support the new person directory described above, stored procedures (SP) were created to execute large database operations.  Following each create statement, there is a statement to grant permissions to execute the SP included in the 2.5.1 release.  For SQL Server implementations, the grant statement may fail for certain account roles/permissions combinations.  Executing the grant statements independently is highly recommended.  The statements below cover the four new SPs and must be adjusted to replace 'ssp' with the db_username in the  from $SSP_CONFIGDIR/ssp-config.properties file. These statements also assume you're using the 'dbo' schema. If you're not, you probably know what the correct schema name is. Or check the value of db_schema in 

Code Block
GRANT EXEC on dbo.REFRESH_MV_DIRECTORY_PERSON to ssp;

GRANT EXEC on dbo.REFRESH_MV_DIRECTORY_PERSON_BLUE to ssp;

GRANT EXEC on dbo.update_directory_person_from_view_where_school_id to ssp;

GRANT EXEC on dbo.update_directory_person_from_view_where_person_id to ssp;

 

5) 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.

...

    • syncStudentPersonalDataWithExternalData

    • coachFieldLabel

    • studentIdAlias

    • studentIdMinValidationLength

    • studentIdMaxValidationLength 

    • studentIdAllowableCharacters

    This release also moves the system's email 'from' address out of the person table and into the configuration table. So changes to the admin account's person record will no longer affect the 'from' address on outbound email. Instead use the outbound_email_address config option in SSP -> Admin -> Administrative Tools -> System Configuration -> Configuration Options. That config will be set to the value of select primary_email_address from person where id = '58ba5ee3-734e-4ae9-b9c5-943774b4de41' at the time of upgrade.

 

Warning

If you are upgrading an environment, you should delete or change the passwords for the uPortal users created for demonstration purposes. This can be done through the user interface: Manage Users ->  Find an Existing User -> [Enter user ID from list below] -> [Click result] -> Delete or Edit, then change password. Demo users:

  • advisor0
  • ken
  • student0
  • student1

This is only necessary for upgrades. A fresh 2.5.1 install will not create these users.

A fresh install should also either change the admin user's password or add some other user to the Portal Administrators group and delete the admin user.

v2.5.1 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
  • [SSP-2564] - Program combo box in MAP Save/Save As dialogs built from 'facet' API, should be 'all' API
  • [SSP-2565] - 500 Error thrown when saving Student Intake
  • [SSP-2566] - Unpredictable MAP Template term note display
  • [SSP-2568] - Potentially incorrect caseloads reflected in Early Alert reminder email
  • [SSP-2573] - Coaches receive Off Plan email for unrelated students
  • [SSP-2574] - map_plan_status_send_off_plan_coach_email not respected
  • [SSP-2578] - Inconsistent calculate_map_plan_status interpretation
  • [SSP-2580] - MAP planned courses not rendering in UI
  • [SSP-2585] - mv_directory_person fails when student have multiple academic programs
  • [SSP-2586] - Presence of Plan notes not reflected in menu button decoration
  • [SSP-2588] - JS error on Plan bump
  • [SSP-2589] - External Person Always Sync'd
  • [SSP-2590] - Potentially inexact course code matching in MAP UI
  • [SSP-2592] - Directory Search on Anywhere brings back SSP Only
  • [SSP-2593] - Tabbing from Search to Caseload does not update result panel
  • [SSP-2597] - map_edit_past_terms not respected
  • [SSP-2598] - MAP unexpectedly locked against certain edits
  • [SSP-2599] - Student search 'enter' key press binding lost on navigating to Admin
  • [SSP-2600] - MAP elective color indicators are not appearing
  • [SSP-2605] - Inexact Financial Aid File and SAP Status code matching
  • [SSP-2607] - Inexact person ID matching
  • [SSP-2609] - Inexact configuration name matching
  • [SSP-2610] - Inexact text/blurb code matching
  • [SSP-2612] - Inexact student type name matching
  • [SSP-2613] - Inexact confidentiality level ID and name matching
  • [SSP-2617] - Action Plan Challenge combo box sorted randomly when filtered by Category
  • [SSP-2619] - Adding Service Groups fails after canceling the first add
  • [SSP-2622] - Inaccurate Alerts column sorting in Caseload view
  • [SSP-2625] - Caseload color indicators and search for early alert status not accurate
  • [SSP-2626] - Early alert due date arbitrarily extended in Postgres directory/caseload results
  • [SSP-2628] - SQLServer GET_EARLY_ALERT_RESPONSE_DUE_COUNT function ignores EA closures

...