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

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 “ “.

Environment

Release : 15.8 and higher

Component : CA PPM SAAS STUDIO

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

Resolution

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