Sub-Query with NOT EXISTS clause throws an error in MetaMatrix

Solution Verified - Updated -


  • We are getting an error in running simple sub-query as shown below.

    SELECT a.* 
    FROM ERStudio_Repository_View.DMREPO4.REPO_USER AS a
    WHERE not exists (select 'x' 
                                     from Public_Views.PEOPLE AS b
                                     where a.unix_nm = b.user_id)
    SQL1:Exception running query: writing aborted; com.sun.jndi.ldap.LdapCtx


  • MetaMatrix Enterprise Server 5.5.4
  • MetaMatrix LDAP Connector

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