SQLState :38000 error when trying to insert values into External Materialized Views in JBEDS

Solution Verified - Updated -


  • I am trying to test external materialization in JBEDS so I created physical model mv_views based on materializedviews External_CacheViews.supplierinfo. - But when i try to refresh the data as shown below, it throws an error:
INSERT INTO mv_views.supplierinfo 
     SELECT * FROM External_CacheViews.supplierinfo OPTION NOCACHE 

Error: org.teiid.query.sql.symbol.AllSymbol cannot be cast to org.teiid.query.sql.symbol.SingleElementSymbol
SQLState:  38000
ErrorCode: 0


  • 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