[teiid-issues] [JBoss JIRA] (TEIID-3896) When error occurs in the materialization process, an ERROR should be logged instead of DEBUG

[Steven Hawkins (JIRA)]

    [ 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)