Hi,
We have a 32bit development olap server and a 64bit Itanium server that we
host production cubes on.
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 64bit machine
to manage cubes, we control everything from the 32bit 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.
I have found a few articles that say if the OLAP repository has been
migrated to SQL server, it might be a permission issue, but i am an admin on
all the machines.

Does anyone have any ideas.

thanks,
Troy

Hello Troy,

How do you restore the database. Did you try to restore it to a UNC path on
64 bit machine? You may want to map the path to a unused drive on 32 bit
machine to avoid any conflicts. Also, what is the exact error message you
encounter?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

================================================== ===




This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Hi Peter,
Using regedit, I set the temp and root dir for the 64bit machine to the UNC
path for the data drive. \\server\drive\folder (note this path is resolvable
by the 32bit machine)

Then I register the 64bit machine in the 32bit analysis manager machine,
select the 64bit machine and restore the database. all seems to go fine
until the end.

DSO funcation failed the one message
the other is "An Invalid path has caused the Analysis Manager to stop
responding"

thanks, Troy

"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote

Hello Troy,

It seems to be data corruption in the cube restoration file (cab). Can you
browse cube data though the issue occurred? If so, a full process all
cubes and dimensions fixed similar problems.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Hi, I fixed my problem.
Since I was having multiple servers and multiple cubes fail, I didn't think
it was a corruption problem.
On the 32bit machine, I found that I couldn't connect to the remote registry
on the 64bit machine, so I starting looking at the service pack and hot
fixes.

I removed service pack 1 for windows server 2003 and that did the trick. I
reapplied the security fixes.

Troy



"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote