ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

relation "XXXXX" does not exist in GEL script

book

Article ID: 212592

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

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.