]
Barry LaFond commented on TEIIDDES-2930:
----------------------------------------
I imported the attached project and had some issues with it. Re-set the project to start
Materialization from the top View (deleted jdg-module, cache and vdb).
1) The materialized View is required to have a PK in order to create the POJO, I think
2) I've attached screen caps of the properties for the View's mat table and the
primary table property on the generated ST_Customer table.
- both properties contain: 'CustomerMatCache.Customer'
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: 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}