Error While Processing the Cube.

Question

Error While Processing the Cube.

Naveen Kumar Reddy

Valued Member

Points: 66
More actions
September 10, 2007 at 7:08 pm

#118588

Hi,
I am facing some error while Processing the cubes in Sqlserver 2000 Standard Edition.The error message are as below.
Step Error Source: DSO
Step Error Description:Cannot open connection to Analysis server 'xxxxxxx'.
Cannot connect to the server 'xxxxxxx'. The server is either not started or too busy.
Step Error code: 80040050
Step Error Help File:
Step Error Help Context ID:1000440
As ours is production support the cubes will be running everyday.For the past few month we are facing the same error.I had tried doing the performance tunning by adjusting the aggrigations using Design Storage.But of no use we are facing the above problem weekly twice or trice.Could somebody suggest what can i do for stopping the above error.
Thanks in advance.... Naveen

Viewing 10 posts - 1 through 9 (of 9 total)

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

David Zebrowitz Right there with Babe Points: 739 More actions · Answer 1

Your post should be in the Analysis Services Section, but...

I've seen this error before, and it seems to be related to available RAM on the server. How much memory is installed on the MSAS server?

Also, are you initiating the cube processing from the server that has Analysis Services installed on it?

Naveen Kumar Reddy Valued Member Points: 66 More actions · Answer 2

Thanks for you Reply

We has ram size as 3.71 GB.The memory instaled is 404 GB.Yes i am initiating the cube process from the same server where Analysis Services is installed.One thing i need to add the service pack we are using is AS1.

Thanks..Naveen

David Zebrowitz Right there with Babe Points: 739 More actions · Answer 3

Are running SQL 2000? If so, you need to upgrade to SP4.

Naveen Kumar Reddy Valued Member Points: 66 More actions · Answer 4

Once again thanks....

yes we are running SQL server 2000.Ok we will upgrade it toSP4.

Mean while can you tell me temprary solution for this because it is continously failing for past 3 days.

Thanks Naveen

David Zebrowitz Right there with Babe Points: 739 More actions · Answer 5

There were a lot of major issues fixed by all of the service packs that you are missing. I really do not think there is not a temporary fix that you can use. I would apply SP4 and hopefully that fixes the problem. If not, then we can explore other solutions.

When installing SQL 2000 SP4, be aware that there are two SP4 downloads. One for SQL 2000 and one specifically for Analysis Services. I would apply both of these service packs to the server AND and client PC's that have Enterprise Manager or Analysis Services installed.

Does the cube fail when you process it manually, or just when it's scheduled? If it runs ok when you process it manually, then maybe you should have someone manually start the database process tonight.

Naveen Kumar Reddy Valued Member Points: 66 More actions · Answer 6

Thanks for you information...

The cube is failing when it is scheduled and when i run it manually.

I run the cube manually when it fails to run through schedule.The cube fails processing when it is having more data coming through?Because when i start the cube it is giving that estimated rows. but my cube is exceding the rows.

Thanks.. Naveen

David Zebrowitz Right there with Babe Points: 739 More actions · Answer 7

It's common for the cube to exceed the estimated number of rows. If you edit the cube you will see a rowcount in the properties for the cube. You can click the button there to re-count the number of rows. After the rows are recounted, it will show the correct number of rows when manually processing the cube. This would not cause the error you are seeing though.

The rowcounts for dimension levels and cubes are used to design aggregations, and wouldn't have anything to do with loosing the connection to the server.

Naveen Kumar Reddy Valued Member Points: 66 More actions · Answer 8

Thanks for your response...

I think the only solution is to upgrade to SP4..

While manually refresheing the cube i monitered carefully the partitions are doing .the problem occurs at only while wrting the Aggrigation and indexes only every time it is failing at that time and it is failing at lat aggrigation.

Thanks.. Naveen

David Zebrowitz Right there with Babe Points: 739 More actions · Answer 9

Just found this... there is a HotFix rollup for Analysis Services 2000 which should be applied after SP4 is installed: http://support.microsoft.com/kb/907323/en-us