[teiid-issues] [JBoss JIRA] (TEIID-3896) When error occurs in the materialization process, an ERROR should be logged instead of DEBUG
Steven Hawkins (JIRA)
issues at jboss.org
Mon Jan 11 12:41:00 EST 2016
[ https://issues.jboss.org/browse/TEIID-3896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13147116#comment-13147116 ]
Steven Hawkins commented on TEIID-3896:
---------------------------------------
> Also, what is this error telling me that's wrong so that I can correct it?
MatViewTable is likely being referred to as just Stock, and there are multiple tables/views with the simple name Stock.
> It appears that this issue is triggering the updating of the status table to "FAILED_LOAD".
Since it fails to do the insert you would expect that the load would fail.
> When error occurs in the materialization process, an ERROR should be logged instead of DEBUG
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3896
> URL: https://issues.jboss.org/browse/TEIID-3896
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Affects Versions: 8.12.2
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Minor
>
> When trying to do materialization, there's an issue (DEBUG) appearing in the server.log:
> 09:58:51,272 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue302) org.teiid.jdbc.TeiidSQLException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ('SELECT count(*) as rowCount FROM ' || matViewTable) AS rowCount integer INTO #load_count" with the SQL statement "('SELECT count(*) as rowCount FROM ' || matViewTable)" due to: Group specified is ambiguous, resubmit the query by fully qualifying the group name: Stock
> I believe this be logged as an ERROR as it appears to be detrimental to what's being materialized.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list