Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-5201

Convert remaining numeric identifiers in KEW database to character-based identifiers

    Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.0-m6, 2.0
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-9133Convert External Identifier Type to KRAD
      KULRICE-5329Fix numeric comparisons on KEW identifiers that are no longer logical when those identifiers are Strings
      KULRICE-4495Identify locations where client applications are allowed to connect and use the Rice standalone server database
      KULRICE-3111Person lookups by external identifier do not work when identifier is encrypted
      KULRICE-2230Convert KEW to use KIM
      KULRICE-9563Editing permission that has perm id prefixed by "KFS" - receive error message: "The Permission Identifier (Permission Identifier) may only consist of digits."
      KULRICE-12100KIM Attributes are referenced by a non-unique identifier
      KULRICE-13326Analysis: Identify Critical Path Plugins
      KULRICE-13217ORCID identifier needed on the person record
      KULRICE-9424Profile script execution to identify top bottlenecks
    • Rice Module:
      KEW
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      This is a follow-up from KULRICE-4794, whereby we need to convert other "java.lang.Long" identifiers to "java.lang.String".

      1. schema.sql
        239 kB
        Eric Westfall
      2. schema-constraints.sql
        18 kB
        Eric Westfall

        Issue Links

          Activity

          Hide
          James Renfro (Inactive) added a comment -

          I've deleted the attachments (patch and upgrade scripts) since they were slightly out of date. Everything should be checked into trunk now.

          Show
          James Renfro (Inactive) added a comment - I've deleted the attachments (patch and upgrade scripts) since they were slightly out of date. Everything should be checked into trunk now.
          Hide
          Rice-CI User (Inactive) added a comment -

          Integrated in rice-trunk-nightly #112 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/112/)
          KULRICE-5201 added / separators after procedures as some sql clients require
          KULRICE-5201 - updated RuleResponsibility
          KULRICE-5201 : Update scripts - managed not to check them in on the first commit somehow
          KULRICE-5201 - commiting mysql sql update file fix. Needed to drop and add foreign key for certain fields to update.
          KULRICE-5201 - commiting mysql sql update file
          KULRICE-5201 - commiting oracle sql update file
          KULRICE-5201: Convert remaining numeric identifiers in KEW database to character-based identifiers

          This commit should address this issue by converting all remaining numeric ids in KEW to strings.

          Show
          Rice-CI User (Inactive) added a comment - Integrated in rice-trunk-nightly #112 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/112/ ) KULRICE-5201 added / separators after procedures as some sql clients require KULRICE-5201 - updated RuleResponsibility KULRICE-5201 : Update scripts - managed not to check them in on the first commit somehow KULRICE-5201 - commiting mysql sql update file fix. Needed to drop and add foreign key for certain fields to update. KULRICE-5201 - commiting mysql sql update file KULRICE-5201 - commiting oracle sql update file KULRICE-5201 : Convert remaining numeric identifiers in KEW database to character-based identifiers This commit should address this issue by converting all remaining numeric ids in KEW to strings.
          Hide
          Rice-CI User (Inactive) added a comment -

          Integrated in rice-trunk-nightly #115 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/115/)
          KULRICE-5201 - some more database changes for a table that missed as part of the KEW Long -> String identifier conversion

          Show
          Rice-CI User (Inactive) added a comment - Integrated in rice-trunk-nightly #115 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/115/ ) KULRICE-5201 - some more database changes for a table that missed as part of the KEW Long -> String identifier conversion
          Hide
          Rice-CI User (Inactive) added a comment -

          Integrated in rice-trunk-nightly #134 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/134/)
          KULRICE-5201 - table missing from previous changes.

          Show
          Rice-CI User (Inactive) added a comment - Integrated in rice-trunk-nightly #134 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/134/ ) KULRICE-5201 - table missing from previous changes.
          Hide
          Jessica Coltrin (Inactive) added a comment -

          Closing since these items are now in the release notes.

          Show
          Jessica Coltrin (Inactive) added a comment - Closing since these items are now in the release notes.

            People

            • Assignee:
              James Renfro (Inactive)
              Reporter:
              Eric Westfall
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3 days
                3d
                Remaining:
                Time Spent - 1 day, 6 hours, 30 minutes Remaining Estimate - 1 day, 1 hour, 30 minutes
                1d 1h 30m
                Logged:
                Time Spent - 1 day, 6 hours, 30 minutes Remaining Estimate - 1 day, 1 hour, 30 minutes
                1d 6h 30m

                  Structure Helper Panel