[teiid-issues] [JBoss JIRA] (TEIID-4730) Problem with Import VDB with Materialized View (external)

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13357999#comment-13357999 ] 

Steven Hawkins commented on TEIID-4730:
---------------------------------------

In none every vdb version and every importing vdb would maintain it's own materialization.

Shared by name/version would mean that each base vdb would have it's own materialization - vdb.1 and vdb.2 would use different materializations.  However any vdb that imports them would still use the respective materializations of the base vdb.

Fully shared would mean that vdb.1, vdb.2 and all importing vdbs would use the same materialization.  The version is 0 (which we could make generally invalid otherwise) so that they all share based just upon the base vdb name.  

> Problem with Import VDB with Materialized View (external)
> ---------------------------------------------------------
>
>                 Key: TEIID-4730
>                 URL: https://issues.jboss.org/browse/TEIID-4730
>             Project: Teiid
>          Issue Type: Bug
>          Components: Common
>    Affects Versions: 9.1.2
>         Environment: * Teiid 9.1.2
> * CentOs 7
> * WildFly 10
>            Reporter: Pedro Inácio
>            Assignee: Ramesh Reddy
>              Labels: CR1
>             Fix For: 9.2
>
>         Attachments: externalMaterializationOrderProblem-vdb.xml, numberingPlan-vdb.xml
>
>
> 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



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)