|
|
||||||
|
#1
03-23-06, 05:36 AM
|
|
|
|
|
Ours is a clustered environment. The analysis server is online in passive
node and SQL server is online in active node. We have about 30 cubes and we are facing some major problem with our anlaysis server for quite sometime now. We are not able to save changes to the cube or create a new cube. the analysis manger goes to not responding state and task manager shows nil resource utilization. recycling the analysis services from cluadmin didn't help. restarting both nodes of the cluster resolves the issue. but then not for too long. within a couple of days the problem starts again. We are not sure of the root cause of the issue. and do not know the solution too. We are in need of urgent help. do any of you have any suggestions? |
|
|
|
#2
03-24-06, 07:45 PM
|
|
|
|
|
We have a clustered enivronment on 2 SQL Servers that are 64bit itaniums. We
had similar problems where Analysis Manager would hang and we would have to failover the Analysis Server; which would work for awhile. We eventually worked out that the problem was the underlying query was not joining all tables and therefore trying to return millions of rows. This was under ROLAP storage. There is a problem using ROLAP on itanium machines I think. We haven't had the problem since converting to MOLAP. Hope this helps, Ken "OLAP User" wrote: [..] |
|
|
| Similar Threads | |
| Analysis manager unable to connect Analysis server I am new not sure about the issue but Analysis manager unable to connect Analysis server may be Olap Administration issue and how to become member of Olap Administrator can... |
|
| Multi year analysis using Analysis Manager Hey, I am trying to create dimensions using data that contains multiple years so we can analyze current period to past periods. Any suggestions on how I can accomplish... |
|
| Connecting to a remote Analysis Server via the Internet using Analysis Manager Hi guys, Strictly using Analysis manager, is it possible to connect to and manage a remote analysis server sitting on the internet? Allen Firth allenNOSPAM |
|
| Memory Analysis after Hanging We are running a script to load text files into 8 MySQL tables. Each text file contains tens of thousands of lines, each line containing pipe seperated values. The script... |
|
| Cannot brows or Register Analysis Server in Analysis Manager. Well, After installing MS Sql Server/Analysis Server patch 3 , I cannot connect to Analysis Server through Analysis Manager. It says "Unable to connect to the registry on... |
|
|
All times are GMT. The time now is 09:52 AM. | Privacy Policy
|
Analysis Manager Hanging