]
Matej Kralik updated TEIIDDES-2829:
-----------------------------------
Labels: verified_jbdsis-9.0.1 (was: )
Issues with generated dynamic VDB for preview
---------------------------------------------
Key: TEIIDDES-2829
URL:
https://issues.jboss.org/browse/TEIIDDES-2829
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 10.0.1
Reporter: Mark Drilling
Assignee: Barry LaFond
Labels: verified_jbdsis-9.0.1
Fix For: 10.0.1
Imported from SF then tried to preview the Accounts table. The generated dynamic VDB
(attached) will not deploy.
1) 'Default value' property = Generated upon completion
Results in following deployment error
TEIID50036 VDB PREVIEW_SFModel_Account.1 model "SFModel" metadata failed to
load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100
Parsing error: Encountered "NOT NULL DEFAULT [*]Generated[*] upon completion" at
line 3, column 40.
2) includes FK defns which result in this:
[org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 3) TEIID31092 Foreign Key definition
on view SFModel.Account points to non-existent table User_ on schema SFModel. Fully
qualify the Reference Table name including the schema name.
[org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 3) TEIID31092 Foreign Key definition
on view SFModel.Account points to non-existent table User_ on schema SFModel. Fully
qualify the Reference Table name including the schema name.
[org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 3) TEIID31092 Foreign Key definition
on view SFModel.Account points to non-existent table User_ on schema SFModel. Fully
qualify the Reference Table name including the schema name.
[org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40073 The metadata for the VDB
PREVIEW_SFModel_Account.1 is loaded, however it is not valid. Check models for errors.
Correct the metadata and re-deploy.
[org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB PREVIEW_SFModel_Account.1 is
set to FAILED