SA-28513

Summary

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.

Resolution

Perform the following local-change:

Use an explicit schema reference.

Example:

select name from your_schema.city;

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

select 
   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} 
where 
   ProblemCorrelation={pyWorkPage.ProblemCorrelation}