Upgrade fails with OutOfMemoryError on NSQL validation

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Clarity Upgrade fails on NSQL validation: 

2/17/25 5:02 PM (Echo) Validating NSQL
2/17/25 5:02 PM (Java) Validating 472 NSQL grid/graph queries...
2/17/25 5:02 PM (Java) Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
2/17/25 5:02 PM (Java)     at java.base/java.util.Arrays.copyOfRange(Arrays.java:3822)
2/17/25 5:02 PM (Java)     at java.base/java.lang.StringUTF16.newString(StringUTF16.java:1179)
2/17/25 5:02 PM (Java)     at java.base/java.lang.StringBuffer.toString(StringBuffer.java:717)
2/17/25 5:02 PM (Java)     at com.niku.union.persistence.nsql.Utils.parse(Utils.java:130)

Environment

All Supported Clarity Releases

Cause

There is likely a bad custom NSQL query causing the problem

Resolution

1. Rollback, connect to Clarity Classic UI - Administration and review the NSQL Queries
2. Clean up and remove any old, obsolete, unused NSQL queries
3. Retry the upgrade