search cancel

Clarity PPM - NPT-0120 thrown when using Display Mappings on an NSQL attribute in Postgres DB systems

book

Article ID: 188651

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE:
Note: Issue is only on a Postgres based system.
1. Create a query using the following (Administration -> Queries):
select
@select:dim:user_def:implied:query130420:temp.col0:[email protected],
@select:dim_prop:user_def:implied:query130420:temp.col1:[email protected]
from
(
 select 1 as col0, 10 as col1
 
 union
 
 select 2 as col0, 10 as col1
 
 union
 
 select 3 as col0, 20 as col1
 
 union
 
 select 4 as col0, 30 as col1

)temp
where @[email protected]

2. Click on "Attributes" tab. Click on "status_id"
3. Choose "Extended Data Type" = "Lookup - Numeric". Choose "Lookup" = "Status Report Status". Save.
4. Choose values under "Display Mapping" section. Save.

Expected Result: Display Mappings get saved.
Actual Result: 
The following error gets thrown.
"NPT-0120: There was an error while handling your request. Make sure your NSQL/SQL syntax is correct. Note that the : and @ delimiter characters used in expressions must be escaped with \."

Cause

This issue is caused due to a defect with ID DE54393.

Environment

Version: 15.8.0.

Resolution

The defect is under review by Product Management.