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

Problem with Import VDB with Materialized View (external)

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 9.1.2
    • Fix Version/s: 9.2
    • Component/s: Common
    • Labels:
    • Environment:
      • Teiid 9.1.2
      • CentOs 7
      • WildFly 10
    • Steps to Reproduce:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rareddy Ramesh Reddy
                Reporter:
                pringi Pedro Inácio
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: