Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2829

Issues with generated dynamic VDB for preview

    Details

      Description

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                mdrillin Mark Drilling
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: