relation "XXXXX" does not exist in GEL script

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We are trying to run a GEL script, and it fails with error: 

ERROR: relation "dual" does not exist. PL/pg SQL function niku.trigger_fct_t_resource_pprj_resources()

This issue can occur on other tables and database objects. If we run the SQL directly, it works with no issue. 

Environment

Release : Any

Component : CA PPM GEL SCRIPTS

Resolution

Issue with a way the database connection is defined in the sql:update in GEL. Once corrected, it should start working as expected.