Error code ERR.015.006.0033 generated running query in JBEDS
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.