I am trying to refresh the data in a cube (with only private dimensions).

I do a full process in A/S MMC and it works no problem.

I then try using DSO in vb.NET to process the cube again (refresh data). It
works.. ONCE.

If I try to run the DSO again, whether or not the fact table has changed, it
always errors! The error I get in the try / catch is blank as well. No #,
no message/description.

When I process again in A/S I can then do another single DSO process.

This is a part of the code...

dsoCube = dsoDb.MDStores.Item("MyCubeDB")
dsoExistingPartition = dsoCube.MDStores.Item("MyCube")

dsoExistingPartition.Process(ProcessTypes.processR efreshData)

dsoServer.CloseServer()

dsoExistingPartition = Nothing

dsoCube = Nothing

dsoDb = Nothing

dsoServer = Nothing

I dont want to merge the data since its not an incremental update. I want
to reprocess the full cube.

I get the same "error" whether its a full or refreshdata.

Thanks.

I found the erro # this time by removing the ex As Exception of the
Try/Catch

The Err.Number is: -2147221411
And when you set it to the DSO errors it means: mderrChildProcessFailed

MSDN is terrific with its description: A child process failed within a
transaction.

Any ideas on how to fix it / cause of the problem?

"PCH" <pch12 (AT) hotmail (DOT) com> wrote

I've now tried creating a temp partition to replace the other. I still get
the same error :-\

dsoTmpPartition = dsoCube.MDStores.AddNew("~tmpMyCube")

dsoExistingPartition.Clone(dsoTmpPartition, CloneOptions.cloneMinorChildren)

dsoTmpPartition.Process(ProcessTypes.processFull)

If dsoTmpPartition.EstimatedRows > 0 Then

dsoDb.MDStores.Add(dsoTmpPartition, "MyCube", dsoExistingPartition)

End If



"PCH" <pch12 (AT) hotmail (DOT) com> wrote

bueller?

"PCH" <pch12 (AT) hotmail (DOT) com> wrote

I can't reproduce in my environment. What version of AS are you using and
what version of the .NET Framework? I'm using .NET Framework v1.0.3705 and
SP3 of AS. In other words, I don't have a clue.

"PCH" <pch12 (AT) hotmail (DOT) com> wrote

I had a similar problem, It worked fine when I asked to make a full process
on each dimension before re-process the cube.

for each dsoDim in dsoCube.dimensions
dsoDim.Process(ProcessTypes.somethingfull...)
next

apparently, I had a parent/child dimension not up-to-date with the key in
the fact table.

Christophe
remove nospam to mail me.

"PCH" <pch12 (AT) hotmail (DOT) com> wrote