NPT-0117 Structural changes are not allowed for the query that is already in use

Products

• Clarity PPM On Premise

Issue/Introduction

We tried removing a column name from an NSQL Query which is already existing and we received an error message while trying to save the changes.

     NPT-0117: Structural changes are not allowed for the query that is already in use 

Environment

Release: All Supported Releases
Component: Clarity PPM Studio

Cause

• This message indicates that a Portlet has been created that uses this NSQL Query.
• The Clarity PPM application does not allow structural changes to the underlying NSQL Query because it will impact the Portlet that uses the query.
• The portlet does not have the ability to detect a structural change.

Resolution

Possible workaround is to change the structure of a query by removing parameters or fields, is to uncheck "AVAILABLE FOR USER PORTLETS" from the Query properties page, Click Save and Continue to get to the NSQL tab and then proceed to modify the NSQL tab and change the structure of NSQL as desired and finally save and return.

 

If the workaround does not work then you want to try the remaining two options:

• • Delete the existing Portlet, then the structure of your NSQL query can be modified.
  • Copy the existing NSQL Query and modify the new query to meet your needs. Then create a new Portlet to link to the new Query.