Support Article
Unable to import CMF 7.12 Application Bundle into Pega 7
SA-13250
Summary
While installing CMF 7.12 Application Bundle, an error is generated when trying to import the AB_CMF_712_for_Pega_71.jar file.
SQL: ALTER TABLE RULES.pr4_rule MODIFY pyAccessibilityLevel NUMBER (10,0)
ERROR: Database-General Problem executing SQL to update database schema 1440 72000 ORA-01440: column to be modified must be empty to decrease precision scale.
There are problems applying changes to the database object: pr4_rule SL: ALTER TABLE RULES.pr4_rule MODIFY pyAccessibilityLevel NUMBER (10,0) ERROR:
Error Messages
ORA-01440: column to be modified must be empty to decrease precision or scale
Steps to Reproduce
1. Install and Configure PegaSurvey 7.1 and Healthcare Industry Foundation 7.12 as per the documentation.
2. Import HCIF Sample Data to verify the HCIF installation.
3. Install CMF 7.12.
Root Cause
In out-of-the-box Pega 7.1.7, define the column, PR4_RULE.pyaccessibilityLevel as number data type. In Oracle, the number datatype precision can range from 1 to 38 and scale can range from -84 to 127. However, the migration script, AB_CMF_712_for_Pega_71.jar\CMF_7_12_22_jan_schema.jar\pegarules...pr4_rule.xml indicates to change the precision to 10 <column dbtypename="INTEGER" name="pyAccessibilityLevel" size="10" type="INTEGER"/>.
Resolution
1. Import AB_CMF_712_for_Pega_71 referring CMF upgrade guide.
2. When asked to apply schema changes, it gives checkbox to apply schema changes manually or automatic. Choose the Manual option
3. Download the SQL. Remove following ALTER statements and Execute.
ALTER TABLE ENG_TE_2727_RULES.pr4_rule MODIFY pyAccessibilityLevel NUMBER (10, 0);
ALTER TABLE ENG_TE_2727_RULES.pr4_rule MODIFY pyBrowserSupportLevel NUMBER (10, 0);
Published August 28, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.