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 stop Pega from applying Data Definition Language



RAP is present with a class mapping to a view. When user unchecks the checkbox to disable the auto schema change, Pega still applies the Data Definition Language (DDL).

Error Messages

DBA has applied the view DDL, so Pega should not apply the DDL.

Encountered an issue applying DDL: CREATE OR REPLACE VIEW CEP_spine_OWNER.EVENT_dm_vw AS select e."CUSTOMER_ID",e."EVENT_ID",e."EVENT_TYPE",e."ACCT_NUMBER",e."CIF_PDCT_CODE",e."EVENT_TOPIC",e."MESSAGE",e."MESSAGE_TYPE",e."MESSAGE_SUBTYPE",e."MESSAGE_ACTION",e."EXPIRY_DATE",e."SOURCE",e."SOURCE_DATE",e."EVENT_STATUS",e."PUBLISH_DATE",e."CREATED_DATE",e."MOD_TIMESTAMP", mod (ORA_HASH (e.ROWID), 10) partitionkey from EVENT_RT e where e.expiry_date >= sysdate and (EVENT_TYPE = 'CED_DM'): Database-General Problem executing SQL to update database schema 1031 42000 ORA-01031: insufficient privileges DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges | SQL Code: 1031 | SQL State: 42000 -- See the log for additional information.

Steps to Reproduce


Root Cause

Autocreation of schema changes is controlled via the below Dynamic System Setting (DSS) which is true out-of-the-box. If the DSS is true and the RAP has schema changes then the schema changes are created automatically.




Perform the following local-change:
  1. Set the DSS database or AutoDBSchemaChanges to False
  2. Import the RAP file. A prompt to manually download the DDL occurs



Published March 25, 2020 - Updated December 2, 2021

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