Relate Query throws exception when OR is part of WHERE clause in MetaMatrix

Solution Verified - Updated -

Issue

  • I'm running a MetaMatrix relate query with a mixture of AND and OR in the WHERE criteria, but I receive the below error message:

[14:08:03] SQL9:<24> SQL Submitted to Server
[14:08:09] SQL9:<24> Exception running query: Multiple predicates in one conjunct use a mixture of explicit and implicit context criteria with use of relate function

  • If I use all AND's the query is successful.

Environment

  • MetaMatrix Enterprise Server 5.5.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content