Cube processing failures in sql server analysis services 2008 r2 sp2

Question

Post reply

Cube processing failures in sql server analysis services 2008 r2 sp2

Scott Keatinge

Old Hand

Points: 319
More actions
July 17, 2013 at 8:46 am

#148294

Hello all,
Does anyone know how to debug cube processing failures in sql server analysis services 2008 r2 sp2?
SQL Profiler doesn't seem to help and nor does the SQL Server logs.
Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

When you manually process the cube (through SSMS) what is the error(s) it is spitting out?

Scott Keatinge Old Hand Points: 319 More actions · Answer 2

That's the problem, as most of the time the cubes process successfully, especially when ran manually.

It would be great if SSAS has a debug mode that captures the exact reason why the cube processing fails to a file, as the schedules are late at night, and processing only occasionally fails.

jakob_beck SSC Rookie Points: 34 More actions · Answer 3

You can find it in the flightrecorder.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7f5f32da-40a6-4d65-b7f6-bef85a721924/what-is-the-flight-recorder