Bug 780682 (SOA-3126) - EDS - refreshMatView does not work correctly for an internal materialized view when clustering is enabled
Summary: EDS - refreshMatView does not work correctly for an internal materialized vie...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3126
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.2.0.ER2
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-06-24 14:17 UTC by Steven Hawkins
Modified: 2011-10-21 14:14 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-10-21 14:14:39 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3126 0 None None None Never
Red Hat Issue Tracker TEIID-1657 0 None None None Never

Description Steven Hawkins 2011-06-24 14:17:28 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000007CZMu
project_key: SOA

The refreshMatView works as expected in a single node environment with 'teiid-cache-manager-jboss-beans-rename-me.xml'. Still in a single node environment, that function no longer refreshes the data with "teiid-cache-manager-jboss-beans.xml" enabled.

To recreate:

1. Start up an EDS instance with a vdb deployed which has an internal materialized view (IMV).

2. Query SYSADMIN.MATVIEWS and verify LoadState = "NEEDS_LOADING"

3. Query the IMV to populate the cache.

4. Query SYSADMIN.MATVIEWS and verify LoadState = "LOADED". Note the value of the 'Updated' column

5. run "CALL SYSADMIN.refreshMatView('view name',false)"

6. Query SYSADMIN.MATVIEWS and verify LoadState = "LOADED". Note the value of the 'Updated' column

7. Query the IMV to see if it pulls from the source or cache

Expected results: Steps 3 and 5 should trigger queries to the source. Step 7 should pull from the cache without going back to the source.
Comment 1 Steven Hawkins 2011-06-24 14:17:53 UTC 
Link: Added: This issue Cloned to SOA-3127
Comment 3 David Le Sage 2011-07-15 05:46:30 UTC 
Release Notes Docs Status: Added: Not Yet Documented
Writer: Added: dlesage
Comment 4 David Le Sage 2011-09-27 22:44:27 UTC 
Release Notes Docs Status: Removed: Not Yet Documented Added: Documented as Resolved Issue
Release Notes Text: Added: https://issues.jboss.org/browse/SOA-3126

The refreshMatView no longer refreshed the data with "teiid-cache-manager-jboss-beans.xml" enabled in a single-node environment. A software upgrade has resolved this issue so the refreshMatView now works as expected when clustering is enabled.
Comment 5 Paul Nittel 2011-10-21 14:14:39 UTC 
Tested and closed.
Note You need to log in before you can comment on or make changes to this bug.