Hi all,
I have two DTS that contain one DTSOlapTask objects for each to process
two
different cubes, one object is set up for a incremental update and the
other
in refresh data process mode. The cubes reside in same OLAP DB and on
the
same OLAP server (Analysis Server 2000). Moreover they share a
datasource at
least and sometime one or more dimensional tables (no fact tables are
shared).
If I run the DTS simultaneously the cube processed in incremental
update will
be locked by the other that is processed in refresh data mode.
Here there is the last error that SQL Server 2000 gave me today
processing
the cube in incremental update mode:

Step Error Source: DSO
Step Error Description:User <user> on computer <computer> has locked
<fact
table>.
Description: Locked object <fact table> for processing by Analysis
Services
Processing Task.
Step Error code: 80040024
Step Error Help File:
Step Error Help Context ID:1000440

where <fact table> is the fact table of the other cube processed in
refresh
data mode.
How can a fact table lock another cube where there are no relationships
with
it ?
This error is random and can be associated to the dimensions of the
cube in
incremental update mode too.
Can anybody help me ?

PS: sorry for my english... hoping that I explained my problem in a
comprehensive way.
Thanks in advance