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

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

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 or higher

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