Question

4
Replies
419
Views
JanmajayA6339 Member since 2018 3 posts
HSBC
Posted: December 3, 2018
Last activity: May 29, 2019
Closed

ORA-00942: table or view does not exist, when trying to execute RDB-List method.

Hi All,

I have a db query, Select * from {class:A} f where f.PXINTERACTIONID in
(select interactionid from {class:B}
where passedlimit='false' and campaignrunid = '{ASIS : MTemp.CAMPAIGNRUNID}' )

The problem is when I hard code the schema and table names then only above query runs, else we get an error "ORA-00942: table or view does not exist ". However I when I do Test Connectivity from Connect-Sql rule with class references, the schema and table name are picked up correctly and test connectivity is successful.

Database Table mapping is also in place and Test Connectivity work fine.

Any suggestions why this could be failing?

***Edited by Moderator: Pallavi to update platform capability tags***

Pega Customer Decision Hub Data Integration
Moderation Team has archived post
Share this page LinkedIn