Support Article

Pega does not find tables in data schema

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}

 

 

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.