dbTalk Databases Forums  

use DSO to Merge partition error when open with Analysisi Mananger

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss use DSO to Merge partition error when open with Analysisi Mananger in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Microlong
 
Posts: n/a

Default use DSO to Merge partition error when open with Analysisi Mananger - 04-05-2005 , 03:35 AM






hi, everyone, Do you have such experience on this case? I use dso to merge
partition, but I got error when this cube opened with Analysis Manager? Is
there an lock this cube to protect not be merged? Is there any method to
avaid it in DSO?

Microlong
--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote
  #2  
Old   
Arun
 
Posts: n/a

Default Re: use DSO to Merge partition error when open with Analysisi Mananger - 04-05-2005 , 07:43 AM






Can you post the code that you have used to merge partitions ? May be
looking at that may throw some light.


Reply With Quote
  #3  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: use DSO to Merge partition error when open with Analysisi Mananger - 04-07-2005 , 07:20 PM



Analysis Manager places high level locks on objects once it opens a
database/cube.
It does not allow multiple administrators looking at the same structure.
Since it uses DSO, it locks out DSO operations as well. If you have two DSO
applications, concurrency is better as DSO natively doesn't lock that
much -- it is AM doing the locking.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

"Microlong" <Microlong (AT) email (DOT) com> wrote

Quote:
hi, everyone, Do you have such experience on this case? I use dso to merge
partition, but I got error when this cube opened with Analysis Manager? Is
there an lock this cube to protect not be merged? Is there any method to
avaid it in DSO?

Microlong
--
Developer
QA Dashboard
Microsoft China Development Centre



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.