Skip to end of metadata
Go to start of metadata

Database patch - 8/13/2010

Issue: Missing Group Permission Preventing Person Group Maintenance

Instructions: Apply the POST-2_0-2010-08-13 sql patch corresponding to your database type to your KC 2.0 database.

Included Fixes:

  • Creates Permission to Populate KC Groups
  • Assigns Permission to Manager and Technical Administrator Roles.

Download:

Database patch - 7/15/2010

Issue: Missing sequence for KC 2.0 and column size mismatch

Instructions: Apply the POST-2_0-2010-07-15 sql patch corresponding to your database type to your KC 2.0 database.

Included Fixes:

  • Create appropriate objects to handle sequence generators for Institutional Proposals.
  • Adjusted column sizes for various foreign key relationships

Download:

Database patch - 7/09/2010

Issue: Missing sequence for KC 2.0

Instructions: Apply the POST-2_0-2010-07-09 sql patch corresponding to your database type to your KC 2.0 database.

Included Fixes:

  • Create appropriate objects to handle sequence generators for Institutional Proposals.

Download:

Database patch - 5/27/2010

Issue: Missing sequence for KC 2.0

Instructions: Apply the POST-2_0-2010-05-27 sql patch corresponding to your database type to your KC 2.0 database.

Included Fixes:

  • Create appropriate objects to handle sequence generators.

Download:

Database patch - 5/20/2010

Issue: The release script that shipped with KC 2.0 specified some of the LAST_UPDT_DT columns in the KIM tables as NOT NULL instead of DEFAULT NULL, which prevents editing of some KIM data through the UI.

Instructions: Apply the POST-2_0-2010-05-20.sql patch script to your KC 2.0 database.

Included Fixes:

  • Remove records where ROLE_ID is null from the KRIM_ROLE_PERM_T table.
  • Include "View Award Budget" permission with "Award Budget Approver" role.
  • Remove Not Null constraint from LAST_UPDT_DT columns in KRIM tables.

Download: POST-2_0-2010-05-20.sql patch

Database patch - 5/15/2010

Issue: Unable to Create/edit Proposal Log records with user "quickstart".

Instructions: If you are using the Sample data that came with KC 2.0, then apply the POST-2_0-2010-05-15.sql patch to your KC 2.0 database. This script uses hardwired keys for the table it is inserting into. If you have added role members, you will need to obtain new key values for these insert statements.

Included Fixes:

  • Set role member qualification attributes for user "quickstart".

Download: POST-2_0-2010-05-15.sql patch

  • No labels