Summary

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

Unknown

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.

Resolution

1. Set the DSS database or AutoDBSchemaChanges to False
2. Import the RAP file. A prompt to manually download the DDL occurs