Dynamic VDB should contain full path to the materialized table -------------------------------------------------------------- Key: TEIIDDES-2930 URL: https://issues.jboss.org/browse/TEIIDDES-2930 Project: Teiid Designer Issue Type: Bug Components: Dynamic VDBs Affects Versions: 10.0.2 Environment: Fedora 24 Reporter: Matej Kralik Assignee: Barry LaFond Fix For: 10.0.2 Attachments: completeJDGproject.zip, customer-cache-table-info.png, customer-view-info.png, jdgCustomer.zip, screenshot1.png, screenshotProp.png I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error: TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model. I noticed that in the dynamicVDB in the CustomerViewMat model is: {code:java} OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ... {code} I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache) When I set full path, vdb was deployed sucessfully {code:java} OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ... {code}