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

book

Article ID: 51171

calendar_today

Updated On:

Products

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

Issue/Introduction

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

Cause

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.

Environment

CA Service Management 17.1 and higher.

Resolution

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.

Attachments