dbTalk Databases Forums  

Error during incremental update

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


Discuss Error during incremental update in the microsoft.public.sqlserver.olap forum.



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

Default Error during incremental update - 03-12-2005 , 07:15 AM






Hi all

I get a DSO ChildProcessFailed error ( HR = 0x8004005D ) when I do
incremental update of a cube programmatically. When I do incremental update
through Analysis Manager with the same where clause everything works fine.
All other cubes also get updated ok with the same code. The code for
processing is in C# using DSO through COM interop. Here it is:

public void UpdateCube( string sCube, string sFromClause )
{
Cube cube;
Partition tempPartition;
Partition partition;
string sTempPartition = "~" + sCube;
cube = (Cube) m_Db.Cubes.Item( sCube );
partition = (Partition) cube.MDStores.Item( sCube );
tempPartition = (Partition) cube.MDStores.AddNew( sTempPartition,
DSO.SubClassTypes.sbclsRegular );
partition.Clone( (ICommon)tempPartition, CloneOptions.cloneMajorChildren );
tempPartition.set_Where( ref sFromClause );
tempPartition.Process( ProcessTypes.processFull );
partition.Merge( sTempPartition );
}

What is different from other cubes is the fact table can contain duplicate
rows. Can that be the reason?
(AS 2000 sp3)

Thanks
Plamen



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.