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 |