Joining two virtual tables that wrap DV SYS views results in ASSERTION FAILED

Solution Verified - Updated -

Issue

  • When joining together 2 virtual tables that virtualize Teiid SYS tables (Columns, Tables, and Properties), although the data comes back from each half of those joins, seperately, as not null, the query errors with ASSERTION FAILED exception:
15:28:55,188 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue45) kcayzLVMEpN7 TEIID30019 Unexpected exception for request kcayzLVMEpN7.0: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
    at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:365) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:178) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:167) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:507) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:499) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTableDataManager$5.createTupleSource(TempTableDataManager.java:663) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]
    at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.9.0.Final.jar:8.9.0.Final]

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.1

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
Close

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