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

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-3896:
------------------------------------

Also, what is this error telling me that's wrong so that I can correct it?    It appears that this issue is triggering the updating of the status table to "FAILED_LOAD".

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