[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2829) Issues with generated dynamic VDB for preview

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