SA-9837

Summary

An ORA-04080 error for a missing trigger occurred when out-of-the-box installation script was run. This is a new split-schema installation on Oracle 12 and not an upgrade.

Error Messages

[java] java.sql.SQLSyntaxErrorException: ORA-04080: trigger 'TRPR4_BASE' does not exist
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
.
.
.

Steps to Reproduce

Configure Oracle database, and execute install.sh script from media distribution.

Root Cause

bypass.pega.schema was set True in setupDatabase.properties. This will bypass the creation of the schema objects and implies that the DDL has been applied. However, the base and rules schema were created in the Oracle database with the required privileges, as described in database configuration. The DDL was not applied manually.

Resolution

Set bypass.pega.schema=false, and rerun the script installed to address the reported error.