Error AHD05800: Bad where clause. AHD03106: Where clause results in a Cartesian product

Products

• 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

Issue/Introduction

Symptoms: 

Error Message: 

AHD05800:Bad where clause. AHD03106:Where clause results in a Cartesian product 

       i.e.

(category IS NULL) OR (category.sym NOT LIKE 'XXXXXX%') 

 

(category IS NULL) OR (category.id <> xxxxxx AND category.id <> xxxxxx) 

Environment:  

CA Service Desk 14.1

Cause: 

Wrong written constraint 

Resolution:

The correct constraint that would be properly use for this case, its:

(category IS NOT NULL and category !='pcat:xxxxxx') or category IS NULL

 

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: