Cubes not reprocessing

Last Post 31 Jul 2004 06:36 AM by Shill_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Shill_SQL
New Member
New Member

--
31 Jul 2004 06:36 AM
I have noticed that the two cubes we use are not reprocessing as they should.

The tasks that reprocesses the cubes is a scheduled DTS package. The task executes without a problem Mon - Thurs but on Fridays and over the weekend the task seems to run without completing. The fact tables for the two cubes have approx 15 million and 70 million records respectively and I am of the view that it is not related to the amount of data within the tables.

The only way to reprocess the cubes is either to restart the server or stop/start the analysis service.

I haven't had this problem before and am curious as how to cure the problem and prevent it occurring. Hope someone has seen this behaviour and has a solution.

You are not authorized to post a reply.

Acceptable Use Policy