[JBoss JIRA] (TEIID-4321) VDB Validation is showing warnings, but failing deployment

Wednesday, 6 July 2016

    [
https://issues.jboss.org/browse/TEIID-4321?page=com.atlassian.jira.plugin...
] 

Van Halbert commented on TEIID-4321:
------------------------------------

Suggesting something like this:
{code}
            List<Column> matViewColumns = matTable.getColumns();
            Iterator<Column> it = matViewColumns.iterator();
            while (it.hasNext()) {
            	Column c = it.next();
            	if (c.isUpdatable()) {
            		Column tc = table.getColumnByName(c.getName());
            		if (tc == null) {
            			metadataValidator.log(report, model, "Updatable column " +
c.getName() + " in matview " + matTable.getName() + " is not found in
source table " + table.getName());
            		}
                    if(!c.getDatatypeUUID().equals(tc.getDatatypeUUID())){
                        metadataValidator.log(report, model,
QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31194, tc.getName(), table.getName(),
c.getName(), matTable.getName()));
                    }
            	}
            }
{code}

...
 VDB Validation is showing warnings, but failing deployment
 ----------------------------------------------------------

                 Key: TEIID-4321
                 URL: https://issues.jboss.org/browse/TEIID-4321
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 9.x
            Reporter: Van Halbert
            Assignee: Steven Hawkins

 The deployment of a vdb is failing due to 2 warnings:
 13:29:01,076 WARN  [org.teiid.PLANNER.RESOLVER] (Worker2_async-teiid-threads4) 
TEIID31193 Table Persons columns size not same as Materialized View {1}s columns size 
 13:29:01,077 WARN  [org.teiid.PLANNER.RESOLVER] (Worker2_async-teiid-threads4) 
TEIID31194 Column PersonObject in Table Person and Column name in Materialized View
PersonMatView should have same type
 13:29:01,080 INFO  [org.teiid.RUNTIME] (Worker2_async-teiid-threads4)  TEIID40073 The
metadata for the VDB PeopleMat.1 is loaded, however it is not valid. Check models for
errors. Correct the metadata and re-deploy.
 13:29:01,080 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener]
(Worker2_async-teiid-threads4)  TEIID40003 VDB PeopleMat.1 is set to FAILED
 I changed the MetadataValidator class to remove the warnings and the VDB deployed ok.  
If an issue is going to fail deployment, shouldn't it be on an ERROR?
 Regarding the warnings:
 1.  regarding column size, is it required that all columns in the materialized table to
be writable?  
 2.  the 2nd warning was due to the 1st warning.  

--
This message was sent by Atlassian JIRA
(v6.4.11#64026)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009