Bug 780682 (SOA-3126)

Summary: EDS - refreshMatView does not work correctly for an internal materialized view when clustering is enabled
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Steven Hawkins <shawkins>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0 GA   
Target Milestone: ---   
Target Release: 5.2.0.ER2   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3126
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-10-21 14:14:39 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

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.