Analysis Server Hangs

Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.Hi enigma,
Do you meant to say by seeing in'Task Manager/ Application'. showing 'Not Responding' ? You try watch using performance counter/AS:Proc:,AS:Agg.Proc objects, after some time, you will get some values related to that. In my case also, I was getting 'this hanging sort of things' but actually it is not.
HTH
====

Originally posted by Enigma
Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.|||Thanks Man,

I was doing exactly the thing you said ... well .. i processed the cube using a DTS yesterday and that worked perfectly fine .

Thanks for all your help

An internal consistency error occurred..

Hi all,
i have copied out the database backup from development center to my local machine,it is having approx.8GB in size and when
i m trying to restote this database backup in SQL Server 2000 it is showing me error.
An internal consistency error occurred. Contact Technical Support for assistance.
RESTORE DATABASE is terminating abnormally.
Plz. anyone can help me..

mukul:confused:Run RESTORE VERIFYONLY to ensure the backup is valid, and KBA http://support.microsoft.com/kb/268481 for further information. Try getting another set of backup to assure the source database server hardware is intact.|||Hi Satya,
i have run RESTORE VERIFYONLY command and after this is showing following msg-
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'g:\backup\projectServer\ProjectServer_db_20070709 0000.bak' is not a valid Microsoft Tape Format backup set.Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
then what is this mean?
plz. help me out..