]
Steven Hawkins updated TEIID-4011:
----------------------------------
Component/s: Query Engine
automatic/autonomous refresh of materialized views does not work
----------------------------------------------------------------
Key: TEIID-4011
URL:
https://issues.jboss.org/browse/TEIID-4011
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12.3
Reporter: Marco Ardito
Assignee: Steven Hawkins
configuring a materialized view (snapshot) to be automatically refreshed/reloaded does
not happen, even with option "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" true.
(see forum reference for full vdb details)
server log reports:
WARN [org.teiid.PROCESSOR] (Worker110_QueryProcessorQueue3121) KbqgRXX20t5r TEIID30020
Processing exception for request KbqgRXX20t5r.0 'TEIID31100 Parsing error: Encountered
"[*]SYSADMIN.refreshMatView[*](\"views\".\"dati_mat\"" at
line 1, column 1.
Was expecting: "alter" | "begin" | "call" |
"create" | "delete" | "drop" | "exec" |
"execute" | "insert" | "merge" ...'. Originally
QueryParserException QueryParser.java:214. Enable more detailed logging to see the entire
stacktrace.
since the view has a ttl of 120000 the above log appears every two minutes.