Versions Compared

Key

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

...

Info

Released July 20, 2014

Warning

SSP-2721 is a patch added to v2.4.2 and v2.5.2 to address a bug with the CAS integration for filters/requests. All implementers of this release should consider installing the patches listed in the commit section of the issue details.

Release Highlights

  • Significant performance improvements in the MAP tool
  • Added a person directory to allow for searching students in already added in SSP and those only in external data
  • Moved file based configurations to the System Configuration
  • Database performance improvements
  • Validation on each configuration item
  • Priority bugs and stabilization tasks

...

Code Block
SQL to Restart 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) 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 ssp-config.properties file.

...