[GRP-210] make stem name index unique Created: 25/Jan/09  Updated: 25/Jan/09  Resolved: 25/Jan/09

Status: Resolved
Project: Grouper
Component/s: API
Affects Version/s: 1.4.0
Fix Version/s: 1.4.1

Type: Improvement Priority: Major
Reporter: Chris Hyzer (upenn.edu) Assignee: Chris Hyzer (upenn.edu)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

make the stem name index unique



 Comments   
Comment by mchyzer [ 25/Jan/09 ]

There was an issue where multiple

  1. 2009/1/25: v1.4.1 GROUPER_1_4_BRANCH: the stem name index was changed to unique from non-unique. Note, if you have problems adding this index, you need to remove stems with duplicate names from the registry. Obviously this needs to be done with care, and you might want to backup before attempting, or contact grouper-dev for help
  • Run: grouper_home/bin/gsh -registry -check
    o Then look at the result script, and execute that script, perhaps with:
    grouper_home/bin/gsh -registry -runsqlfile C:\\mchyzer\\isc\\dev\\grouper_v1_4
    grouper
    ddlScripts
    grouperDdl_20090125_08_39_44_148.sql
  • or you can do this manually, change the stem name index to unique, and update grouper_ddl table Grouper entry DB_VERSION to 13
  • or (not recommended) you could export the registry to backup, rebuild the registry with run:
    o gsh -xmlexport GrouperSystem /whatever/20090125_1_4.xml
    o grouper_home/bin/gsh -registry -drop -runscript
    o gsh -xmlimport GrouperSystem /whatever/20090125_1_4.xml
Generated at Sat Apr 27 04:04:42 UTC 2024 using Jira 9.4.18#940018-sha1:32a59db0b032756f9bbd6a22c656d21edb3fb41f.