[
https://issues.jboss.org/browse/TEIID-3896?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-3896:
------------------------------------
I just confirmed that Stock wasn't being fully qualified. I tested that theory by
removing the other models that were not needed, but had Stock table, and was able to get
past this issue.
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)