- 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
- 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.