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).
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
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:
- Set the DSS database or AutoDBSchemaChanges to False
- Import the RAP file. A prompt to manually download the DDL occurs
0% found this useful