NPT-0103 syntax error near “ “ when saving a query in Clarity Postgres

book

Article ID: 199822

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When trying to save changes to a NSQL query in Clarity, get error: NPT-0103 syntax error near “ “.

Cause

This indicates some kind of incompatible character in the query, one reason this could happen is if the query was copied from another tool / application

Environment

Release : 15.8 and higher

Component : CA PPM SAAS STUDIO

Resolution

Check for any character issues in the query that may require reformatting to be able to be added into Clarity.