Support Article

Pega does not find tables in data schema



The below error appears in the logs with Pega 7.2.1.

Error Messages

DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist | SQL Code: 942 | SQL State: 42000
From: (B6B1C03E165BFD735AE78BFCE55C677D1)
SQL: select * from your_table where your_column='1'

Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Steps to Reproduce

Not applicable

Root Cause

An issue in the custom application code or rules. In an RDB style SQL reference to a table can either be directly or via the class reference.

In the former one must provide the schema reference or use the class name to allow the class mapping to do the schema mapping.


Perform the following local-change:

Use an explicit schema reference.


select name from;

Use the {Class:your_class} syntax:
As an example

   avg(kpivalue) as "Mean", 
   STDDEV(kpivalue) as "StdDev", 
   sum(kpivalue) as "Total",
   count(*) as "Count",
   max(kpivalue) as "Max",
   min(kpivalue) as "Min"
from {class:PegaAES-Data-Alert} 



Published September 27, 2016 - Updated October 5, 2016

Have a question? Get answers now.

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