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

Document ID : KB000027039
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:   
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

 

Solution:   
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.