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
        • Component/s: Development, Version Compatibility
        • 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. File
            schema.sql
            239 kB
            Eric Westfall
          2. File
            schema-constraints.sql
            18 kB
            Eric Westfall

            Issue Links

            discovered

            Improvement - An improvement or enhancement to an existing feature or task. KULRICE-5329 Fix numeric comparisons on KEW identifiers that are no longer logical when those identifiers are Strings

            • Major - Major loss of function.
            • Open - The issue is open and ready for the assignee to start work on it.
            discovered by

            Improvement - An improvement or enhancement to an existing feature or task. KULRICE-4794 Change DOC_HDR_ID on KREW_DOC_HDR_T from a numeric type to a character type

            • Critical - Crashes, loss of data, severe memory leak.
            • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
            relates to

            Improvement - An improvement or enhancement to an existing feature or task. KULRICE-7802 KREW_RTE_NODE_CFG_PARM_T is selected by a field with no indexes - full table scan every time

            • Critical - Crashes, loss of data, severe memory leak.
            • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
            Trackbacks

            [Confluence: Kuali Rice] Kuali Rice 2.0 Upgrade Notes - Indiana University This is a work in progress. Cross checking with other notes is highly recommended. Overview At Indiana University, we are currently running version 1.0.3 of Kuali Rice. The most recently released version of Kuali Rice is 2.0.0....

              Activity

              Ascending order - Click to sort in descending order
              8 older comments
              Hide
              Permalink
              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
              Permalink
              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
              Permalink
              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
              Permalink
              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
              Permalink
              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