Tuesday, March 20, 2012

Analisys Services OLAP Error

running sql server 2000 w/ analisys serv sp4 on w2k3 sp1. Yes, also we are running sql 2000 sp4.

I keep getting an event id 6034.

The mssqlserverolapservice service terminated unexpectedly. It has done this 134 times.

Now, i went ahead and installed the suggested rollup hotfix already, which is a post AS SP4 rollup hotfix that fixes this.

It didn't.

What next?

Mike,

This is just one of the possible options:

I have seen this happening with corrupted database. To fix this, you have to find corrupted database and remove it from data folder. I was doing this:

1. Stop Analysis Services service.

2. Go to analysis services data folder and copy folder for one database to another outside folder. Also copy related file from root data folder (I think something like DBName.odb, forgot extension)?

3. Try to start analysis services, if same problem, choose another database and do step 2.

If you'll find corrupted databases, copy all other ones back. Restore corrupted database from backup.

Vidas Matelis

sql

No comments:

Post a Comment