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.