Details
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
Fixed the scripts with the bug, and added a note to https://wiki.kuali.org/display/KULRICE/Upgrade+Troubleshooting