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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In