Support Article
Obsolete trigger error with CPM 7.1.3 on Pega 7.1.8
SA-12404
Summary
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:
com.pega.pegarules.pub.database.DatabaseException: 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>
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.