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

ORA-00942 error when table is in external schema

SA-40714

Summary



With a separate database schema, database instances have classes mapped to a table. When using Obj-Browse on this table and addWork against a different class, addWork runs Work-.SaveNew which runs pzLoadCaseHierarchyWrapper. This activity runs a query that fails.


Error Messages



There was a problem getting a list: code: 942 SQLState: 42000 Message: ORA-00942: table or view does not exist


Steps to Reproduce

  1. Create a new schema (external)
  2. Create a Pega table in it with one instance and add a work object in the table
  3. Create a class in Pega (marked as class group) that maps to this new table
  4. Create a Database Table Instance that connects the new class with the new table
  5. Create an activity with the following steps:
    1. Run createWorkPage against a different work- class that supports Work Objects from the main pega data schema
    2. Obj-Open the Work Object instance in the new pega table in a different schema
    3. Set a few properties from this recently opened WO against the Work object that will be created using CreateWorkPage/AddWork
    4. Run AddWork for the new work object
    5. Run a commitWithErrorHandling.


Root Cause



A defect or configuration issue in the operating environment. The database user in the jdbc/PegaRULES datasource did not have select privileges on the table in the external schema.

Resolution



Make the following change to the operating environment:
Grant privileges to query the table to the database user in jdbc/PegaRULES datasource.

Published August 21, 2017 - Updated October 8, 2020

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