search cancel

Unable to resolve attribute is displayed after clicking "Save" on the Create New Stored Query form.


Article ID: 51171


Updated On:


CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


AHD05800:Bad where clause. invalid constraint. Unable to resolve group_prev.last_name.


CA Service Management 17.1 and higher.


The attributes of objects that are included in stored queries are translated and incorporated into SQL statements for processing by the underlying DBMS engine. However, an attribute that is defined with a type of LOCAL does not correspond to a column of a database table. Therefore, LOCAL attributes cannot be used in stored queries.


Figure 1 below is a sample of the message received when you attempt to save a stored query that includes a LOCAL attribute.

The bop_sinfo command can be used to check whether or not an attribute is defined as LOCAL. Figure 2 below shows that the group_prev attribute of the iss object is defined as a LOCAL LREL.

LOCAL attributes that are included in the out-of-the-box product are used for implementing internal functions, such as triggers on status transitions.