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.

Troubleshooting "ORA-00942 table or view does not exist" (Oracle COMPATIBLE parameter supports system pulse)

Suggest edit Updated on September 13, 2021

Summary

The Oracle database hosting Process Commander must have the COMPATIBLE parameter set to 8.1.0.0.0 or greater for the System Pulse to work correctly.

 

 

Suggested Approach

V3.1 makes use of record-level caching to reduce the load on the network and database.  In a system with multiple nodes accessing one PegaRULES database, rules caching can get out of sync; the System Pulse makes sure that each node is using the most updated rule details..  

However, the System Pulse process creates a temporary table.  Unless the Oracle COMPATIBLE parameter is set correctly (to 8.1.0.0.0 or greater), the temporary tables cannot be created, and errors result:

15:55:53,539 [    PegaRULES-Batch-4] (   engine.database.DatabaseImpl) ERROR - There was a database problem when performing an ExecuteStoredProc: ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "RULESQA.SPPR_SYS_UPDATESCACHE_PREPARE", line 93
ORA-06512: at line 1
java.sql.SQLException: ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "RULESQA.SPPR_SYS_UPDATESCACHE_PREPARE", line 93
ORA-06512: at line 1

 

Did you find this content helpful? YesNo

0% found this useful

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us