Question

2
Replies
714
Views
Janmajay Adhikari (JanmajayA6339)
HSBC

HSBC
IN
JanmajayA6339 Member since 2018 3 posts
HSBC
Posted: November 29, 2018
Last activity: March 5, 2019
Posted: 29 Nov 2018 6:16 EST
Last activity: 5 Mar 2019 5:25 EST
Closed

Connect-Sql RULE : Class References in query are not getting evaluated to Schema.TableName

Hi All,

I have a db query, Delete 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.

Database Table mapping is also in place.

Anyone faced this issue before?? Please help

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Enterprise Application Development Dev/Designer Studio Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.