Cube processing

Category: sql server dw

Question

rkaura on Tue, 02 Oct 2012 04:46:15


Hi When i try to process SSAS cubes, sometimes i get a blank screen for the entire interval of processing and then the final message. This seems to be an SSAS bug. Has anyone faced this issue. Do we need to make any changes to the processing options for this?

Replies

Olaf Helper on Tue, 02 Oct 2012 05:32:26


i get a blank screen for the entire interval of processing
Yes, I faced this issue also sometimes. Currently I don't know when this occurs and how to reproduce this behaviour.

rkaura on Thu, 04 Oct 2012 00:14:36


Hi,

    The problem is, everytime i am not able to view the progress, i have to cancel and restart the processing so i know what is going on. That is time consuming.

Regards

rag

Yogisha Bhat on Thu, 04 Oct 2012 06:44:53


Even I am facing this problem 2008r2.

You need not  cancel and restart procesing to come to know what is happening. Connect to SQL Server Profiler and in that Analysis Service engine. Select the events and run the trace. You will get all the details.

Regards,

YB

Ashish Tambe on Thu, 04 Oct 2012 07:02:49


  

      Hi rKaura,

      This is a known bug for SSAS and Microsoft said its been fixed in 2012 (Denali). Please see support ticket below,

       http://connect.microsoft.com/SQLServer/feedback/details/536543/ssas-process-progress-window-blank-no-details

      Previously when i faced this issue, one weired solution worked for me and that is to restart SSAS service.

      Ofcourse its not viable solution but atleast by somehow it was showing trace again while processing.

Maciek Sowa on Fri, 23 Nov 2012 12:09:38


I still have the same issue on SQL 2012 RTM running on Windows Server 2008 R2 Enterprise and it's driving me crazy!

Tampa on Mon, 06 May 2013 01:07:52


I'm seeing it when processing in SQL 2012 or from VS2012. Very annoying.

iMarcelino on Fri, 03 Jun 2016 08:32:01


Finally! I have figured out the root cause of this problem. It takes literally seconds to fix: when you process SSAS objects, the progress window is nothing but a log it writes at run time. What if you have no disk space when he tries to write the log? It doesn’t. So, the fix really is just a matter of freeing up disk space on the drive you have the SSAS logs being stored. Done!