More OLAP Issues

[Micah]

Hello,
We have been building OLAP cubes for a few weeks now with 2007. They build
nightly at 11:30 and take about 10-15 mins. Last week, we got the error below
one morning. We restarted Analysis Services on our SQL box and was able to
build successfully again. About one week later, we are seeing the error
again. Restarting AS creates some down time for other groups using it and is
not something we would like to do regularly. Can anyone provide some insight
as to what the root cause of this is? What can we to to find a perminate
solution to this error?
Thanks
P.S. we have SQL 2005 - SP3 CU 1 and OLE DB provider 9

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to process the Analysis Services database <cube
name> on the <name> server. Error: OLE DB error: OLE DB or ODBC error:
Unspecified error. Errors in the OLAP storage engine: An error occurred while
processing the 'Assignment Timephased' partition of the 'Assignment
Timephased' measure group for the 'Assignment Timephased' cube from the <cube
name> database. Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully. Server: The
operation has been cancelled.

 

[Jack Dahlgren MVP]

Any special characters (, - / ( ) are common and all can cause problems) in
the resource or task names?
That can cause cube build problems. SQL server sees them as part of the
statement.

-Jack Dahlgren

 

[Micah]

I'm having a hard time following how a special character could be the root
cause because the cube will build after Analysis Services is restarted. Is
this just another Microsoft tool that needs to be rebooted once in a while?
Does anyone else have to restart, or could other jobs we have for AS be
causing this?

 

[Gerard Wojcik]

Check this blog

http://blogs.msdn.com/brismith/arch...ild-error-messages-you-might-come-across.aspx

 

[Micah]

Thanks for the blog link, but unfortunatly it does not apply to our
situation. While it is the same error we are seeing, the blog says this is a
time out error. The solution it gives is to make the time out deley longer.
The default setting is 3600 seconds, which is when ours in timing out. But
when AS is restarted, it takes 10-15 minutes to build. My SQL people are
telling me AS looks like it is processing, but never goes anywhere. I just
relized that I migrated a few projects from 03 to 07 yesterday and the last
time we got this error was the day after (cube builds at 11:30 pm) I migrated
a different set of projects. Any chance that migration is causing this?

 

[Jack Dahlgren MVP]

Could be something migrated funny. Could be that the time you have for
processing is in conflict with some other process?

-Jack