Error code ERR.015.006.0033 generated running query in JBEDS

Solution Verified - Updated -

Issue

  • We get the above error code when our application attempts to execute the following SQL against a model in which the SourceCM.PARENT_CHILD view table is populated via a Teiid Virtual Procedure. If we instead model this table by selecting data directly from a base table then the SQL is successful.
SELECT E0.ID AS C0,
    R.ID AS C1 
FROM SourceCM.DEPENDANTS AS R 
LEFT JOIN (SourceCM.PARENT_CHILD AS E0 
        JOIN SourceCM.TOP AS E1 
        ON E0.PARENT_ID=E1.ID) 
ON R.PARENT_ID=E0.ID
WHERE E1.NAME='Tree 1' 
GROUP BY E0.ID,R.ID ORDER BY C1 LIMIT 0,5000

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.2.0

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