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
This message indicates that a Portlet has been created that uses this NSQL Query. If you want to change the structure of a query by removing parameters or fields, there are two options:
1. Delete the existing Portlet, then the structure of your NSQL query can be modified.
2. 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.
The CA 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.