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

book

Article ID: 40978

calendar_today

Updated On:

Products

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

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: