September 21, 2005 at 3:46 pm
We have a Windows 2000 SP 4 server running SQL Server 2000 SP3 Enterprise Edition, and Analysis Server SP 1 (Version 8.0.382).
Suddenly, the Analysis Server Manager seems to be acting weird. We go to the Cubes tree, and when you right click to edit the cube, nothing happens at all. When you go to the dimensions tree, we received the following message.
"Failed to load control 'PlatoCubeBrowser' from . Your version of may be outdated. Make sure that you are using the version of control that was provided with your application. This menu item is unavailable at this time."
No patches/hotfixes have been applied to this server recently to cause this to start occurring.
However, another issue which may not be related at all coincidentally started happening about the same time.
"Windows cannot load the user's profile but has logged you on with the default profile for the system.
DETAIL - The system has attempted to load or restore a file into the registry, but the specified file is not in a registry file format."
Any suggestions/recommendations would be appreciated.
-Edgar
September 21, 2005 at 5:45 pm
I would be moving to at least SP3 (3/3a is fine, SP4 is the latest) for Analysis Services. *Prior* to doing this, I would make sure that your repository is in MSSQL and *backed-up* and also back up your data directories (usually defaults to being in c:\program files\microsoft analysis services\Data but if you've used multiple disks yours may be elsewhere).
Working out *why* this has occured may not be easy - when did the SQL get SP3'd? I would be guessing that something has been installed thats knocked off (read as replaced with a nice newer version) one of your com dll's that AS uses to display tree controls and grid controls. I'd be going for "making it work" first and working out the cause second, especially being so far behind in service packs for AS.
HTH,
Steve.
September 21, 2005 at 8:28 pm
Steve: Thanks for the recommendation. That is inline with my thinking. This server has been rock solid on Windows 2K SP4, SQL Server 2K SP 3, and SQL AS SP1 for quite some time. Then suddenly, on 9/19 we saw the corrupt profile issue and the AS issue was discovered yesterday but it may have existed earlier. We discovered the issue with the AS while troubleshooting another issue with a SQL Agent Job that refreshes reports/cubes/dimensions that happened to have failed on 9/18. I looked at event logs all day without finding anything meaningful. Will be checking into SQL logs tomorrow.
Thanks again. Any other suggestions would be welcome as well.
Regards,
Edgar
October 7, 2005 at 9:00 am
HI, I have a simular problem, I cannot connect to the Analysis server from my client tool (Analysis Manager). I try to connect but get "Unable to connect to the registery on the server(CAP1WNSQL01), or you are not a memeber of the OLAP Admin group on this server"
Please help...thanks
Ryno
October 9, 2005 at 8:13 am
I think tis was a documented issue after uprading to SP3. You may want to check the readme for the service pack/s that you've applied, or alternatively do a quick google of the microsoft siteusing the error text.
Steve.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply