Versions Compared

Old Version 11

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.
Comment: Whitespace

...

Excerpt

Upgrade Notes:

For implementers upgrading from a version prior to 2.0-b2, please pay attention to the following items.

  • A new column named code has been added to the student_type table.  The code column is not nullable and must be unique so SQL has been added to the liquibase to copy the student_type.name to student_type.code.  The code column is limited to 10 characters and the name column is longer than 10.  For any item with a name longer than 10 characters, the liquibase will fail.  In order to allow the liquibase to complete, the name values must be temporarily reduced to 10 of fewer characters.  Once the SSP application deploys, the name values can be restored.  This must be done locally in the database.
  • Removal of duplicate permissions for student documents

Code Block
SQL to delete dup perms:
	delete from up_permission_activity where activity_name in ('PERSON_STUDENT_DOCUMENT_READ','PERSON_STUDENT_DOCUMENT_WRITE');
	2 results

SQL to remove group to perm relationships:
	delete from up_permission where activity in ('PERSON_STUDENT_DOCUMENT_READ','PERSON_STUDENT_DOCUMENT_WRITE');
	6 results

 

  • uPortal Database Update

 

Code Block
uPortal Database: Updates the uPortal database to include SSO options contributed by St Petersburg College and Indian River State College

		ant -Dmaven.test.skip=true db-update
		
		Alternatively, the update can be done during the deployment with:
		
		ant -Dmaven.test.skip=true clean db-update deploy-ear

 

  • uPortal Permissions and Groups to support SSP Roles

 

Code Block
uPortalIf Permissionsyou andare Groups:upgrading Allthrough SSP changes introduced in 2.0-b3 can be completing by importing data through an ant build with the following command
 v1.2.x, be sure to execute the uPortal data migrations for that version first. This can be done in a single command:
 
   ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0-0/ data-import
 
To import changes individually,Then execute the following imports can be run.  If the command above was run, then items 1-3 individual imports are not necessary

    1.  Creates MAP public template write permission
        ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-2-0-0/SSP-1473/ data-import
    2.  Creates read/write permissions to the SSP_FACULTY_ROLE for the Appointment  API
        ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-2-0-0/SSP-1284/ data-import
    3.  Grants permissions to Coaches for the Reports portlet and Notes to appropriate roles
		ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-2-0-0/SSP-1526/ data-import
	4.  Registers the SSP_STUDENT role to the uPortal SSP Roles Group and creates the MAP_PUBLIC_TEMPLATE role
        ant -Dmaven.test.skip=true -Dfile=uportal-war/src/main/data/ssp_entities/group_membership/SSP_Roles/SSP_Roles.group-membership.xml data-import
	5.  Grants global permissions for MyGPS
		2.0.0 migrations:
 
    ant -Dmaven.test.skip=true -DfileDdir=./uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0/SSP-698/fragment-definition/my-gps-lo.fragment-definition.xml-0/ data-import
	6.  Grants global permissions for MyGPS
		
 
Then update the list of child groups for the 'SSP Roles' group:

   ant -Dmaven.test.skip=true -Dfile=./uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0/SSP-698/permission_set/Authenticated_Users__MY_GPS_TOOL__SSP.permission-setgroup_membership/SSP_Roles/SSP_Roles.group-membership.xml data-import

Bug

  • [SSP-0197] - Handle sort ordering through the headers in the admin grids
  • [SSP-0441] - SPC would like the ability to see "All" students assigned to them
  • [SSP-0536] - Caseload search result pagination counts don't take object_status into acount so don't match displayable result counts
  • [SSP-0697] - Liquibase scripts fail with Windows domain accounts
  • [SSP-0717] - Appointment always required when editing student caseload assignment
  • [SSP-0846] - Error pages do not output valid JSON
  • [SSP-0899] - Caseload Assignment Sort and Expand All Features
  • [SSP-0929] - MAP add Financial Aid link and data display for Phase 3
  • [SSP-0968] - MAP add plan status indicator for Phase 3
  • [SSP-0969] - MAP validate course requisites when planning for Phase 3
  • [SSP-0971] - Add indicators for course notes and term importance for Phase 3
  • [SSP-0972] - MAP add Client Side Logic to support Shift Plan
  • [SSP-0978] - Paging persist when changing filters
  • [SSP-0980] - The page box is not aligned with the rest of the text
  • [SSP-0983] - Contact information appears to be cutoff
  • [SSP-0985] - Missing sorting in Students section
  • [SSP-0987] - Edit link for Service Reasons or Service Groups takes user to the wrong page
  • [SSP-0988] - Sorting not working on Journal page
  • [SSP-0989] - Sorting not working on Early Alert page
  • [SSP-0991] - Missing 'Task Name' field when adding tasks
  • [SSP-0992] - Object error occurs when leaving Reports page before it loads
  • [SSP-0995] - Internal Server Error when all of the reasons for Service are selected
  • [SSP-1005] - 'Set Student to Non-Participating' uses last student found when no student is selected
  • [SSP-1116] - Sorting not working for 'Recent SSP Activity for this Student'
  • [SSP-1173] - 403 error occurs when accessing a student while logged in as a faculty user
  • [SSP-1193] - UI does not call all configured reference items
  • [SSP-1216] - Selecting challenge referral clears existing values in task form
  • [SSP-1226] - Can't see more than 100 plans per user
  • [SSP-1242] - Special Service Groups Showing in Reports After Being Removed From Student Record
  • [SSP-1245] - Calculation of current term
  • [SSP-1281] - Enhance MAP Operational Data Model for Phase 3
  • [SSP-1283] - Access Denied Popup not displaying for EAL with no appointment time set.
  • [SSP-1284] - New Student entry by Faculty met with Access Denied still creates Student
  • [SSP-1284] - New Student entry by Faculty met with Access Denied still creates Student
  • [SSP-1293] - Enforcement of Appointment Creation when Adding/Editing a Student
  • [SSP-1324] - MAP provide an indicator for dev ed courses
  • [SSP-1325] - MAP add an indicator for course notes
  • [SSP-1331] - Early Alert differences in results between double and single clicking.
  • [SSP-1334] - MAP save does not degrade gracefully when serverside error
  • [SSP-1335] - JournalEntry-associated reference data not selected in ComboBoxes if soft-deleted
  • [SSP-1336] - Inactive Electives in Plan Course Details generate 404
  • [SSP-1337] - Can't clear JournalTrack selection
  • [SSP-1344] - API Support for Available Filters
  • [SSP-1345] - Enhance Person Search API
  • [SSP-1361] - Enhance Caseload UI to Support B3 Search
  • [SSP-1362] - Add Course Term Validation For Plan/Multiple Courses to Support Bump
  • [SSP-1363] - Enhance MAP External Data Model for Phase 3
  • [SSP-1365] - mode:'local' should be queryMode: 'local',
  • [SSP-1366] - SSP Header and Main Tool show student username instead of school_id
  • [SSP-1367] - Slow external_registration_status_by_term read queries
  • [SSP-1373] - External min/max credit hour data type changeset does not respect manage_integration_database config
  • [SSP-1374] - MAP add Client Side logic and UI to support 'bump' validation
  • [SSP-1375] - Paginated requests return unlimited results
  • [SSP-1377] - Reset/remove button doesn't show on new journal
  • [SSP-1378] - Is transcript indicator disappears after save
  • [SSP-1379] - Accommodation tool fails to load current accommodation
  • [SSP-1382] - View error on SQL Server
  • [SSP-1386] - Search student by ID doesn't work
  • [SSP-1390] - 000012.xml has hard-coded db username
  • [SSP-1400] - /ssp/api/1/person/coach no longer brings back any coaches
  • [SSP-1401] - Early Alert always loading when using unminified configuration
  • [SSP-1402] - Cleanup retrieval and rendering of associated/selectable records
  • [SSP-1403] - Cleanup retrieval and rendering of associated/selectable records - Student Search
  • [SSP-1404] - Cleanup retrieval and rendering of associated/selectable records - Caseload Assignment
  • [SSP-1405] - Cleanup retrieval and rendering of associated/selectable records - Caseload Reassignment
  • [SSP-1406] - Cleanup retrieval and rendering of associated/selectable records - Challenges Admin
  • [SSP-1407] - Cleanup retrieval and rendering of associated/selectable records - Referrals Admin
  • [SSP-1408] - Cleanup retrieval and rendering of associated/selectable records - Campus Admin
  • [SSP-1409] - Cleanup retrieval and rendering of associated/selectable records - Journal Details Admin
  • [SSP-1410] - Cleanup retrieval and rendering of associated/selectable records - Journal Steps Admin
  • [SSP-1411] - Cleanup retrieval and rendering of associated/selectable records - Electives Admin
  • [SSP-1412] - Cleanup retrieval and rendering of associated/selectable records - Self Help Guides Admin
  • [SSP-1414] - Cleanup retrieval and rendering of associated/selectable records - Main
  • [SSP-1415] - Cleanup retrieval and rendering of associated/selectable records - Intake
  • [SSP-1416] - Cleanup retrieval and rendering of associated/selectable records - Action Plan
  • [SSP-1417] - Cleanup retrieval and rendering of associated/selectable records - Journal
  • [SSP-1418] - Cleanup retrieval and rendering of associated/selectable records - Early Alert (Ext.js Tool)
  • [SSP-1419] - Cleanup retrieval and rendering of associated/selectable records - MAP
  • [SSP-1420] - Cleanup retrieval and rendering of associated/selectable records - Accomodation
  • [SSP-1421] - Cleanup retrieval and rendering of associated/selectable records - Early Alert (portlet)
  • [SSP-1422] - Cleanup retrieval and rendering of associated/selectable records - Reports
  • [SSP-1423] - Cleanup retrieval and rendering of associated/selectable records - MyGPS
  • [SSP-1436] - Fix N+1 performance issue in caseload search result and other bugs found during demo
  • [SSP-1437] - Plan.js isDirty function does not work predictably
  • [SSP-1438] - Document Person Search Assumptions in regards to External Reference Types (or lack thereof)
  • [SSP-1439] - Document SQL statements in update notes for deleting redundant Student Document permissions
  • [SSP-1441] - Color Admin screen only retrieves Active colors
  • [SSP-1442] - Refactor Elective Admin screen to retrieve all Electives based on better standard
  • [SSP-1443] - Non-Students should not show up in Student Search
  • [SSP-1444] - Selecting User with no coach throws error
  • [SSP-1447] - New db config options for controlling external person sync job execution frequency
  • [SSP-1448] - Caseload search without any filters times out
  • [SSP-1449] - IE8 Grayscreen when log in
  • [SSP-1451] - Large number of transcript lookup calls when loading MAP
  • [SSP-1454] - is_dev for plan courses
  • [SSP-1456] - MAP FA and Transcript buttons don't belong on Template page
  • [SSP-1457] - Document new MyGPS MAP APIs
  • [SSP-1463] - Upgrade notes for student document permissions
  • [SSP-1464] - Deleted student still visible in search
  • [SSP-1468] - Create Data/Object Model for Student Documents
  • [SSP-1469] - Implement Sharding/File store mechanism for Student Documents
  • [SSP-1470] - Document new person sync job sizing config options
  • [SSP-1474] - 500 Error adding new student type
  • [SSP-1475] - Document Use Of Student Document Config Vars
  • [SSP-1477] - Sync process causes SQL error in ssp.log
  • [SSP-1478] - 500 error when trying to save new StudentType from admin
  • [SSP-1479] - Validate file type against configurable values
  • [SSP-1481] - MAP template validation after adding a course
  • [SSP-1482] - MAP template save dialog drop-down values incorrect
  • [SSP-1483] - 500 Error on student save (add/edit)
  • [SSP-1484] - Empty term notes created for each plannable term
  • [SSP-1485] - Restore previous person search API
  • [SSP-1486] - Document uP data-import step for granting appointment read/write permissions to faculty
  • [SSP-1487] - Document uP data-import step for adding and granting MAP public template write permission
  • [SSP-1488] - Document SPC/IRSC-style SSO
  • [SSP-1489] - Campus EA routing admin limits person search results to students
  • [SSP-1492] - Cleanup retrieval and rendering of associated/selectable records - Assigned Coaches
  • [SSP-1496] - SSP_STUDENT group not registered with top-level SSP Roles group
  • [SSP-1496] - SSP_STUDENT group not registered with top-level SSP Roles group
  • [SSP-1497] - Template group documentation
  • [SSP-1498] - Document steps for registering SSP_STUDENT group with SSP Roles group
  • [SSP-1500] - Courses rendered twice in MAP API responses
  • [SSP-1501] - Hard-coded schema names in Liquibase scripts
  • [SSP-1502] - Empty query params from student search UI generate warnings in Tomcat logs
  • [SSP-1503] - MyGPS View MAP not scrollable in IE
  • [SSP-1504] - MAP API failure for /current
  • [SSP-1505] - Students in EA rosters don't show
  • [SSP-1506] - MyGPS 'View My MAP' not visible in IE8
  • [SSP-1508] - Restrict visibility of trusted IP list
  • [SSP-1509] - Document new db_schema config property
  • [SSP-1510] - Student Search Permission Denied 403
  • [SSP-1513] - Document changes to Person Search API permissions
  • [SSP-1514] - Cleanup retrieval and rendering of associated/selectable records - Student Documents
  • [SSP-1515] - Fix file size error handling in student documents
  • [SSP-1516] - Can't page config admin after sort
  • [SSP-1517] - Exception swallowed when user logs in with username already bound to a different schoolId
  • [SSP-1519] - Document removal of ObjectStatus "anding" logic
  • [SSP-1521] - Navigation stalls after saving caseload assignment form
  • [SSP-1525] - Paging no longer works after sorting admin items
  • [SSP-1527] - Can't print/email MAP if fewer than 6 current and future terms
  • [SSP-1528] - Appointment Required First Login and Coach Always Required
  • [SSP-1529] - Choosing a different journal track deletes existing track selections in client-side model.
  • [SSP-1530] - Access denied error while impersonating a coach
  • [SSP-1532] - planStatus param on student search API unexpectedly title case-sensitive
  • [SSP-1540] - Main Tool transcript tab produces 500 error
  • [SSP-1542] - Non-nullable columns in external_student_financial_aid should be nullable
  • [SSP-1562] - After the sort in Configuration Options the records were not displayed in CourseWorkHours
  • [SSP-1563] - Caseload assignment fails ungracefully if no special service groups, service reasons, and/or referral sources configured
  • [SSP-1564] - Inter-tool navigation broken after submitting Early Alert Response
  • [SSP-1571] - Misleading/partial logging in ExternalStudentRecordsController
  • [SSP-1573] - Set person.username from external_person
  • [SSP-1575] - Default trusted IP list to localhost
  • [SSP-1578] - Default student documents base upload path to a location inside Tomcat
  • [SSP-1579] - Store student document paths relative to currently configured base path

...