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

Dynamic VDB should contain full path to the materialized table

    Details

    • Steps to Reproduce:
      1. Import project
      2. Generate dynamic VDB

      Description

      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:

      OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ...
      

      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

      OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ...
      

        Gliffy Diagrams

          Attachments

          1. completeJDGproject.zip
            194 kB
          2. customer-cache-table-info.png
            customer-cache-table-info.png
            37 kB
          3. customer-view-info.png
            customer-view-info.png
            35 kB
          4. jdgCustomer.zip
            155 kB
          5. screenshot1.png
            screenshot1.png
            85 kB
          6. screenshotProp.png
            screenshotProp.png
            48 kB

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  mkralik Matej Kralik
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: