Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4730

Problem with Import VDB with Materialized View (external)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.2
    • 9.1.2
    • Common
    • Hide

      1) Create a VDB that contains a model with external materialization that defines a table
      2) Create a second VDB with external materialization that imports the previous one, and uses the table defined in the first step.
      3) Import VDB on Teiid server.
      4) The error occurs.

      Show
      1) Create a VDB that contains a model with external materialization that defines a table 2) Create a second VDB with external materialization that imports the previous one, and uses the table defined in the first step. 3) Import VDB on Teiid server. 4) The error occurs.

    Description

      Having defined a VDB which contains a Model that has External Materialization, when importing this VDB into another that also uses External Materialization, Teiid Server is searching in the wrong place for the view status.

      Example:

      ..
      <import-vdb name="CountryServiceListVDB" version="1" import-data-policies="true"/>
      ...
      <model name="MyView" type="VIRTUAL">
      ...
      SELECT cns,
      country_code
      FROM NumberingPlan.numbering_plan;
      ....
      </metadata>
      </model>

      NumberingPlan.numbering_plan is defined in the imported VDB, and is also Materialized.

      *Warning in Logs: *

      17:51:45,161 WARN [org.teiid.MATVIEWS] (Worker8_QueryProcessorQueue10653) n9M6de3y5xHM org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'ExternalMaterializationOrderProblem' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2): TEIID30328 Unable to evaluate mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION'): TEIID30384 Error while evaluating function mvstatus

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            pringi Pedro Inácio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: