Details

    • Type: Bug Fix
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2.5
    • Component/s: Database
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Include in Release Notes?:
      Yes

      Description

      KPME uses a rice upgrade script that appears to possibly have a bug in it in

      • rice-2.2/config/scripts/upgrades/2.2.1 to 2.2.2/db-updates-client/2013-03-18.sql
      • rice-2.2/config/scripts/upgrades/2.2.1 to 2.2.2/final/update_client_final_oracle.sql

      A variable "c" did not get changed to "temp":

      SQL> start /home/tktstb/batch/time_migration/update_client_final_oracle222-clean.sql
      SQL> –
      SQL> – KULRICE-9179: KRAD_MSG_T not in client dataset upgrade scripts
      SQL> –
      SQL> DECLARE temp NUMBER;
      2 BEGIN
      3 select count into c from user_tables where table_name = upper('krad_msg_t');
      4 IF temp = 0 THEN EXECUTE IMMEDIATE
      5 'CREATE TABLE krad_msg_t ( nmspc_cd VARCHAR2(20) NOT NULL, cmpnt_cd VARCHAR2(100) NOT NULL, msg_key VARCHAR2(100) NOT NULL, loc VARCHAR2(255) NOT NULL, obj_id VARCHAR2(36) NOT NULL, ver_nbr DECIMAL(8) DEFAULT 1 NOT NULL, msg_desc VARCHAR2(255), txt VARCHAR2(4000) )';
      6 END IF;
      7 END;
      8 /
      select count into c from user_tables where table_name = upper('krad_msg_t');
      *
      ERROR at line 3:
      ORA-06550: line 3, column 24:
      PLS-00201: identifier 'C' must be declared

        Attachments

          Activity

          Hide
          gilesp Peter Giles (Inactive) added a comment -

          Fixed the scripts with the bug, and added a note to https://wiki.kuali.org/display/KULRICE/Upgrade+Troubleshooting

          Show
          gilesp Peter Giles (Inactive) added a comment - Fixed the scripts with the bug, and added a note to https://wiki.kuali.org/display/KULRICE/Upgrade+Troubleshooting

            People

            • Assignee:
              gilesp Peter Giles (Inactive)
              Reporter:
              jr72 Justin Robinson (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: