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

Obsolete trigger error with CPM 7.1.3 on Pega 7.1.8



After installing CPM 7.1.3 on Pega 7.1.8 and restarting the application server, an error is observed in SystemOut log file and the system is unavailable.

Error Messages

Error: Caused by: Database-General Unable to check for obsolete database triggers 904 42000 ORA-00904: : invalid identifier
From: (unknown)
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

Steps to Reproduce

1. Install Pega 7.1.8
2. Install CPM 7.1.3
3. Restart application server and attempt to login.

Root Cause

The root cause of this problem is a defect in Pegasystems’ code/rules. This issue is also discussed in Support Article SA-10899. Here are the essential details:

Symptom: When installing CPM 7.1.3 (prior to importing jar files) and attempting to start the Pega 7.1.8 instance the following errors are received:

Unable to check for obsolete database triggers 31603 99999 ORA-31603: object "PWBV4_CIRCUMSTANCE_DUPLICATES" of type
VIEW not found in schema <rule schema name>


This issue is resolved through the following local-change:

1. Have your database administrator execute a script to drop all CPM triggers. An example script may be provided by Global Customer Support.

2. Ensure that there are *no* Pega triggers that write to pr_sys_updatescache (under the data schema), and pr4_rule_vw table (under the rules schema). All the triggers should be dropped during the update process, but this is just to double-check.

3. Disable the startup trigger check by setting the following prconfig setting to false (the default is true): database/performTriggerCheckAtStartup. Once this is done, it must be ensured that no triggers like those in step-2 are installed again.

Published July 24, 2015 - 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