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

Solution Verified - Updated -

Issue

  • 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; java.io.NotSerializableException: com.sun.jndi.ldap.LdapCtx

Environment

  • MetaMatrix Enterprise Server 5.5.4
  • MetaMatrix LDAP Connector

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.