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

Schema changes fail during Jar file import

SA-9766

Summary



When importing a jar file with schema changes, Pega does not automatically apply the schema changes to the database even though the database account that Pega is using has the necessary privileges and the dynamic system setting "database/AutoDBSchemaChanges" is set to true. A warning screen is displayed stating that Pega cannot automatically apply schema changes. The role is SysAdmin4.

Error Messages



Not Applicable 

Steps to Reproduce



1. Select Application > Distribution > Import
2. Select a jar with schema change to import
3. Select “Automatic: PRPC applies the database schema changes using the database user defined in the database configuration”
4. Warning screen is displayed stating that auto schema changes cannot be applied even though you use
SysAdmin4 role, and the dynamic system setting “database/AutoDBSchemaChanges” is set to true.

Root Cause



The production level of the target system is 3 but the SysAdmin4 role only allows import schema changes for production level of 2 or less.

Resolution



This issue is resolved by making the following change to the operating environment: 

The below article provides details on the privileges needed to automatically perform schema changes within Pega.

http://pdn.pega.com/node/2103


By default, the Access of Role of Object rule for the SysAdmin4 role sets the privileges for ImportSchema to production level of 2 or less. To allow schema changes you would either need to change the production level to be 2 or less or you must change the level of the corresponding privileges in the Access of Role to Object rule for SysAdmin4 (or your own version of that rule). 

If you opt to change the production level to import, then clear the conclusion cache In Memory and In Database and then restart the JVM. The other option is to not change the settings and manually create the tables in the database.

Published June 12, 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