Error on running a CABI (BOXI) report: "A database error occurred. AHD03053: Bad where clause: invalid constraint. Unable to resolve log_agent.combo_name.. (WIS 10901)"

book

Article ID: 19025

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

Description:

When a customized BOXI report is launched, the following error message is returned: A database error occured. The database error text is: [DataDirect][ODBC
OpenAccess SDK driver][OpenAccess SDK SQL Engine]AHD12002:Error in QueryHandler ServiceDesk-840759197-1 in method fetch_response: AHD03053:Bad where clause: invalid constraint. Unable to resolve log_agent.combo_name.. (WIS 10901)

Solution:

The problem is due to having the 'Derived' attribute (combo_name) involved in the query, there is a limitation on this type of attribute:

"CA SDM DERIVED attributes (such as combo_name) can be used in the selection list only. They are not supported in any other part of the query, including in the WHERE clause."

To overcome the limitation of including Combo Name in the WHERE clause, many 'Combo Name With Userid' objects have been provided in the universe.

These objects allow Combo Name to be used as filter prompts in ad hoc queries with Web Intelligence.

The above note, together with other details, can be found in:

"CA Service Desk Administration Guide", "17: Managing Reports", "Write CA Business Intelligence Reports", "Write SQL for BusinessObjects Reports"

Environment

Release: UAPMAC990JPP-12.9-Asset Portfolio Management-Asset Configuration
Component: