Re: DSO ERROR

From: hooli (steffibev_at_hotmail.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 11:12:35 +0800

David,
Thanks for replying.
About the "lock" issue, I can understand what you mean.
But another question ," multi-user concurrently process different partition
in same cube "
is it impossible fo MSAS?
Can you show me the other way to do that ?
Any suggestion will be appricated.

"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> ¦b¶l¥ó
news:ubjxPFkAFHA.2180@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...
First, when running the PPU, you should ensure that no other administrator
is running Analysis Manager, or you will start to see locking on the
repository. The PPU has a facility to ensure that no two instances of the
ProcessPartition will conflict, but it doesn't know about AM. Analysis
Manager places locks are a very high level and thus can easily conflict with
other users.

With regards to whether or not two users can be processing the same cube;
the answer is No. 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"hooli" <hoolihome@yahoo.com.tw> wrote in message
news:8AD204C5-1B1E-48CE-945D-30CB17F0DEBB@microsoft.com...
> hi,
> I have a cube with  60 partitions , sliced by department and YearMoth
> ( 5 dept. and 12 months a year).
> Each departmemnt use parallel processing utility 3.0.61 to full rebuild
> their partition randomly.(It means they maybe process their partition
> concurrentlly)
> Sometimes the processes Success, and sometimes fail with below errors
> "Processing error because Object variable or With block variable not set
> (#91;DSO)" or
> "Attempting to connect to server: OLAPSVR because user OLAPSVR\ss01 on
> computer
> KLPDCS03 has locked 'Repository'? Description: Internal Repository has
> locked (#-2147221468;DSO)"
>
> I think parallel processing utility could do multi-partition process in a
> cube , but
> Is it possible to let multi-user concurrently process their partition in a
> cube?
>
> The client's environment is  SQL SERVER 2000 SP3 and Analysis Serives
> SP3(only DSO component). And  a DTS package to run the PPU  .
>
> Thanks again.
>
> "Dave Wickert [MSFT]" wrote:
>
> > Are you running the latest version?
> >
http://www.microsoft.com/downloads/details.aspx?FamilyID=a2eef773-6df7-4688-8211-e02cf13cbdb4&DisplayLang=en
> >
> > -- 
> > Dave Wickert [MSFT]
> > dwickert@online.microsoft.com
> > Program Manager
> > BI SystemsTeam
> > SQL BI Product Unit (Analysis Services)
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Steffi" <steffibev@hotmail.com> wrote in message
> > news:eRUaLb2$EHA.1400@TK2MSFTNGP11.phx.gbl...
> > > hi,
> > > I use parallel process utility to process a partition and sometimes
get
> > > errors code (#91 DSO).
> > > In which help file I can get the detail error message
> > >
> > > Thanks
> > >
> > >
> >
> >
> >

Relevant Pages

  • Re: DSO ERROR
    ... The PPU goes to great pains to prevent that from ... > With regards to whether or not two users can be processing the same cube; ... > Program Manager ... >> their partition randomly.(It means they maybe process their partition ...
    (microsoft.public.sqlserver.olap)
  • Analysis Server Incremental Update on Changing Dimensions
    ... Error during lazy aggregation of partition ... Broadcast_Response_2004_07 in cube Broadcast_Response: ... Microsoft Gold Certified Partner for Business Intelligence ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Server Incremental Update on Changing Dimensions
    ... Error during lazy aggregation of partition ... Broadcast_Response_2004_07 in cube Broadcast_Response: ... incrementally update our changing Dimensions everyday. ...
    (microsoft.public.sqlserver.olap)
  • Re: Several Partitions vs Several Cubes
    ... > the work required to "merge" these cubes into 1 virtual cube and create ... With the partition option you must reprocess all partitions, ... > districts ("all districts" not available and no district comparison ...
    (microsoft.public.sqlserver.olap)
  • Re: Validating a cube prcoessing job
    ... thanks for the reply Dave. ... Then have your application bind to the cube ... > Being able to "unprocess" a partition is a new feature in 2005. ... >> Think of this as commiting a transaction in SQL. ...
    (microsoft.public.sqlserver.olap)
Loading