Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us