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

Issues with generated dynamic VDB for preview

    XMLWordPrintable

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

      Attachments

        Activity

          People

            blafond Barry LaFond
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: