Page Comparison

...

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

If you are upgrading through SSP v1.2.x, be sure to importexecute the uPortal Permissionsdata andmigrations Groups changes for that version first:.  This can be done 1.in Accommodationa APIsingle permissionscommand:
  
    ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0/SSP-172/ data-import
 
Then execute the 2. MyGPS and Self-Help Guide API permissions0.0 migrations:
 
        ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0/SSP-6980/ data-import
 
uPortalThen Permissionsupdate andthe Groups:list Allof SSPchild changesgroups introducedfor in 2.0-b3 can be completing by importing data through an ant build with the following command
    1. ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-2-0-0/ data-import

Or, to import changes individually, the following imports can be run.

    1.  Creates MAP public template write permission and SSP_MAP_TEMPLATE_ADMIN role
        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 and SSP_MAP_TEMPLATE_ADMIN roles to the uPortal SSP Roles Group
   the 'SSP Roles' group:

   ant -Dmaven.test.skip=true -Dfile=uportal-war/src/main/data/ssp_entities/group_membership/SSP_Roles/SSP_Roles.group-membership.xml data-import

...

Versions Compared

Old Version 14

New Version Current

Key

Upgrade Notes: