Has anyone tried starting 3 to 5 Cube partition processes initiated at
the same time? I get errors saying the cube is locked. I can start
processing the partitions with a delay of about 10-20 secs.

They can process at the same, but they can't start processing at the
same time.

Is there a way to create a partition without locking the cube for the
first few seconds?

We use vbscript in a dts package to process our partitions.


Thanks.

Not to my knowledge. This is a requirement. The Parallel Processing Utility
and the DTS packages generated by SSABI use a mutex to ensure that there is
only one begin transaction and commit transaction is occurring at a time.
--
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.

"mdx_newbie" <zoravars (AT) khalsa (DOT) com> wrote

I was playing around with the ParallelProcess manager that comes with
the resource kit. I noticed if i set 4+ partitions to process at once
1 or more partition processing fails. If i restart it, it'll
start/finish successfully. Again the logs say there was a lock on the
cube. I also noticed in the ProcessLogs that even though many of the
partitions initiated from the ParallelProcess Manager, the timings in
the log were off a few secs. So if partitions 1, 2, 3, 4, 5, 6 were
started at once the log shows a slight (2-3) delay between each
partition processing.

So could there be a registry setting that could allow cube partition
re-processing requests to be queued if the partition is temporarily
locked? I know i'm reaching, but i thought i'd atleast ask.

The only way i can think about working around this is try connecting
to the cube, if it's locked then wait 15 secs and try again. Not sure
how to do this yet, but if you have any suggesstions please let me
know.

We're going to have some folks from Microsoft come in to re-configure
our SQL server and our Analysis server next month, but I don't want to
delay this untill then.

Please share your thoughts.

thanks..




"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Here is a link to an updated version which addresses those problems:

http://www.microsoft.com/downloads/d...DisplayLang=en

--
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.

"mdx_newbie" <zoravars (AT) khalsa (DOT) com> wrote