MS SQL Server OLAP - DSO function failed

Author

DSO function failed

Troy Sherrill

2005-04-22, 8:24 pm

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

Peter Yang [MSFT]

2005-04-25, 3:23 am

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.

--------------------
| From: "Troy Sherrill" <tsherrill@nc.rr.com>
| Subject: DSO function failed
| Date: Fri, 22 Apr 2005 16:21:02 -0400
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <uHIwCh3RFHA.2348@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.olap
| NNTP-Posting-Host: cpe-024-025-016-079.nc.res.rr.com 24.25.16.79
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:10991
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| 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
|
|
|

Troy Sherrill

2005-04-25, 9:24 am

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\folde
r (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@online.microsoft.com> wrote in message
news:Myu8pHWSFHA.4976@TK2MSFTNGXA01.phx.gbl...
> 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.
>
>
> --------------------
> | From: "Troy Sherrill" <tsherrill@nc.rr.com>
> | Subject: DSO function failed
> | Date: Fri, 22 Apr 2005 16:21:02 -0400
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <uHIwCh3RFHA.2348@TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.olap
> | NNTP-Posting-Host: cpe-024-025-016-079.nc.res.rr.com 24.25.16.79
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:10991
> | X-Tomcat-NG: microsoft.public.sqlserver.olap
> |
> | 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
> |
> |
> |
>

Peter Yang [MSFT]

2005-04-26, 3:23 am

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.

--------------------
| From: "Troy Sherrill" <tsherrill@nc.rr.com>
| References: <uHIwCh3RFHA.2348@TK2MSFTNGP09.phx.gbl>
<Myu8pHWSFHA.4976@TK2MSFTNGXA01.phx.gbl>
| Subject: Re: DSO function failed
| Date: Mon, 25 Apr 2005 09:14:50 -0400
| Lines: 90
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OqDe4gZSFHA.2964@TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.olap
| NNTP-Posting-Host: cpe-024-025-016-079.nc.res.rr.com 24.25.16.79
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:11020
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| 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\folde
r (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@online.microsoft.com> wrote in message
| news:Myu8pHWSFHA.4976@TK2MSFTNGXA01.phx.gbl...
| > 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.
| >
| >
| > --------------------
| > | From: "Troy Sherrill" <tsherrill@nc.rr.com>
| > | Subject: DSO function failed
| > | Date: Fri, 22 Apr 2005 16:21:02 -0400
| > | Lines: 22
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | Message-ID: <uHIwCh3RFHA.2348@TK2MSFTNGP09.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.olap
| > | NNTP-Posting-Host: cpe-024-025-016-079.nc.res.rr.com 24.25.16.79
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:10991
| > | X-Tomcat-NG: microsoft.public.sqlserver.olap
| > |
| > | 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
| > |
| > |
| > |
| >
|
|
|

Troy Sherrill

2005-04-27, 8:25 pm

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@online.microsoft.com> wrote in message
news:NESTvGhSFHA.4172@TK2MSFTNGXA01.phx.gbl...
> 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.
>
>
> --------------------
> | From: "Troy Sherrill" <tsherrill@nc.rr.com>
> | References: <uHIwCh3RFHA.2348@TK2MSFTNGP09.phx.gbl>
> <Myu8pHWSFHA.4976@TK2MSFTNGXA01.phx.gbl>
> | Subject: Re: DSO function failed
> | Date: Mon, 25 Apr 2005 09:14:50 -0400
> | Lines: 90
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <OqDe4gZSFHA.2964@TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.olap
> | NNTP-Posting-Host: cpe-024-025-016-079.nc.res.rr.com 24.25.16.79
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:11020
> | X-Tomcat-NG: microsoft.public.sqlserver.olap
> |
> | 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\folde
r (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@online.microsoft.com> wrote in message
> | news:Myu8pHWSFHA.4976@TK2MSFTNGXA01.phx.gbl...
> | > 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.
> | >
> | >
> | > --------------------
> | > | From: "Troy Sherrill" <tsherrill@nc.rr.com>
> | > | Subject: DSO function failed
> | > | Date: Fri, 22 Apr 2005 16:21:02 -0400
> | > | Lines: 22
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | > | Message-ID: <uHIwCh3RFHA.2348@TK2MSFTNGP09.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.olap
> | > | NNTP-Posting-Host: cpe-024-025-016-079.nc.res.rr.com 24.25.16.79
> | > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:10991
> | > | X-Tomcat-NG: microsoft.public.sqlserver.olap
> | > |
> | > | 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
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>

Sponsored Links