[teiid-issues] [JBoss JIRA] (TEIID-4321) VDB Validation is showing warnings, but failing deployment
Van Halbert (JIRA)
issues at jboss.org
Wed Jul 6 16:35:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262358#comment-13262358 ]
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)
More information about the teiid-issues
mailing list