Versions Compared

Old Version 13

changes.mady.by.user Daniel McCallum

Saved on

compared with

New Version 14

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
If you are upgrading through SSP v1.2.x, be sure to import the uPortal Permissions and Groups changes for that version first:
 
   1. Accommodation API permissions
      ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0/SSP-172/ data-import
   2. MyGPS and Self-Help Guide API permissions
      ant -Dmaven.test.skip=true -Ddir=uportal-war/src/main/data/ssp_entities/patches-SSP-1-2-0/SSP-698/ data-import
 
uPortal Permissions and Groups: All SSP changes introduced 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
        ant -Dmaven.test.skip=true -Dfile=uportal-war/src/main/data/ssp_entities/group_membership/SSP_Roles/SSP_Roles.group-membership.xml data-import

...