Cubes Missing from Data Warehouse and throwing error from within the SCSM Console

Posted: February 27, 2013 in Service Manager
Tags: , , , ,

So, just the other day I opened the SCSM console to look at the cubes and process as needed, since some new reports needed to be built and Excel spread sheets created by our BI person for business. So, I start to process the cubes and the first cube starts processing without issue. However when I attempt to process the second cube (Change and Activity Management cube). It presented an error stating that "Could not find any resources appropriate for the specified culture or the neutral culture".

I have never seen an error like this before, so it was time to do some investigating.

I started by looking at the Data Warehouse Wunderbar and more specifically the “Data Warehouse Jobs” tab. I noticed that all the Cubes which were giving me said error where missing from the “Data Warehouse Jobs” tab.

I then remembered about a Patch Window that occurred while I was on leave and decided to look further. I was digging through the Event Logs, when I found the following error

Event id: 33410

Source : Deployment

image

And as you can see from the screenshot, there are plenty of these. Clearly the patching window had interrupted a job. So now with at least something to work with, I started looking around some more and remembered that the MPSyncJOB is responsible for Management Pack Synchronization and upon opening the status of this job, I saw that the Management Packs related to the now problematic cubes were disassociated.

So, from here it was time to check and start putting the pieces of the puzzle together. Upon opening the “Management Pack” section of the “Data Warehouse” Wunderbar, I could see that the deployment of these Management Packs had failed.

SNAGHTML53c4c56

So, the next step is to “Restart Deployment”

SNAGHTML54834f0[4]

With mine, nothing happened and I found the following error

image

Fortunately enough the solution is listed within the error message.

Simple, delete the cube and then re-deploy the Management Pack.

1. Open SQL Management Studio on server hosting the SQL Analysis Services

2. Connect to the server type : Analysis Services

image

3. Expand Databases, expand DWASDataBase, Expand Cubes

image

4. Select cube from error and delete the Cube.

image

The deletion of the cube can take some time. Once Deleted, go back to the Console and “Restart Deployment”

SNAGHTML552e490

This time you will see an Event log like this.

image

The Cube is now re-deploying.

image

You can now process your cubes as normal without any errors

(E-Mail me)

image_thumb_thumb_thumb_thumb_thumb

Follow me.

facebook-small322252222 Facebook (Personal)

twitter-small322252222Twitter (Personal & System Center)

scsmlogo25232 Twitter (System Center Focused)

MCC11_Logo_Horizontal_2-color_thumb_

Advertisements
Comments
  1. […] has to be deleted. This can easily be done with the SQL Management Studio. Fletcher Kelly wrote a nice blog post on how to resolve from this […]

  2. […] has to be deleted. This can easily be done with the SQL Management Studio. Fletcher Kelly wrote a nice blog post on how to resolve from this […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s