Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube partition not refreshing when proactive caching enabled and cache set to be updated when data changes in datasource Expand / Collapse
Author
Message
Posted Monday, April 12, 2010 8:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:24 AM
Points: 1,865, Visits: 3,620
I have set up a cube partition to "update the cache when data changes" and have enabled proactive caching, yet cube stops refreshing after 1-2 hrs.

Here are the settings:

- Storage mode: MOLAP
- Enable proactive caching
- Update the cache when data changes
- Silence interval : 10 sec
- Silence Override interval: 5 minutes

Anyone know what the issue might be and/or how I can troubleshoot this?


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #901647
Posted Monday, April 19, 2010 2:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 12:48 PM
Points: 2,818, Visits: 2,566
Not sure I can help. But to be clear, the cube refreshes properly for a while (1 to 2 hours) and then mysteriously stops refreshing. Is this correct?
Post #906363
Posted Tuesday, April 20, 2010 11:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:24 AM
Points: 1,865, Visits: 3,620
That's correct, I have opened a case with MS on this issue, still no resolution.

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #907079
Posted Saturday, April 20, 2013 11:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 7:57 AM
Points: 9, Visits: 144
Exact same problem using SQL 2008 R2.
Cubes update with notifications being sent to AS but then randomly it all stops!

Did you get a solution?
Post #1444730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse