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 Package with Schema Changes using Import wizard



Getting warning while importing packages which are having schema changes. Schema changes includes creation of tables and indexes in DB but they are not working.

Error Messages

You cannot apply the schema changes automatically. To apply schema changes automatically, you must have the privilege SchemaImport, and the Data-Admin-System-Settings database/AutoDBSchemaChanges must be set to true.

You should download the DDL and use your database tools to apply the changes manually before continuing. You can download the DDL by pressing the button below.

If you continue without schema changes, instances in the archive may not be loaded to the correct tables and your application may not work correctly.


Steps to Reproduce

Import package which are having schema changes using import wizard from Designer Studio.

Root Cause

A defect or configuration issue in the operating environment. AutoDBSchemaChanges requires PROD level 2


Perform the following local-change: 

This issue is resolved through the following local change: Change PROD Level for given PRPC instance to 2 by modifying System Name record. Then go to SMA> Advanced> Conclusion cache and Clear In Memory and In Database Conclusion Cache followed by a JVM restart. Now you should be able to automatically execute SQL and perform schema import.

Published November 22, 2016 - 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