November 19, 2006 at 11:33 pm
We have a 32bit development Analysis server and a 64-bit Itanium server where we host production cubes. We build the cube on the 32bit machine, then archive the db, then restore to the 64bit machine. Since there are not any tools to run on the 64-bit machine to manage cubes, we control everything from the 32-bit machine.
when we restore a cube archive, we specify the remote machine's (64bit) data directory and the local machine path to the cab file (32bit). At then end of the restore operation to the 64bit machine, we are getting DSO function failed (An invaild path has caused analysis server to stop responding) error.
Recently after applying windows 2003 SP1 on the 32-bit server, we are facing this error but if you remove the SP1 it works with no issue. for the security compliant we need to have SP1 installed.
Please let me know if anyone has come across this issue and aware of the fix. It will be great help to me.
Thanks a lot in advance.
Regards
Shriniwas
November 20, 2006 at 4:04 am
Hi,
We had the same problem and MS created a specific Hotfix. The problem is related with WOW (Windows-on-Windows) on the 64-bit. After installing W2K3 SP1 on the 32-bit server, it starts looking for the "OLAP Server" key of the destination server (64-bit) in WOW section of the registry instead of the original section.
See http://blogs.msdn.com/greggm/archive/2004/03/09/86766.aspx and http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b305097.
Be aware, that although the restore seams to fail it works without any problem, but this is not a solution for production.
Contact MS to get that fix, meanwhile you can manually copy the key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server" to "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\OLAP Server" or if possible use a W2K3 server without SP1 or any using XP.
DO NOT FORGET TO DELETE THE KEYS CREATED AFTER INSTALLING MS' HOTFIX.
Be also aware, that if you do any configuration's changes you must ensure that both keys are synchoronized!
As always if you do not feel confortable chaning the registry use the other solutions.
Tiago.
November 20, 2006 at 4:53 am
See also http://support.microsoft.com/kb/916097.
November 20, 2006 at 5:08 am
Thank you so much for the correct information.
Do I need to do the registry changes on 32-bit server?
And also do you have any link for the fix in microsoft site.
Regards
Shriniwas
November 22, 2006 at 6:16 am
All of the registry changes are done on the 64-bit server.
The only link I have is http://support.microsoft.com/kb/916097, try contact your MS's contact person.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply