[teiid-issues] [JBoss JIRA] (TEIID-4011) automatic/autonomous refresh of materialized views does not work
Steven Hawkins (JIRA)
issues at jboss.org
Wed Mar 2 17:07:00 EST 2016
[ https://issues.jboss.org/browse/TEIID-4011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4011.
-----------------------------------
Fix Version/s: 9.0
8.12.5
8.13.2
Resolution: Done
The sql for the ttl based refresh was incorrect. Only the initial load would work when ttl was not set.
> 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
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list